Re: Suggestion on how to read huge excel files.

[Dominik Stadler <do...@gmx.at>]

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 <ra...@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 <ra...@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 <ra...@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 <ra...@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" <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
>>
>
>
>
> --
> *RENJITH R*
> 9446011990

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org