Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
MIME-Version: 1.0
In-Reply-To: <1464082009858-5723108.post@n5.nabble.com>
References: <1464082009858-5723108.post@n5.nabble.com>
Date: Wed, 25 May 2016 21:48:57 +0200
Message-ID: <CABdJj576v+hagrZiMdoHzVavkBgJDseKLa9zj15JEQUwyCyskw@mail.gmail.com>
Subject: Re: How to access pivot table of very large excel using apache poi in java?
From: Dominik Stadler <dominik.stadler@gmx.at>
To: POI Users List <user@poi.apache.org>
Content-Type: multipart/alternative; boundary=001a1145b686e2b3890533aff612
archived-at: Wed, 25 May 2016 20:15:02 -0000

--001a1145b686e2b3890533aff612
Content-Type: text/plain; charset=UTF-8

Hi,

Not sure where "SaxDemo" is from as I did not find it in the POI sources,
but at least the XLSX2CSV demo (
https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java)
only reads some basic parts of the file. I fear your only chance is
probably to implement the additional handling based on how the pivot table
is stored in the .xlsx file.

Dominik.

On Tue, May 24, 2016 at 11:26 AM, Sowmya <sowmyashree97@gmail.com> wrote:

> Hi,
>
> I am trying to get data source of pivot table using apache poi . But the
> excel file is very large and the code below gives out of memory issue :
> FileInputStream fis = new FileInputStream(new File("demo.xlsx"));
> XSSFWorkbook workbook = new XSSFWorkbook(fis);
>
> I tried using Sax parser as below :
> SaxDemo example = new SaxDemo();
> example.processOneSheet("demo.xlsx");
>
> But by using this I can only read the cell contents . But I like to access
> pivot table. Is it possible to Sax parser , to return the processed sheet?
>
> Any help is great as I am stuck with this memory issue.
>
>
> Thanks,
> Sowmya
>
>
>
> --
> View this message in context:
> http://apache-poi.1045710.n5.nabble.com/How-to-access-pivot-table-of-very-large-excel-using-apache-poi-in-java-tp5723108.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

--001a1145b686e2b3890533aff612--