To quote Nick: You just need to keep track of the cell reference of the last cell seen, and spot gaps from that. It's fairly easy to do, a good example is in the XLSX to CSV example that uses the SAX parsing stuff to do it: https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java
Nick -----Original Message----- From: hamza touati [mailto:[email protected]] Sent: Wednesday, March 02, 2016 10:52 AM To: [email protected] Subject: Help About using Sax with Apache POI Hello, im using Apache POI with Sax to reduce the use of the memory, im reading an excel file then i export it after some modifications, the problem is when reading a file with empty cells, everything is getting ruined. can you help me please. -- TEOUATI Hamza Ingénieur d'état en Informatique De l'Institut National de Statistique et d'Economie Appliquée Tél: 06 99 10 92 00 ᐧ
