You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by Renjith R <ra...@gmail.com> on 2015/06/04 06:37:14 UTC
Re: Suggestion on how to read huge excel files.
Able to access this file? Kindly let me know your comments.
On Thu, May 28, 2015 at 7:00 PM, Renjith R <ra...@gmail.com> wrote:
> Uploaded the code in my google drive. See if you can access.
>
> https://drive.google.com/open?id=0BwDzHx011EuvbWpjNEZzanNrV1U&authuser=0
>
>
>
>
> ---------- Forwarded message ----------
> From: "Renjith R" <ra...@gmail.com>
> Date: 26 May 2015 19:50
> Subject: Suggestion on how to read huge excel files.
> To: <de...@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
Re: Suggestion on how to read huge excel files.
Posted by Renjith R <ra...@gmail.com>.
Able to access this file? Kindly let me know your comments.
On Thu, Jun 4, 2015 at 10:07 AM, Renjith R <ra...@gmail.com> wrote:
> Able to access this file? Kindly let me know your comments.
>
> On Thu, May 28, 2015 at 7:00 PM, Renjith R <ra...@gmail.com> wrote:
>
>> Uploaded the code in my google drive. See if you can access.
>>
>> https://drive.google.com/open?id=0BwDzHx011EuvbWpjNEZzanNrV1U&authuser=0
>>
>>
>>
>>
>> ---------- Forwarded message ----------
>> From: "Renjith R" <ra...@gmail.com>
>> Date: 26 May 2015 19:50
>> Subject: Suggestion on how to read huge excel files.
>> To: <de...@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