Hello,
I am using version 2012.3 and am trying to export a RadGridView to excel. The data table is very large, over 1bil cells, and when I try to export to excel I get an out of memory exception.
The project can only be deployed as an x86 platform application. I included the code below, how can I export a large table in this application?
Thank you,
Eli
SaveFileDialog dialog = new SaveFileDialog();
string extension = "xml";
dialog.DefaultExt = extension;
dialog.Filter = string.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", extension, "ExcelML");
dialog.FilterIndex = 1;
if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string exportString = radGridView.ToExcelML();
using (Stream stream = dialog.OpenFile())
{
byte[] bytes = Encoding.UTF8.GetBytes(exportString);
stream.Write(bytes, 0, bytes.Length);
}
}
I am using version 2012.3 and am trying to export a RadGridView to excel. The data table is very large, over 1bil cells, and when I try to export to excel I get an out of memory exception.
The project can only be deployed as an x86 platform application. I included the code below, how can I export a large table in this application?
Thank you,
Eli
SaveFileDialog dialog = new SaveFileDialog();
string extension = "xml";
dialog.DefaultExt = extension;
dialog.Filter = string.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", extension, "ExcelML");
dialog.FilterIndex = 1;
if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string exportString = radGridView.ToExcelML();
using (Stream stream = dialog.OpenFile())
{
byte[] bytes = Encoding.UTF8.GetBytes(exportString);
stream.Write(bytes, 0, bytes.Length);
}
}