Hi, I don't think we can replace the existing functionality immediately as other people will be relying on it.
If you can polish the code up a bit more and add some JavaDoc and unit tests to describe how it can be used I can put it in some of the "contributed/incoming/incubating" areas of POI. Dominik. On Wed, Jun 24, 2015 at 8:19 AM, Renjith R <[email protected]> wrote: > Thanks for verifying the code, Dominik. > > I know it is not complete and it is not required unless we have very huge > data to be read. But if i work on it, do you think it can replace the Event > API (https://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api) ? . I > believe it can centainly save some time. > > If yes, i can start contributing. > > Thaks in advance. Renjith > > > On Thu, Jun 4, 2015 at 10:09 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 >> > > > > -- > *RENJITH R* > 9446011990 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
