Exporting Dataset to Excel

5 posts, 0 answers
  1. Kapil
    Kapil avatar
    2 posts
    Member since:
    May 2012

    Posted 09 May 2012 Link to this post

    Hi,

    I have a telerik grid view where i am showing one table from my dataset which contains total 4 tables. Now while exporting to excel, i want to export all the tables instead of just one. How can i achieve this using telerik features.


    thanks
    kapil
  2. Richard Slade
    Richard Slade avatar
    3000 posts
    Member since:
    May 2009

    Posted 09 May 2012 Link to this post

    Hello Kapil. 

    If I understand you correctly, you want to be able to export data to Excel that is stored in your data table. 
    To do this, you would need to bind the data to a RadGridView and then export the RadGridView to excel /exceml

    You can read more about exporting data from the RadGridView to Excel/ExcelML at this link

    Hope that helps
    Richard
  3. UI for WinForms is Visual Studio 2017 Ready
  4. Kapil
    Kapil avatar
    2 posts
    Member since:
    May 2012

    Posted 09 May 2012 Link to this post

    Hi Richard,

    I have the Dataset which contains 4 tables, i want to export all these to excel as one sheet per table. There are 4 grids but i can't go for 4 different excel files as requirement is for single file with data of these 4 tables in good format.

    Let me know if you need more details.

    thanks
    kapil
  5. Richard Slade
    Richard Slade avatar
    3000 posts
    Member since:
    May 2009

    Posted 10 May 2012 Link to this post

    Hi Kapil, 

    Currently this feature is not supported. You may be able to work around it though using Max Rows. You can also vote for this feature that has already been requested by others. 

    Please see this forum thread which will give you the workaround and the link to vote for the feature. 

    If you need further help, just let me know. If you found this helps, please remember to mark as answer
    Thanks
    Richard
  6. Ivan Petrov
    Admin
    Ivan Petrov avatar
    701 posts

    Posted 11 May 2012 Link to this post

    Hi guys,

    Thank you both for writing.

    As Richard indicated this is a functionality which we will consider implementing in future, if more people ask for it. Until then, you can export the four tables into four different excel files and then you can copy the sheets into one file through some library that allows editing excel files.

    I hope this will be useful. Should you have further questions, I would be glad to help.
     
    Greetings,
    Ivan Petrov
    the Telerik team
    RadControls for WinForms Q1'12 release is now live! Check out what's new or download a free trial >>
Back to Top
UI for WinForms is Visual Studio 2017 Ready