Hi, I was testing out the export to excel feature using the ExportToExcelML object but I found out that it throws out of memory exception when the grid has over 65000 records. I used the following source code:
void exportExcel_Click(object sender, EventArgs e)
{
SaveFileDialog fileSave = new SaveFileDialog();
fileSave.Filter = "Excel Files(*.XLS)|*.xls";
if (fileSave.ShowDialog() != DialogResult.OK)
return;
string strExportLocation = fileSave.FileName;
ExportToExcelML exporter = new ExportToExcelML();
exporter.HiddenColumnOption = ExportToExcelML.HiddenOption.DoNotExport;
bool exportThemeColors = false;
exporter.RunExport(radGridView1, strExportLocation, ExportToExcelML.ExcelMaxRows._65536, exportThemeColors);
}
did I do something wrong or is it a problem with the ExportToExcelML object?
void exportExcel_Click(object sender, EventArgs e)
{
SaveFileDialog fileSave = new SaveFileDialog();
fileSave.Filter = "Excel Files(*.XLS)|*.xls";
if (fileSave.ShowDialog() != DialogResult.OK)
return;
string strExportLocation = fileSave.FileName;
ExportToExcelML exporter = new ExportToExcelML();
exporter.HiddenColumnOption = ExportToExcelML.HiddenOption.DoNotExport;
bool exportThemeColors = false;
exporter.RunExport(radGridView1, strExportLocation, ExportToExcelML.ExcelMaxRows._65536, exportThemeColors);
}
did I do something wrong or is it a problem with the ExportToExcelML object?