I am using SXSSF for generating excel sheets. The method setRowGroupCollapsed has not yet been implemented in SXSSFSheet.class: public void setRowGroupCollapsed(int row, boolean collapse) { //_sh.setRowGroupCollapsed(row, collapse); throw new RuntimeException("Not Implemented"); } As a result, if I try to collapse rows, the excel sheet generated gives the error message: "Excel found unreadable content".
Note that the method implementation is fine in version 3.8-beta5 (http://grepcode.com/file/repo1.maven.org/maven2/org.apache.poi/poi-ooxml/3.8-beta5/org/apache/poi/xssf/streaming/SXSSFSheet.java#SXSSFSheet): public void setRowGroupCollapsed(int row, boolean collapse) { _sh.setRowGroupCollapsed(row, collapse); } But for some reason, this was commented out in version 3.8: public void setRowGroupCollapsed(int row, boolean collapse) { //_sh.setRowGroupCollapsed(row, collapse); throw new RuntimeException("Not Implemented"); } Here is the commit message: http://svn.apache.org/viewvc/poi/trunk/src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFSheet.java?view=diff&r1=1295057&r2=1295058&pathrev=1295058
FYI, in the meantime it was at least brought back for collapsing, but is still not there for uncollapsing: public void setRowGroupCollapsed(int row, boolean collapse) { if (collapse) { collapseRow(row); } else { //expandRow(rowIndex); throw new RuntimeException("Not Implemented"); } }
(In reply to Ishmeet from comment #1) > Here is the commit message: r1295058