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

Export to Excel - Multiple Grids

3 Answers 145 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Rodney
Top achievements
Rank 1
Rodney asked on 17 Jan 2012, 05:07 PM
I have a dashboard with 3 separate grids on it, while I can export each grid to a separate excel file that works great.  I was wondering if it's possible to export the 3 grids to a single excel file but on different sheets?

Thanks in advance.

3 Answers, 1 is accepted

Sort by
0
Ivan Petrov
Telerik team
answered on 20 Jan 2012, 12:10 PM
Hi Rodney,

Thank you for writing.

Currently, the ExportToExcelML does not support this kind of export. The only possibility is to create a single file with one or more sheets which contain the elements from one grid. I have added your feature request to our Public Issue Tracking System - PITS. You can comment and/or add your vote for it on the following link PITS - Feature

I hope this will be useful for you. If you have other questions, feel free to write back.

Greetings,
Ivan Petrov
the Telerik team

SP1 of Q3’11 of RadControls for WinForms is available for download (see what's new).

0
Rodney
Top achievements
Rank 1
answered on 20 Jan 2012, 04:57 PM
Hi Ivan
Thanks for the information, but can you elaborate on your statement "The only possibility is to create a single file with one or more sheets which contain the elements from one grid."  Do you have any examples that you can send me?

Thanks,
Rodney
 
0
Ivan Petrov
Telerik team
answered on 25 Jan 2012, 10:11 AM
Hello Rodney,

Thank you for your reply.

Our export to ExcelML feature allows setting the maximum number of rows per sheet that can be exported, to do this you should set the SheetMaxRows property of ExportToExcelML. You can use the following values: 65536 or 1048576. When RadGridView is being exported and this number of rows is reached, the exporter creates additional sheet and continues to export rows in it.

I hope this helps. If you need further assistance do not hesitate to write back.

All the best,
Ivan Petrov
the Telerik team

SP1 of Q3’11 of RadControls for WinForms is available for download (see what's new).

Tags
GridView
Asked by
Rodney
Top achievements
Rank 1
Answers by
Ivan Petrov
Telerik team
Rodney
Top achievements
Rank 1
Share this question
or