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"); }