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 ]
Post subject: 

See this post:

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group