Syncfusion.XlsIO.Base
Example 


HasBorders Property (IChartDataTable)

True if the data table has outline borders. otherwise False. The default value is True.
Syntax
'Declaration
 
Property HasBorders As Boolean
'Usage
 
Dim instance As IChartDataTable
Dim value As Boolean
 
instance.HasBorders = value
 
value = instance.HasBorders
bool HasBorders {get; set;}
Example
The following code illustrates how to outline borders of IChartDataTable object.
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";
            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;
            
            //Enabling the data table
            chart.HasDataTable = true;
            
            //Get data table of the chart
            IChartDataTable dataTable = chart.DataTable;
            
            //Set false to remove the borders in data table
            dataTable.HasBorders = false;
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also