| EasyXLS http://forum.easyxls.com/ |
|
| Lots of formulas on large spreadsheets http://forum.easyxls.com/viewtopic.php?f=5&t=722 |
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: http://forum.easyxls.com/viewtopic.php?t=130 |
|
| Page 1 of 1 | All times are UTC - 4 hours |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|