Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IChartInterior Interface : BackgroundColorIndex Property

BackgroundColorIndex Property (IChartInterior)

Gets or sets the index of background color in ExcelKnownColors.
Syntax
'Declaration
 
Property BackgroundColorIndex As ExcelKnownColors
'Usage
 
Dim instance As IChartInterior
Dim value As ExcelKnownColors
 
instance.BackgroundColorIndex = value
 
value = instance.BackgroundColorIndex
ExcelKnownColors BackgroundColorIndex {get; set;}
Remarks
Background color index can be visible only if the Interior Pattern is enable. To know more about charts refer this link.
Example
The following code illustrates the use of BackgroundColorIndex property.
using Syncfusion.XlsIO;
            
class Example
{
   static void Main()
   {
      using (ExcelEngine excelEngine = new ExcelEngine())
      {
        //Create a worksheet.        
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet sheet = workbook.Worksheets[0];
        sheet.Range["A1"].Text = "Student ID";
        sheet.Range["B1"].Text = "Student Name";
        sheet.Range["C1"].Text = "Mark(Out of 100)";
        sheet.Range["A1:C1"].AutofitColumns();
        sheet.Range["A2"].Number = 1;
        sheet.Range["A3"].Number = 2;
        sheet.Range["A4"].Number = 3;
        sheet.Range["A5"].Number = 4;
        sheet.Range["A6"].Number = 5;
        sheet.Range["B2"].Text = "Andrew";
        sheet.Range["B3"].Text = "Marson";
        sheet.Range["B4"].Text = "Jack";
        sheet.Range["B5"].Text = "Sam";
        sheet.Range["B6"].Text = "Breto";
        sheet.Range["C2"].Number = 77;
        sheet.Range["C3"].Number = 45;
        sheet.Range["C4"].Number = 92;
        sheet.Range["C5"].Number = 39;
        sheet.Range["C6"].Number = 55;
        
        //Create a Chart
        IChartShape chart = sheet.Charts.Add();
        chart.LeftColumn = 5;
        chart.RightColumn = 11;
        chart.Name = "Student Sample Chart";
        chart.ChartType = ExcelChartType.Cone_Clustered_3D;
        chart.DataRange = sheet.Range["B2:C6"];
        
        //sets the backgroundColor color of the chart
        chart.ChartArea.Interior.BackgroundColorIndex = ExcelKnownColors.Bright_green;
        chart.ChartArea.Interior.Pattern = ExcelPattern.Angle;
        
        workbook.SaveAs("Charts.xlsx");
        workbook.Close();
      }
   }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also