Hello
1) I'm getting "Out-of-memory" error (no matter what the number of items in the grid is) when I try to export using the following code. If I don't specify Excel2007 option, it works fine. Do we need Excel installed on the machine to export in excel2007 format?:
SaveFileDialog1.Filter =
"Excel Worksheet|*.xlsx"
If SaveFileDialog1.ShowDialog = DialogResult.OK Then
UltraGridExcelExporter1.Export(UltraGrid1, SaveFileDialog1.FileName, Infragistics.Excel.WorkbookFormat.Excel2007)
End If
2) Do we have a chance to export only filtered items in the grid?
Murat Eraydin said:1) I'm getting "Out-of-memory" error (no matter what the number of items in the grid is) when I try to export using the following code.
What version of the components are you using? Maybe you just need to get the latest service release.
How to get the latest service release - Infragistics Community
If that does not help, then we would need more information, like a small sample project demonstrating the exception. The call stack of the exception might help, also.
Murat Eraydin said:Do we need Excel installed on the machine to export in excel2007 format
No, you do not.
Murat Eraydin said:2) Do we have a chance to export only filtered items in the grid?
Exporting to Excel should be WYSIWYG. Hidden, filtered-out items in the grid should not be exported.
Ok. The problem was NOT using Infragistics3.Excel assembly. My application was targetting .NET 2.0, I've changed that to 3.5 and updated references. After that, all issues resolved.
Thanks for the help.