// 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, 6, 8), "Blue", 67, 165}, {"Nia", "New York", new GregorianCalendar(1972, 7, 3), "Brown", 62, 134}, {"Jared", "New York", new GregorianCalendar(1964, 3, 2), "Hazel", 72, 180}, {"Natalie", "Washington", new GregorianCalendar(1972, 8, 8), "Blue", 66, 163}, {"Damon", "Washington", new GregorianCalendar(1986, 2, 2), "Hazel", 76, 176}, {"Angela", "Washington", new GregorianCalendar(1993, 2, 15), "Brown", 68, 145} }; worksheet.getRange("A1:F7").setValue(data); worksheet.getRange("A:F").setColumnWidth(15); //Weight less than 80. worksheet.getRange("A1:F7").autoFilter(4, "<72"); //Copy range and ignore hidden range. IWorksheet worksheet2 = workbook.getWorksheets().add(); PasteOption pasteOption = new PasteOption(); pasteOption.setAllowPasteHiddenRange(false); worksheet.getRange("A1:F7").copy(worksheet2.getRange("A1:F7"), pasteOption); //Copy range and contain hidden range. IWorksheet worksheet3 = workbook.getWorksheets().add(); worksheet.getRange("A1:F7").copy(worksheet3.getRange("A1:F7")); // Save to an excel file workbook.save("CopyAndIgnoreHiddenRange.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets[0] val data = arrayOf(arrayOf("Name", "City", "Birthday", "Eye color", "Weight", "Height"), arrayOf("Richard", "New York", GregorianCalendar(1968, 6, 8), "Blue", 67, 165), arrayOf("Nia", "New York", GregorianCalendar(1972, 7, 3), "Brown", 62, 134), arrayOf("Jared", "New York", GregorianCalendar(1964, 3, 2), "Hazel", 72, 180), arrayOf("Natalie", "Washington", GregorianCalendar(1972, 8, 8), "Blue", 66, 163), arrayOf("Damon", "Washington", GregorianCalendar(1986, 2, 2), "Hazel", 76, 176), arrayOf("Angela", "Washington", GregorianCalendar(1993, 2, 15), "Brown", 68, 145)) worksheet.getRange("A1:F7").value = data worksheet.getRange("A:F").columnWidth = 15.0 //Weight less than 80. worksheet.getRange("A1:F7").autoFilter(4, "<72") //Copy range and ignore hidden range. val worksheet2 = workbook.worksheets.add() val pasteOption = PasteOption() pasteOption.setAllowPasteHiddenRange(false) worksheet.getRange("A1:F7").copy(worksheet2.getRange("A1:F7"), pasteOption) //Copy range and contain hidden range. val worksheet3 = workbook.worksheets.add() worksheet.getRange("A1:F7").copy(worksheet3.getRange("A1:F7")) // Save to an excel file workbook.save("CopyAndIgnoreHiddenRange.xlsx")