Export Multiple Gridview to single Excel Sheet with Multiple sheet

5 posts, 1 answers
  1. Smith
    Smith avatar
    8 posts
    Member since:
    Jun 2012

    Posted 14 Jun 2012 Link to this post

    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
  2.
  3. Smith
    Smith avatar
    8 posts
    Member since:
    Jun 2012

    Posted 15 Jun 2012 Link to this post

    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

  5. Answer
    Ivan Petrov
    Admin
    Ivan Petrov avatar
    717 posts

    Posted 18 Jun 2012 Link to this post

    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
    RadControls for WinForms Q2'12 release is now live! Check out what's new or download a free trial >>
  7. Agila
    Agila avatar
    1 posts
    Member since:
    Nov 2017

    Posted 22 Nov 2017 in reply to Ivan Petrov Link to this post

    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.

  8.
  9. Hristo
    Admin
    Hristo avatar
    1520 posts

    Posted 22 Nov 2017 Link to this post

    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
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top