تعيين مصدر البيانات للمخطط
Contents
[
Hide
]
في مواضيعنا السابقة، قدمنا بالفعل العديد من الأمثلة لتوضيح كيف يمكنك تعيين مصدر بيانات لرسم بياني ولكن في هذا الموضوع، سنقدم المزيد من التفاصيل حول أنواع البيانات التي يمكن تعيينها للرسم البياني.
ضبط بيانات الرسم البياني
هناك نوعان من البيانات التي يجب التعامل معها عند العمل على الرسوم البيانية باستخدام Aspose.Cells للبايثون via .NET على النحو التالي:
- بيانات الرسم البياني.
- بيانات الفئة.
بيانات الرسم البياني
بيانات الرسم البياني هي البيانات التي نستخدمها كمصدر لبناء الرسوم البيانية الخاصة بنا. يمكننا إضافة مجموعة من الخلايا (تحتوي على بيانات الرسم البياني) عن طريق استدعاء SeriesCollection إلى add.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import Workbook | |
| from aspose.cells.charts import ChartType | |
| from os import os, path | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # The path to the documents directory. | |
| dataDir = RunExamples.GetDataDir(".") | |
| # Create directory if it is not already present. | |
| IsExists = path.isdir(dataDir) | |
| if notIsExists: | |
| os.makedirs(dataDir) | |
| # Instantiating a Workbook object | |
| workbook = Workbook() | |
| # Adding a new worksheet to the Excel object | |
| sheetIndex = workbook.worksheets.add() | |
| # Obtaining the reference of the newly added worksheet by passing its sheet index | |
| worksheet = workbook.worksheets[sheetIndex] | |
| # Adding sample values to cells | |
| worksheet.cells.get("A1").put_value(50) | |
| worksheet.cells.get("A2").put_value(100) | |
| worksheet.cells.get("A3").put_value(170) | |
| worksheet.cells.get("A4").put_value(300) | |
| worksheet.cells.get("B1").put_value(160) | |
| worksheet.cells.get("B2").put_value(32) | |
| worksheet.cells.get("B3").put_value(50) | |
| worksheet.cells.get("B4").put_value(40) | |
| # Adding sample values to cells as category data | |
| worksheet.cells.get("C1").put_value("Q1") | |
| worksheet.cells.get("C2").put_value("Q2") | |
| worksheet.cells.get("C3").put_value("Y1") | |
| worksheet.cells.get("C4").put_value("Y2") | |
| # Adding a chart to the worksheet | |
| chartIndex = worksheet.charts.add(ChartType.COLUMN, 5, 0, 15, 5) | |
| # Accessing the instance of the newly added chart | |
| chart = worksheet.charts[chartIndex] | |
| # Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B4" | |
| chart.n_series.add("A1:B4", True) | |
| # Saving the Excel file | |
| workbook.save(dataDir + "output.xls") |
بيانات الفئة
تُستخدم بيانات الفئة لوسم بيانات الرسم البياني ويمكن إضافتها إلى SeriesCollection باستخدام خاصية category_data. يتم تقديم مثال كامل أدناه لتوضيح استخدام بيانات الرسم البياني والفئة. بعد تنفيذ رمز المثال أعلاه، سيتم إضافة رسم بياني للأعمدة إلى ورقة العمل كما هو موضح أدناه.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import Workbook | |
| from aspose.cells.charts import ChartType | |
| from os import os, path | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # The path to the documents directory. | |
| dataDir = RunExamples.GetDataDir(".") | |
| # Create directory if it is not already present. | |
| IsExists = path.isdir(dataDir) | |
| if notIsExists: | |
| os.makedirs(dataDir) | |
| # Instantiating a Workbook object | |
| workbook = Workbook() | |
| # Adding a new worksheet to the Excel object | |
| sheetIndex = workbook.worksheets.add() | |
| # Obtaining the reference of the newly added worksheet by passing its sheet index | |
| worksheet = workbook.worksheets[sheetIndex] | |
| # Adding sample values to cells | |
| worksheet.cells.get("A1").put_value(10) | |
| worksheet.cells.get("A2").put_value(100) | |
| worksheet.cells.get("A3").put_value(170) | |
| worksheet.cells.get("A4").put_value(200) | |
| worksheet.cells.get("B1").put_value(120) | |
| worksheet.cells.get("B2").put_value(320) | |
| worksheet.cells.get("B3").put_value(50) | |
| worksheet.cells.get("B4").put_value(40) | |
| # Adding sample values to cells as category data | |
| worksheet.cells.get("C1").put_value("Q1") | |
| worksheet.cells.get("C2").put_value("Q2") | |
| worksheet.cells.get("C3").put_value("Y1") | |
| worksheet.cells.get("C4").put_value("Y2") | |
| # Adding a chart to the worksheet | |
| chartIndex = worksheet.charts.add(ChartType.COLUMN, 5, 0, 15, 5) | |
| # Accessing the instance of the newly added chart | |
| chart = worksheet.charts[chartIndex] | |
| # Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B4" | |
| chart.n_series.add("A1:B4", True) | |
| # Setting the data source for the category data of SeriesCollection | |
| chart.n_series.category_data = "C1:C4" | |
| # Saving the Excel file | |
| workbook.save(dataDir + "output.xls") |