// 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); worksheet.getRange("A:F").group(); worksheet.getRange("A:B").group(); worksheet.getRange("D:E").group(); List groupInfo = worksheet.getOutline().getColumnGroupInfo(); HashMap colInfo = new HashMap<>(); for (IGroupInfo item : groupInfo) { if (item.getChildren() != null) { for (IGroupInfo childItem : item.getChildren()) { if (childItem.getStartIndex() > 2) { childItem.collapse(); } if (childItem.getLevel() == 2) { colInfo.put(childItem.getStartIndex(), childItem.getEndIndex()); } } } } StringBuilder builder = new StringBuilder(); for (Map.Entry item : colInfo.entrySet()) { builder.append("column " + (item.getKey() + 1) + " to column " + (item.getValue() + 1) + ", "); } worksheet.getRange("A12").setValue("The columns where the group level is 2 are: " + builder.toString()); worksheet.getRange("A12").setRowHeight(25); worksheet.getRange("A12").getFont().setColor(Color.GetRed()); worksheet.getRange("A12").getFont().setSize(15); // Save to an excel file workbook.save("GetColumnInfo.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet: IWorksheet = workbook.getWorksheets().get(0) val data: Any = 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").setValue(data) worksheet.getRange("A:F").setColumnWidth(15.0) worksheet.getRange("A:F").group() worksheet.getRange("A:B").group() worksheet.getRange("D:E").group() val groupInfo: List = worksheet.getOutline().getColumnGroupInfo() val colInfo = HashMap() for (item in groupInfo) { if (item.getChildren() != null) { for (childItem in item.getChildren()) { if (childItem.getStartIndex() > 2) { childItem.collapse() } if (childItem.getLevel() == 2) { colInfo[childItem.getStartIndex()] = childItem.getEndIndex() } } } } val builder: java.lang.StringBuilder = java.lang.StringBuilder() for ((key, value) in colInfo.entries) { builder.append("column " + (key + 1) + " to column " + (value + 1) + ", ") } worksheet.getRange("A12").setValue("The columns where the group level is 2 are: " + builder.toString()) worksheet.getRange("A12").setRowHeight(25.0) worksheet.getRange("A12").getFont().setColor(com.grapecity.documents.excel.Color.GetRed()) worksheet.getRange("A12").getFont().setSize(15.0) // Save to an excel file workbook.save("GetColumnInfo.xlsx")