Syncfusion.XlsIO.Base
Example 


FirstCondition Property

First condition of autofilter.
Syntax
'Declaration
 
ReadOnly Property FirstCondition As IAutoFilterCondition
'Usage
 
Dim instance As IAutoFilter
Dim value As IAutoFilterCondition
 
value = instance.FirstCondition
IAutoFilterCondition FirstCondition {get;}
Remarks
To know more about filters refer Data Filtering
Example
Custom filters can be applied by setting FirstCondition and SecondCondition. To filter particular pattern we can make use of custom filters. Here for example, we set a custom filter to filter values those does not start with "A" but should end with "N". For this we set ExcelFilterCondition.DoesNotBeginWith to FirstCondition's IAutoFilterCondition.ConditionOperator and ExcelFilterCondition.EndsWith to SecondCondition's IAutoFilterCondition.ConditionOperator and set ExcelFilterDataType.String to IAutoFilterCondition.String for both coditions. Also we set "A" and "N" to IAutoFilterCondition.String for FirstCondition and SecondCondition respectively.
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 = 744.6;
            worksheet["B3"].Number = 5079.6;
            worksheet["B4"].Number = 1267.5;
            worksheet["B5"].Number = 1418;
            worksheet["B6"].Number = 4728;
            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:C7"].CellStyleName = "CurrencyFormat";
            
            //Create filters collection
            IAutoFilters filters = worksheet.AutoFilters;
            
            //Set range
            filters.FilterRange = worksheet["A1:C7"];
            
            //Set filter column
            IAutoFilter filter = filters[0];
            
            //Add filter
            filter.FirstCondition.ConditionOperator = ExcelFilterCondition.DoesNotBeginWith;
            filter.FirstCondition.DataType = ExcelFilterDataType.String;
            filter.FirstCondition.String = "A";
            
            filter.SecondCondition.ConditionOperator = ExcelFilterCondition.EndsWith;
            filter.SecondCondition.DataType = ExcelFilterDataType.String;
            filter.SecondCondition.String = "n";
            
            //Apply AutoFit
            worksheet.UsedRange.AutofitColumns();
            
            //Save and Dispose
            workbook.SaveAs("Filters.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also