help with xlsx creation and row grouping...
Posted: Fri Sep 13, 2013 3:43 am
Hi,
I am new to this forum and the usage of this app. I have attached a sample xlsx file and I am trying to create a xlsx in similar format (row grouping, collapse/expand etc). I used POI XSSFWorkbook, but the memory footprint is high for the real doc creation and I tried to use POI SXSSFWorkbook, but that throws an runtime exception as "not implemented" when we call "sheet.setRowGroupCollapsed(..): method.
sheet.groupRow(1, 9);
sheet.setRowGroupCollapsed(1, true); //this throws a runtime exception in Apache's POI SXSSF impl.
I need a sample code or reference to a sample code for my requirement. Thanks for the help.
I am new to this forum and the usage of this app. I have attached a sample xlsx file and I am trying to create a xlsx in similar format (row grouping, collapse/expand etc). I used POI XSSFWorkbook, but the memory footprint is high for the real doc creation and I tried to use POI SXSSFWorkbook, but that throws an runtime exception as "not implemented" when we call "sheet.setRowGroupCollapsed(..): method.
sheet.groupRow(1, 9);
sheet.setRowGroupCollapsed(1, true); //this throws a runtime exception in Apache's POI SXSSF impl.
I need a sample code or reference to a sample code for my requirement. Thanks for the help.