offers excellent performance and does not require MS Office installation on user machines. The ExcelML
format can be read by MS Excel 2002 (MS Office XP) and above. Direct export to the xlsx format is possible by utilizing our RadSpreadProcessing libraries in the GridViewSpreadExport
. The GridViewSpreadStreamExport
uses the RadSpreadStreamProcessing
library which allows you to create big documents (without loading the entire document in the memory) and export them to the most common formats.
For the common case, I would recommend you to use the GridViewSpreadExport
. The WorkbookCreated
event is triggered on the SpreadExportRenderer
object when the workbook is ready to be exported. You can introduce any final changes to the exported workbook. Additional information is available in the following help article: https://docs.telerik.com/devtools/winforms/gridview/exporting-data/spreadstream-export
- In order to export only the selected rows in RadGridView
, you can create a new RadGridView
filled only with the selected data and then export this new grid. There is not a built-in mechanism for this.
- The FileExportMode
property determines whether the data will be exported into an existing or a new file. If new is chosen and such exists it will be overridden. Available options are:
: This option will create a new sheet in an already existing file.
: Creates new or overrides an existing file.
I hope this information helps. If you need any further assistance please don't hesitate to contact me.
Dess | Tech Support Engineer, Sr.
Get quickly onboarded and successful
with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.