Exporting Dataset to Excel

[Kapil]

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

[Richard Slade]

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

[Kapil]

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

[Richard Slade]

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

[Ivan Petrov]

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