Hi,
We use the control UltraGridExcelExporter to export the UltraGrid to excel 2007. The data source of the grid is very big, from 10, 000 to 100, 000 records. We found that it could export about 13,000 records. But when I export it second time, it throw out the out of memory exception.
Our code is like this:
Infragistics.Excel.Workbook workbook = new Infragistics.Excel.Workbook(WorkbookFormat.Excel2007);
Infragistics.Excel.Worksheet worksheet = workbook.Worksheets.Add(getSheetText(_reportCommandName));
...
this.grdExcelExporter.Export(ultGrdReports, worksheet);
workbook.Save(fileName);
The out of memory is threw out at the workbook save statement.
I checked in task manager, the export consume much memory.Could you help me and give me some advice on how to resolve this issue?
thanks,
Chance
What version of the controls are you using?
There are always going to be some physical memory limitations on the size of the file you can export, but we have made some improvements in this area over the years. So you may get better results with a newer version of NetAdvantage, assuming you are using an older version.
If I export a data source with more than 300, 000 rows, more than 80 columns, how much memory and time will be used by infragistics latest excel export library?
Eric