Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IChartInterior Interface : UseAutomaticFormat Property

UseAutomaticFormat Property (IChartInterior)

True to use automatic format. False to use custom format.
Syntax
'Declaration
 
Property UseAutomaticFormat As Boolean
'Usage
 
Dim instance As IChartInterior
Dim value As Boolean
 
instance.UseAutomaticFormat = value
 
value = instance.UseAutomaticFormat
bool UseAutomaticFormat {get; set;}
Remarks
To know more about charts refer this link.
Example
The following code illustrates the use of UseAutomaticFormat 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"];
        
        //True to use automatic format for interior
        chart.ChartArea.Interior.UseAutomaticFormat = true;
        
        workbook.SaveAs("Charts.xlsx");
        workbook.Close();
      }
   }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also