Syncfusion.XlsIO.Base
Example 


IsAnd Property

True means to use AND operation between conditions, False to use OR. Read-only.
Syntax
'Declaration
 
Property IsAnd As Boolean
'Usage
 
Dim instance As IAutoFilter
Dim value As Boolean
 
instance.IsAnd = value
 
value = instance.IsAnd
bool IsAnd {get; set;}
Example
If both the conditions given for ExcelFilterType.CustomFilter should be applied without considering the other condition IsAnd should be set to "false". By default IsAnd is set to "true", so it combines both the conditions and applies the filter.
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];
            
            //Set Is AND or OR
            filter.IsAnd = false;
            
            //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.2460.0.34

See Also