//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); Object data = new Object[][]{ {"Name", "City", "Birthday", "Eye color", "Weight", "Height"}, {"Richard", "New York", new GregorianCalendar(1968, 5, 8), "Blue", 67, 165}, {"Nia", "New York", new GregorianCalendar(1972, 6, 3), "Brown", 62, 134}, {"Jared", "New York", new GregorianCalendar(1964, 2, 2), "Hazel", 72, 180}, {"Natalie", "Washington", new GregorianCalendar(1972, 7, 8), "Blue", 66, 163}, {"Damon", "Washington", new GregorianCalendar(1986, 1, 2), "Hazel", 76, 176}, {"Angela", "Washington", new GregorianCalendar(1993, 1, 15), "Brown", 68, 145} }; worksheet.getRange("A1:F7").setValue(data); worksheet.getRange("A:F").setColumnWidth(15); String criteria1 = new GregorianCalendar(1972, 6, 3).getTime().toString(); String criteria2 = new GregorianCalendar(1993, 1, 15).getTime().toString(); //filter date between 1972.7.3 and 1993.2.15 worksheet.getRange("A1:F7").autoFilter(2, ">=" + criteria1, AutoFilterOperator.And, "<=" + criteria2); //save to an excel file workbook.save("DateFilter.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val data = arrayOf(arrayOf("Name", "City", "Birthday", "Eye color", "Weight", "Height"), arrayOf("Richard", "New York", GregorianCalendar(1968, 5, 8), "Blue", 67, 165), arrayOf("Nia", "New York", GregorianCalendar(1972, 6, 3), "Brown", 62, 134), arrayOf("Jared", "New York", GregorianCalendar(1964, 2, 2), "Hazel", 72, 180), arrayOf("Natalie", "Washington", GregorianCalendar(1972, 7, 8), "Blue", 66, 163), arrayOf("Damon", "Washington", GregorianCalendar(1986, 1, 2), "Hazel", 76, 176), arrayOf("Angela", "Washington", GregorianCalendar(1993, 1, 15), "Brown", 68, 145)) worksheet.getRange("A1:F7").value = data worksheet.getRange("A:F").columnWidth = 15.0 val criteria1 = GregorianCalendar(1972, 6, 3).time.toString() val criteria2 = GregorianCalendar(1993, 1, 15).time.toString() //filter date between 1972.7.3 and 1993.2.15 worksheet.getRange("A1:F7").autoFilter(2, ">=$criteria1", AutoFilterOperator.And, "<=$criteria2") //save to an excel file workbook.save("DateFilter.xlsx")