Syncfusion.XlsIO.Base
Example 


Remove Method (IConditionalFormats)

Removes all the conditional formats in the collection.
Syntax
'Declaration
 
Sub Remove() 
'Usage
 
Dim instance As IConditionalFormats
 
instance.Remove()
void Remove()
Remarks
To remove a particular condition we can use RemoveAt by specifying the index of the conditional format in the collection.
Example
The following code illustrates how to set the remove all the conditions applied 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 conditions.
            formats.Remove();
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also