Wrong Perfomance Exporting to Excel

[Cesar]

Hello guys

Im using the 2011 Q1, for exporting data from gridview using the ExportToExcelML way, the data in the grid is about 100.000 rows and 50 columns, when use the RunExport method my application freeze, after 60 seconds fall in an exception. 

Follows the code implemented:

 Dim exporter As ExportToExcelML = New ExportToExcelML(vs.RadGridView1)
exporter.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport
exporter.ExportVisualSettings = False
exporter.SheetMaxRows = ExcelMaxRows._65536
exporter.SheetName = ruta
exporter.SummariesExportOption = SummariesOption.ExportAll
exporter.RunExport(strExportedFile)

Are there any method to fix that error?

Regards

[Martin Vasilev]

Hello Cesar,

Thank you for writing.

Although in theory ExportToExcelML can be used to export such large data, I would not recommend it, mainly because it creates files in a special xml format rather than in the native Excel format. That means exporting 100k rows and 50 columns would create enormously large file, which will be hard to be handled by Excel itself. 

Instead, I would recommend using ExportToCSV method. In your case, this approach will be more appropriate in terms of performance and functionality. 

Let me know if you have any additional questions.

All the best,
Martin Vasilev
the Telerik team