Syncfusion.XlsIO.Base
Example 


Index of the conditional format to be removed.

RemoveAt Method (IConditionalFormats)

Removes the conditional format at the specified index from the collection.
Syntax
'Declaration
 
Sub RemoveAt( _
   ByVal index As Integer _
) 
'Usage
 
Dim instance As IConditionalFormats
Dim index As Integer
 
instance.RemoveAt(index)
void RemoveAt( 
   int index
)

Parameters

index
Index of the conditional format to be removed.
Example
The following code illustrates how to remove a particular condition from the conditional formats collection.
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 worksheet = workbook.Worksheets[0];
            
            //Load data to Apply Conditional Formatting.
            worksheet["B1"].Text = "Conditional Formats";
            worksheet["B2"].Number = 10;
            worksheet["B3"].Number = 20;
            worksheet["B4"].Number = 30;
            worksheet["B5"].Number = 40;
            worksheet["B6"].Number = 50;
            worksheet["B7"].Number = 60;
            worksheet["B8"].Number = 70;
            worksheet["B9"].Number = 80;
            worksheet["B10"].Number = 90;
            worksheet["B11"].Number = 100;
            
            //Create instance of IConditonalFormat and IConditionalFormats.
            IConditionalFormats formats = worksheet["B2:B11"].ConditionalFormats;
            
            //Add conditions.
            IConditionalFormat format = formats.AddCondition();
            IConditionalFormat format2 = formats.AddCondition();
            IConditionalFormat format3 = formats.AddCondition();
            
            //Set Condition.
            format.FirstFormula = "60";
            format.SecondFormula = "20";
            format.Operator = ExcelComparisonOperator.Between;
            
            //Set color.
            format.BackColor = ExcelKnownColors.Red;
            
            //Set Condition.
            format2.FirstFormula = "30";
            format2.SecondFormula = "70";
            format2.Operator = ExcelComparisonOperator.Between;
            
            //Set color.
            format2.BackColor = ExcelKnownColors.Blue;
            
            //Set Condition.
            format3.FirstFormula = "30";
            format3.SecondFormula = "50";
            format3.Operator = ExcelComparisonOperator.Between;
            
            //Set color.
            format3.BackColor = ExcelKnownColors.Green;
            
            //Remove condition.
            formats.RemoveAt(2);
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also