This is a migrated thread and some comments may be shown as answers.

Exporting Dataset to Excel

4 Answers 113 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Kapil
Top achievements
Rank 1
Kapil asked on 09 May 2012, 08:21 AM
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

4 Answers, 1 is accepted

Sort by
0
Richard Slade
Top achievements
Rank 2
answered on 09 May 2012, 09:05 AM
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
0
Kapil
Top achievements
Rank 1
answered on 09 May 2012, 10:40 AM
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
0
Richard Slade
Top achievements
Rank 2
answered on 10 May 2012, 09:15 AM
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
0
Ivan Petrov
Telerik team
answered on 11 May 2012, 04:41 PM
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 >>
Tags
GridView
Asked by
Kapil
Top achievements
Rank 1
Answers by
Richard Slade
Top achievements
Rank 2
Kapil
Top achievements
Rank 1
Ivan Petrov
Telerik team
Share this question
or