Excel 2007 Performance Issues
Posted: Tue Jan 20, 2009 5:40 am
I have been using the product for a few years now, and so far the support for Excel 97/2003 has been excellent, no complaints.
Support for 2007 is Ok, but I found problems with large spreadsheets; this is a problem that in 97/2003 doesn't exist tough.
It looks like the format in Excel 2007 poses some challenges to the structure of the component in the sense that everything is loaded into memory, using an awful amount of RAM memory therefore defeating one of the main features in Excel 2007 which is the breakage of the 65K rows limit.
From a practical point of view I found that the component doesn't behave acceptably when the 10000 rows threshold is reached in term of amount of memory needed...
Is there any plans to change the approach of processing 2007 files to improve performance?
Support for 2007 is Ok, but I found problems with large spreadsheets; this is a problem that in 97/2003 doesn't exist tough.
It looks like the format in Excel 2007 poses some challenges to the structure of the component in the sense that everything is loaded into memory, using an awful amount of RAM memory therefore defeating one of the main features in Excel 2007 which is the breakage of the 65K rows limit.
From a practical point of view I found that the component doesn't behave acceptably when the 10000 rows threshold is reached in term of amount of memory needed...
Is there any plans to change the approach of processing 2007 files to improve performance?