Export to Excel with RadGridView for WinForms
In this RadTip, John Kellar demonstrates how you can export data stored in a RadGridView for Windows Forms to Excel using the ExcelML export options. (Runtime: 08:52)
RadGridView supports several built-in methods for exporting data:
SpreadExcelExport: Available since R3 2014 (version 2014.3.1021). Allows export to XSLX, CSV, PDF and TXT formats. Supported with .NET 4.0 or newer. The exporter utilized the RadSpreadProcessing library, where you have the whole excel workbook available for edit.
SpreadStreemExport: Utilized RadSpreadStreamProcessing library, hence does not load the entire document in the memory, instead it writes everything straight to the file. Useful for exporting large amount of data.
Export to Excel via ExcelML: Exports to Excel ML (XML format), and can be opened with excel as well. Use for .NET 2.0 applications.
As of R1 2012 RadGridView natively supports printing. More information about this feature can be found here.