Syncfusion.XlsIO.Base
Example 


RemoveIconFilter Method

Removes the Icon Filter applied.
Syntax
'Declaration
 
Sub RemoveIconFilter() 
'Usage
 
Dim instance As IAutoFilter
 
instance.RemoveIconFilter()
void RemoveIconFilter()
Example
The following code illustrates how to remove the ExcelFilterType.IconFilter.
using Syncfusion.XlsIO;
            
class Program
{
    static void Main()
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create worksheet
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet worksheet = workbook.Worksheets[0];
            
            //Load data
            worksheet["A1"].Text = "Products";
            worksheet["A2"].Text = "Alfreds Futterkiste";
            worksheet["A3"].Text = "Antonio Moreno Taqueria";
            worksheet["A4"].Text = "Around the Horn";
            worksheet["A5"].Text = "Bon app";
            worksheet["A6"].Text = "Eastern Connection";
            worksheet["A7"].Text = "Ernst Handel";
            worksheet["B1"].Text = "Qtr1";
            worksheet["B2"].Number = 144.6;
            worksheet["B3"].Number = 579.6;
            worksheet["B4"].Number = 267.5;
            worksheet["B5"].Number = 418;
            worksheet["B6"].Number = 728;
            worksheet["B7"].Number = 943.89;
            worksheet["C1"].Text = "Qtr2";
            worksheet["C2"].Number = 162.56;
            worksheet["C3"].Number = 1249.2;
            worksheet["C4"].Number = 1062.5;
            worksheet["C5"].Number = 756;
            worksheet["C6"].Number = 4547.92;
            worksheet["C7"].Number = 349.6;
            
            //Create style for table number format
            IStyle style1 = workbook.Styles.Add("CurrencyFormat");
            style1.NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* \" - \"??_);_(@_)";
            
            //Apply number format
            worksheet["B2:C8"].CellStyleName = "CurrencyFormat";
            
            //Create filters collection
            IAutoFilters filters = worksheet.AutoFilters;
            
            //Set range
            filters.FilterRange = worksheet["A1:C7"];
            
            //Set filter column
            IAutoFilter filter = filters[1];
            
            //Create conditional formats
            IConditionalFormats formats = worksheet["B2:B7"].ConditionalFormats;
            IConditionalFormat format = formats.AddCondition();
            
            //Set Type as IconSet
            format.FormatType = ExcelCFType.IconSet;
            
            //Add filter
            filter.AddIconFilter(ExcelIconSetType.ThreeArrows, 0);
            
            //Remove filter
            filter.RemoveIconFilter();
            
            //Apply AutoFit
            worksheet.UsedRange.AutofitColumns();
            
            //Save and Dispose
            workbook.SaveAs("Filters.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also