Syncfusion.XlsIO.Base
Example 


Number of conditions.

SetConditionCount Method

Sets the number of IColorConditionValue objects in the collection. Supported values are 2 and 3.
Syntax
'Declaration
 
Sub SetConditionCount( _
   ByVal count As Integer _
) 
'Usage
 
Dim instance As IColorScale
Dim count As Integer
 
instance.SetConditionCount(count)
void SetConditionCount( 
   int count
)

Parameters

count
Number of conditions.
Remarks
To know more about advanced conditional formatting Types refer this link.
Example
The following code illustrates how to set the condition value count for color scale.
using Syncfusion.XlsIO;
using System.Drawing;
            
class Example
{
    static void Main()
    {
        //Create a worksheet.        
        ExcelEngine excelEngine = new ExcelEngine();
        IApplication application = excelEngine.Excel;
        application.DefaultVersion = ExcelVersion.Excel2013;
        IWorkbook workbook = application.Workbooks.Create(1);
        IWorksheet worksheet = workbook.Worksheets[0];
            
        //Load data to Apply Conditional Formatting.
        worksheet["A1"].Text = "ColorScale";
        worksheet["A2"].Number  =  10;
        worksheet["A3"].Number  =  20;
        worksheet["A4"].Number  =  30;
        worksheet["A5"].Number  =  40;
        worksheet["A6"].Number  =  50;
        worksheet["A7"].Number  =  60;
        worksheet["A8"].Number  =  70;
        worksheet["A9"].Number  =  80;
        worksheet["A10"].Number =  90;
        worksheet["A11"].Number =  100;
        
        //Create instance of IConditonalFormat and IConditionalFormats.
        IConditionalFormats formats = worksheet["A2:A11"].ConditionalFormats;
        IConditionalFormat format = formats.AddCondition();
            
        //Set FormatType as ColorScale.
        format.FormatType = ExcelCFType.ColorScale;
        IColorScale colorScale = format.ColorScale;
            
        //Set 3 as count for color scale
        colorScale.SetConditionCount(3);
        
        //Save and Dispose.
        workbook.SaveAs("ConditionalFormats.xlsx");
        workbook.Close();
        excelEngine.Dispose();
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.2460.0.34

See Also