Export Multiple Gridview to single Excel Sheet with Multiple sheet

[Smith]

Hello
I want to export data from multiple RadGridView to a single Excel file with multiple sheet. What I tried now it can export only 1 gridview to 1 file, if I try to export to same file, it was overwritten.

I did a search and found that it can't be done during last year. not sure what is the current status now.

http://www.telerik.com/community/forums/winforms/gridview/export-to-excel-with-gridview.aspx

Could anyone provide me an example please?

Best Regards,
Smith

[Smith]

Hello
I notice that telerik asp.net support exporting to multiple sheets in single excel file. Is it possible to borrow that and use them in winform please?

http://www.telerik.com/community/code-library/aspnet-ajax/grid/export-multiple-radgrids-in-single-pdf-excel-file.aspx

http://www.telerik.com/community/forums/aspnet-ajax/grid/radgrid-export-to-csv-or-excel-how-to-export-to-multiple-sheets.aspx

http://www.telerik.com/community/code-library/aspnet-ajax/grid/multiple-worksheets-in-excelml.aspx

Best Regards,
Smith

[Ivan Petrov]

Hi Smith,

Thank you for writing.

This functionality is not supported by the ExportToExcelML functionality. We have added this as a feature request into our Public Issue Tracking System - PITS. You can add your vote/comment on the following link - PITS Feature. If there are many users that require this feature, we will consider it when we make our future development plans.

I hope this will be useful. Should you have further questions, I would be glad to help.
 
Kind regards,
Ivan Petrov
the Telerik team

[Agila]

Hello Team,

Is there any updates for this functionality??

Currently, we are using ExportToXlsx method to perform excel export. Is there any possibility to export to multiple sheet from a Rad GridView.

Please update with some examples.

Thank you.

[Hristo]

Hello Agila,

Thank you for writing.

You can use the GridViewSpreadExport class which utilizes the SpreadProcessing libraries exporting natively to Excel. The spread export object exposes and FileExportMode property and you can set it so that you export multiple grids in a single file each being on a separate sheet: 

GridViewSpreadExport spreadExporter = new GridViewSpreadExport(this.radGridView1);
spreadExporter.FileExportMode = FileExportMode.NewSheetInExistingFile;

Please check the following documentation article providing detailed information: https://docs.telerik.com/devtools/winforms/gridview/exporting-data/spread-export.

I hope this helps. Should you have further questions please do not hesitate to write back.

Regards,
Hristo
Progress Telerik