We are using Infragistics3.Excel (December Hotfix for Infragistics 8.3) to export large tables with calculation results to Excel.As I tried saving the results of our test calculation to new xlsx Format I have noticed that the produced files are almost 4 times larger than old xls ones and memory consumption during the export about 2,5 times higher.
Here are some measured values while exporting 3 small tables (10 – 15 records) and one large table 36000 records with over 40 columns. Memory Usage is a difference of virtual memory peak private bytes compared to saving the same table to simple CSV file with StreamWriter ( CSV file size 18 MB):
· XLS
file size: 28MB Additional memory required 480MB
file size: 114MBAdditional memory required 1180 MB
The application code for both exports (xls and xlsx) is except for WorkbookFormat identical
By the way, after XLSX file is opened and resaved in Excel 2007 the file size shrinks to 7MB and total virtual memory consumed by Excel is 270 MB.
This is the first I have heard of any memory issues. I would recommend submitting a sample which demonstrates the issue to the support group so it can be investigated: http://es.infragistics.com/gethelp.
Thanks for your help.