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-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
