|Lots of formulas on large spreadsheets
|Page 1 of 1|
|Author:||useful-idiot [ Mon Aug 25, 2008 6:56 am ]|
|Post subject:||Lots of formulas on large spreadsheets|
I just started testing the demo version of EasyXLS. My goal is to read formula results from a very large (about 10 MB) XLS spreadsheet, then modify the formula input values and re-calculate and read the result again.
However, I managed to stop the OutOfMemoryExceptions, but still, working with currentSheet.easy_computeFormulas(xls, false) takes a disturbingly long time to process (5-10 min or more). Is there any possibilty to calculate results only of single cells? I need one cell only in my test, but its formula needs to walk over 8000 lines of data in another sheet...
|Author:||daniela [ Wed Sep 10, 2008 2:31 am ]|
See this post:
|Page 1 of 1||All times are UTC - 4 hours|
|Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group