Hi, thanks for sharing, is the code available somewhere? It might be interesting for others to take a look.
Dominik. On Tue, May 26, 2015 at 4:20 PM, Renjith R <[email protected]> wrote: > Hi Developers, > > I am Renjith. Recently I was working on an assignment where i > was assigned a task to read very big excel files[These excel files does not > contain images, all it has is pure text data]. I started with XSSFWorkbook > approach and came to know that it consumes more memory than i have. In > search of an alternative i ended up in the following link. > https://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api > > Being new to XML parser, i struggled to read excel using SAX. Even though > there are some examples, i don't find enough documents to understand the > structure of excel file & relation between various XMLs in excel file. After > so many trial and error, i read the excel file successfully. > http://www.coderanch.com/t/627617/open-source/POI-OutOfMemoryError-reading-big-excel > > In order to reduce the effort of developers who face similar situation, i > created an API. It hides the complexity of understanding XML Parsing and > excel structure from developer. It is capable of reading only string data > from excel file, since it is meant to read huge excel data. Apart from that, > i used StAX instead of SAX to allow developer to control the streaming of > data. > > I have attached a document that explains the things in detail. Requesting > you to go though it and let me know your thoughts. > > > -- > RENJITH R > 9446011990 > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
