为图表设置数据源
Contents
[
Hide
]
在我们之前的主题中,我们已经提供了许多示例,演示了如何为图表设置数据源,但在本主题中,我们将提供有关可为图表设置的数据类型的更多详细信息。
设置图表数据
使用Aspose.Cells处理图表时,有以下两种数据类型需要处理:
- 图表数据。
- 类别数据。
图表数据
图表数据是我们用作图表数据源的数据。我们可以通过调用 SeriesCollection 对象的 Add 方法来添加包含图表数据的单元格范围。
This file contains 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
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Create directory if it is not already present. | |
bool IsExists = System.IO.Directory.Exists(dataDir); | |
if (!IsExists) | |
System.IO.Directory.CreateDirectory(dataDir); | |
// Instantiating a Workbook object | |
Workbook workbook = new Workbook(); | |
// Adding a new worksheet to the Excel object | |
int sheetIndex = workbook.Worksheets.Add(); | |
// Obtaining the reference of the newly added worksheet by passing its sheet index | |
Worksheet worksheet = workbook.Worksheets[sheetIndex]; | |
// Adding sample values to cells | |
worksheet.Cells["A1"].PutValue(50); | |
worksheet.Cells["A2"].PutValue(100); | |
worksheet.Cells["A3"].PutValue(170); | |
worksheet.Cells["A4"].PutValue(300); | |
worksheet.Cells["B1"].PutValue(160); | |
worksheet.Cells["B2"].PutValue(32); | |
worksheet.Cells["B3"].PutValue(50); | |
worksheet.Cells["B4"].PutValue(40); | |
// Adding sample values to cells as category data | |
worksheet.Cells["C1"].PutValue("Q1"); | |
worksheet.Cells["C2"].PutValue("Q2"); | |
worksheet.Cells["C3"].PutValue("Y1"); | |
worksheet.Cells["C4"].PutValue("Y2"); | |
// Adding a chart to the worksheet | |
int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 5, 0, 15, 5); | |
// Accessing the instance of the newly added chart | |
Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex]; | |
// Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B4" | |
chart.NSeries.Add("A1:B4", true); | |
// Saving the Excel file | |
workbook.Save(dataDir + "output.xls"); |
分类数据
类别数据用于标记图表数据,并且可以通过其 CategoryData 属性添加到 SeriesCollection 中。下面提供了一个完整的示例,演示了如何使用图表和分类数据。执行以上示例代码后,工作表将添加一个柱状图,如下所示。
This file contains 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
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Create directory if it is not already present. | |
bool IsExists = System.IO.Directory.Exists(dataDir); | |
if (!IsExists) | |
System.IO.Directory.CreateDirectory(dataDir); | |
// Instantiating a Workbook object | |
Workbook workbook = new Workbook(); | |
// Adding a new worksheet to the Excel object | |
int sheetIndex = workbook.Worksheets.Add(); | |
// Obtaining the reference of the newly added worksheet by passing its sheet index | |
Worksheet worksheet = workbook.Worksheets[sheetIndex]; | |
// Adding sample values to cells | |
worksheet.Cells["A1"].PutValue(10); | |
worksheet.Cells["A2"].PutValue(100); | |
worksheet.Cells["A3"].PutValue(170); | |
worksheet.Cells["A4"].PutValue(200); | |
worksheet.Cells["B1"].PutValue(120); | |
worksheet.Cells["B2"].PutValue(320); | |
worksheet.Cells["B3"].PutValue(50); | |
worksheet.Cells["B4"].PutValue(40); | |
// Adding sample values to cells as category data | |
worksheet.Cells["C1"].PutValue("Q1"); | |
worksheet.Cells["C2"].PutValue("Q2"); | |
worksheet.Cells["C3"].PutValue("Y1"); | |
worksheet.Cells["C4"].PutValue("Y2"); | |
// Adding a chart to the worksheet | |
int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 5, 0, 15, 5); | |
// Accessing the instance of the newly added chart | |
Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex]; | |
// Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B4" | |
chart.NSeries.Add("A1:B4", true); | |
// Setting the data source for the category data of SeriesCollection | |
chart.NSeries.CategoryData = "C1:C4"; | |
// Saving the Excel file | |
workbook.Save(dataDir + "output.xls"); |