RadGridView ExportToWorkbook very slow

[Deltaohm]

Hi,

I use RadGridView.ExportToWorkbook on a grid with over 600 000 rows: the operation take much than 5' to end. Can I speed up it?

Thank you

Luigi

[Martin Ivanov]

Hello Gianluca,

Exporting such big amount of data takes some time. To improve this, you can delegate the part that saves the Workbook into a stream (like a file stream) to another thread. For example:

        private BackgroundWorker worker;
	private Workbook documentToExport;
	private XlsxFormatProvider provider = new XlsxFormatProvider();

	private void InitializeExportWorker()
	{
		worker = new BackgroundWorker();
		worker.DoWork += Worker_DoWork;
		worker.RunWorkerCompleted += Worker_RunWorkerCompleted;
	}

	private void Worker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
	{
		// report export completed if needed
		this.documentToExport = null;
	}

	private void Worker_DoWork(object sender, DoWorkEventArgs e)
	{   
		using (var output = File.Open("sampleDocument.xlsx", FileMode.OpenOrCreate))
		{
			provider.Export(this.documentToExport, output);
		}
	}

	public MainWindow()
	{
		InitializeExportWorker();
		InitializeComponent(); 		
	}

	private void RadButton_Click(object sender, RoutedEventArgs e)
	{
		this.documentToExport = this.gridView.ExportToWorkbook();
		this.worker.RunWorkerAsync();
	}

Or alternatively, you can use the SpreadStreaming exporting: https://docs.telerik.com/devtools/wpf/controls/radgridview/export/excel/export-with-spreadsheetstreamingexport

I hope this information helps.

Regards,
Martin Ivanov
Progress Telerik