hello!
there is something that is bugging me, the JPOI library is quite powerfull but it takes a lot of Memory to run.
XLSX file: 700MB memory for a 2 MB file with 70 000 ROWS * 6 COLUMNS.
XLS file: 300MB memory for a 8 MB with same row and columns.
i am pretty sure that my code is not the problem as the error (JAVA HEAP ERROR) occurs in this line:
Detail.InitializeExisting(reportspath,"Detail.xlsx","")
it simple does not finish.
i had to add this line to my project #VirtualMachineArgs: -Xms1024m -Xmx1024m and right now i do not find any problem adding it because it is very very fast, it will iterate all the cells in 7 seconds or less despite that Erel used it for 3.7GB text file.
but in some point in time i want to use this library with some workbooks spanning 120MB file size, it will just simply break.
is this behavour intended? and if that is so, any suggestion?
THANKS!