Unable to read excel file having huge data using XSSF

[ydinku <pr...@citi.com>]

Hi,

My project requirement is to consolidate many excel workbooks having huge
data into a single excel workbook. Each excel workbook should be a new sheet
in the consolidated excel. However I am facing OutOfMemory error even when I
try to load a 25MB file. I tried increasing the heap space but to no avail.
My piece of code goes like this

XSSFWorkbook wb = new XSSFWorkbook(InputStream..);

I have also tried below code

OPCPackage pkg = OPCPackage.open("D:\\excelll\\11.xlsx");
XSSFReader r = new XSSFReader( pkg );
InputStream sheet2 = r.getWorkbookData();
XSSFWorkbook wb1 = new XSSFWorkbook(sheet2);

This piece of code throws
org.apache.poi.openxml4j.exceptions.InvalidFormatException: Package should
contain a content type part [M1.13]

Can anyone help on this

--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Unable-to-read-excel-file-having-huge-data-using-XSSF-tp5524710p5524710.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