public static void Run()
{
//Source directory
string sourceDir = RunExamples.Get_SourceDirectory();
//Output directory
string outputDir = RunExamples.Get_OutputDirectory();
//Load your source workbook
Workbook wb = new Workbook(sourceDir + "sampleAdvancedFilter.xlsx");
//Access first worksheet
Worksheet ws = wb.Worksheets[0];
//Apply advanced filter on range A5:D19 and criteria range is A1:D2
//Besides, we want to filter in place
//And, we want all filtered records not just unique records
ws.AdvancedFilter(true, "A5:D19", "A1:D2", "", false);
//Save the workbook in xlsx format
wb.Save(outputDir + "outputAdvancedFilter.xlsx", SaveFormat.Xlsx);
Console.WriteLine("ApplyAdvancedFilterOfMicrosoftExcel executed successfully.\r\n");
}
