It seems not that many people need similar functionality currently, however it looks useful for handling very large documents.
I looked at it and it looks good, some comments: * The finalize() in the Beans looks strange and should not be needed, these members are freed anyway and having to implement finalize() always looks fishy! Thanks... Dominik. On Thu, Jun 4, 2015 at 6:39 AM, Renjith R <[email protected]> wrote: > Able to access this file? Kindly let me know your comments. > > On Thu, May 28, 2015 at 7:04 PM, Renjith R <[email protected]> wrote: > >> Uploaded the code to my google drive. See if you can access. >> >> https://drive.google.com/open?id=0BwDzHx011EuvbWpjNEZzanNrV1U&authuser=0 >> >> com.big.excel.reader.bean.Sheet doesn't implement >> org.apache.poi.ss.usermodel.Sheet. Currently i haven't implemented any >> parser methods. >> >> >> >> On Wed, May 27, 2015 at 6:58 PM, Renjith R <[email protected]> wrote: >> >>> Please see the trailing mails. Thought of sharing it with users too. Let >>> me know your suggestions. >>> ---------- Forwarded message ---------- >>> From: "Renjith R" <[email protected]> >>> Date: 26 May 2015 19:50 >>> Subject: Suggestion on how to read huge excel files. >>> To: <[email protected]> >>> Cc: >>> >>> 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 >>> >> >> >> >> -- >> *RENJITH R* >> 9446011990 >> > > > > -- > *RENJITH R* > 9446011990 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
