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
Hello Eric,
I cannot get the mentioned behavior. It might be an already fixed version, 9.1 is almost four years old now.
As to the 300k rows and 80 columns, you would need a pretty fast and reliable machine in order to get the desired performance. Please note that this s a lot of data and the exporting process will definitely be slow compared to 20 rows and 10k records, however the excel engine manages to done it in the end.
I am checking about the progress of this issue. Please let me know If you need any further assistance on this.
The grid does export to an excel file. The time consumed by the operation with the data given is acceptable.
You could always check this by downloading the trial version of NetAdvantage 12.2 for Windows Forms.
Hello,
I checked the sample that you provided, you sample data has only one column. I tried to export the data with 72 columns and 50000 rows data with Infragistics2.Documents.Excel.v12.1, there is no out of memory exception, but however, the it takes a very very long time to finish.
Could you please confirm that the export to excel improved a lot in the latest version? IF yes, please give a example.
If it really works, I think we'll upgrade to the latest version.