[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Re: Suggestion on how to read huge excel files.
From:       Dominik Stadler <dominik.stadler () gmx ! at>
Date:       2015-07-19 7:50:06
Message-ID: CABdJj55Ak2ddVojwEhYFmQR-opWWsbDFCRT1Mo5T3vdDn+8tMw () mail ! gmail ! com
[Download RAW message or body]

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 <ranju4u6@gmail.com> 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 <ranju4u6@gmail.com> wrote:
> 
> > Able to access this file? Kindly let me know your comments.
> > 
> > On Thu, May 28, 2015 at 7:04 PM, Renjith R <ranju4u6@gmail.com> 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 <ranju4u6@gmail.com> wrote:
> > > 
> > > > Please see the trailing mails. Thought of sharing it with users too. Let
> > > > me know your suggestions.
> > > > ---------- Forwarded message ----------
> > > > From: "Renjith R" <ranju4u6@gmail.com>
> > > > Date: 26 May 2015 19:50
> > > > Subject: Suggestion on how to read huge excel files.
> > > > To: <dev@poi.apache.org>
> > > > 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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]