Syncfusion.XlsIO.Base
Example 


DataTable Property (IChart)

Gets the IChartDataTable of the chart. Read-only.
Syntax
'Declaration
 
ReadOnly Property DataTable As IChartDataTable
'Usage
 
Dim instance As IChart
Dim value As IChartDataTable
 
value = instance.DataTable
IChartDataTable DataTable {get;}
Example
By default the visibility of data table is set to "false". Here for example, we set HasDataTable to "true" to enable data table and set IChartDataTable.HasBorders to "false" to hide the borders of data table.
using Syncfusion.XlsIO;
            
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";
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:C2"];
            
            //Set Chart data table
            chart.HasDataTable = true;
            IChartDataTable dataTable = chart.DataTable;
            
            //Set border
            dataTable.HasBorders = false;
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also