Grafik için Veri kaynağını ayarla
Contents
[
Hide
]
Önceki konularımızda, grafiğiniz için bir veri kaynağını nasıl ayarlayabileceğinizi göstermek için birçok örnek vermiştik ancak bu konuda, bir grafik için ayarlanabilecek veri türleri hakkında daha fazla ayrıntı sağlayacağız.
Grafik Verilerini Ayarlama
Aspose.Cells’i kullanarak grafikler üzerinde çalışırken ele alınması gereken iki tür veri vardır:
- Grafik verileri.
- Kategori verileri.
Grafik Verileri
Grafik verileri, grafiklerimizi oluşturmak için veri kaynağı olarak kullandığımız verilerdir. Çağırarak bir hücre aralığı (grafik verileri içeren) ekleyebiliriz.Seri Koleksiyonu nesneninEklemekyöntem.
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"); |
Kategori Verileri
Kategori verileri, grafik verilerinin etiketlenmesi için kullanılır ve aşağıdakilere eklenebilir:Seri Koleksiyonu kullanarakKategoriVerileriEmlak. Grafik ve kategori verilerinin kullanımını göstermek için aşağıda eksiksiz bir örnek verilmiştir. Yukarıdaki örnek kodu çalıştırdıktan sonra, çalışma sayfasına aşağıda gösterildiği gibi bir sütun grafiği eklenecektir.
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"); |