Syncfusion.XlsIO.Base
Example 


CategoryLabel Property (IChartCategory)

Gets the category label for the chart. Read only.
Syntax
'Declaration
 
ReadOnly Property CategoryLabel As IRange
'Usage
 
Dim instance As IChartCategory
Dim value As IRange
 
value = instance.CategoryLabel
IRange CategoryLabel {get;}
Example
The following code illustrates how to access the IChartCategory from IChartCategories object and display its category labels address.
using Syncfusion.XlsIO;
using System;
            
class Program
{
    static void Main(string[] args)
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create worksheet
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet sheet = workbook.Worksheets[0];
            
            //Add data
            sheet.Range["A1"].Text = "Jan";
            sheet.Range["B1"].Text = "Feb";
            sheet.Range["C1"].Text = "Mar";
            sheet.Range["A2"].Value = "10";
            sheet.Range["B2"].Value = "20";
            sheet.Range["C2"].Value = "30";
            sheet.Range["A3"].Value = "15";
            sheet.Range["B3"].Value = "25";
            sheet.Range["C3"].Value = "35";
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:C3"];
            
            //Set chart type
            chart.ChartType = ExcelChartType.Column_Clustered;
            
            //Get chart categories collection
            IChartCategories categories = chart.Categories;   
            
            //Get chart second category
            IChartCategory category = categories[1];           
            
            //Displaying the labels address of the category object
            Console.WriteLine("Category labels address is:" + category.CategoryLabel.AddressLocal);
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
            Console.ReadKey();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also