//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("D3").setValue("Numbers"); worksheet.getRange("D4").setValue(1); worksheet.getRange("D5").setValue(2); worksheet.getRange("D6").setValue(3); //first time invoke. worksheet's filter range will be D3:D6. worksheet.getRange("D3:D6").autoFilter(0, "<>2"); //set AutoFilterMode to false. must set this property before, otherwise, subsequent code can not take effort. worksheet.setAutoFilterMode(false); worksheet.getRange("A5").setValue("Numbers"); worksheet.getRange("A6").setValue(1); worksheet.getRange("A7").setValue(2); worksheet.getRange("A8").setValue(3); //second time invoke. worksheet's filter range will change to A5:A8. worksheet.getRange("A5:A8").autoFilter(0, "<>2"); //save to an excel file workbook.save("ChangeWorksheetFilterRange.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("D3").value = "Numbers" worksheet.getRange("D4").value = 1 worksheet.getRange("D5").value = 2 worksheet.getRange("D6").value = 3 //first time invoke. worksheet's filter range will be D3:D6. worksheet.getRange("D3:D6").autoFilter(0, "<>2") //set AutoFilterMode to false. must set this property before, otherwise, subsequent code can not take effort. worksheet.autoFilterMode = false worksheet.getRange("A5").value = "Numbers" worksheet.getRange("A6").value = 1 worksheet.getRange("A7").value = 2 worksheet.getRange("A8").value = 3 //second time invoke. worksheet's filter range will change to A5:A8. worksheet.getRange("A5:A8").autoFilter(0, "<>2") //save to an excel file workbook.save("ChangeWorksheetFilterRange.xlsx")