Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IChartInterior Interface : ForegroundColorIndex Property

ForegroundColorIndex Property (IChartInterior)

Gets or sets the index of foreground color in ExcelKnownColors.
Syntax
'Declaration
 
Property ForegroundColorIndex As ExcelKnownColors
'Usage
 
Dim instance As IChartInterior
Dim value As ExcelKnownColors
 
instance.ForegroundColorIndex = value
 
value = instance.ForegroundColorIndex
ExcelKnownColors ForegroundColorIndex {get; set;}
Remarks
To know more about charts refer this link.
Example
The following code illustrates the use of ForegroundColorIndex 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 index of foreground color
        chart.ChartArea.Interior.ForegroundColorIndex = ExcelKnownColors.Aqua;
        
        workbook.SaveAs("Charts.xlsx");
        workbook.Close();
      }
   }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also