https://bz.apache.org/bugzilla/show_bug.cgi?id=59843
Bug ID: 59843 Summary: Can't find a way to get empty rows with XSSF and SAX (Event API) Product: POI Version: 3.14-FINAL Hardware: PC Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: jz...@talend.com When I create a new excel abc.xlsx Create a new sheet "test" Add a cell value in "C20" Then I try to use XSSF and SAX (Event API) to read this xml. I can only get the 1 row value. <sheetData> <row r="20" spans="3:3" x14ac:dyDescent="0.25"> <c r="C20" t="s"> <v>0</v> </c> </row> </sheetData> Can't find a way to get the empty rows 1~19. I use this example to test my data. https://github.com/apache/poi/blob/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java#L73~L74 Just change it write xml to a local file -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org