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

RadGridViewExcelExporter -- Export to multiple sheets

10 Answers 147 Views
GridView
This is a migrated thread and some comments may be shown as answers.
DNV Cleaner Energy
Top achievements
Rank 1
DNV Cleaner Energy asked on 23 Jul 2010, 11:21 PM
I have a TabStrip with different RadGridViews in different tabs. I would like to export these grids into multiple Worksheets in a single file. How can I do that?

10 Answers, 1 is accepted

Sort by
0
DNV Cleaner Energy
Top achievements
Rank 1
answered on 27 Jul 2010, 07:12 PM
Any updates on this one? We would like to export gridviews from multiple tabs into a single excel file, but in different worksheets within the same file. Looks like a straightforward requirement.

I find that only the last sheet is written and all previously written sheets do not exist.
0
Jack
Telerik team
answered on 28 Jul 2010, 03:34 PM
Hi Veeramani Pulacode,

Thank you for contacting us. Currently this feature is not available in our Export to Excel feature. However, it is interesting and we will consider implementing it in one of our upcoming releases.

Sincerely yours,
Jack
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Dipak
Top achievements
Rank 1
answered on 20 Oct 2010, 06:29 PM
I am also in need this feature. Can we have any work arround for this please?

Thanks
Dipak
0
DNV Cleaner Energy
Top achievements
Rank 1
answered on 20 Oct 2010, 06:31 PM
Our development team went along with the export to multiple excel files and then working with them.
0
Martin Vasilev
Telerik team
answered on 26 Oct 2010, 09:58 AM
Hi guys,

Thank you for contacting us.

There is no workaround for exporting multiple grids to a single file in different sheets. If we receive more enquiries concerning this feature, we will increase its higher.

Do not hesitate to contact us if you have any other questions.

Sincerely yours,
Martin Vasilev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Dale
Top achievements
Rank 1
answered on 21 Sep 2011, 08:19 PM

Hi Telerik,


We also have a TabStrip with different RadGridViews in different tabs.

 

We need to export these grids to multiple worksheets in the same Excel file.

 

Our IT department had quite a bit of difficult convincing management to use Silverlight & Telerik.

 

Now the first high profile report in Silverlight / Telerik we need to do for executive management, we must give them in multiple Excel files and ask  them to manually copy the data from one spreadsheet to the other because the option to export the data as they view it on the screen does not exist.

 

This is not a good option as it reflects poorly on our IT department and the products we have selected.

 

Please increase the priority of this project as this is the first of many reports that we need this functionality.

 

Regards,

Mitch Royster
Freight Systems Inc
0
Mitch
Top achievements
Rank 1
answered on 27 Sep 2011, 01:54 PM
Hi Vlad,

Thank you for the sample project.

The code example to export the radgridviews to multiple worksheets within the same workbook worked great.

However, I still have two issues.

I would like to name the worksheets and .SheetName does not work. I have tried several other options but have not been able to get it to work. Suggestions?

Also, as you mentioned, the user must click on a tab before the data is available to be exported. Is there a way to do this programmatically so the user does not have to click on the tab before exporting the data? The 1st tab is displayed when the grids load. I thought I could set focus to the 2nd tab in code (to cause the data to load), then set focus back to the 1st tab, but it is not working. Suggestions?

Thanks for your help.

Regards,
Mitch Royster
Freight Systems Inc.

0
Dipak
Top achievements
Rank 1
answered on 18 Oct 2011, 04:09 PM
Could you please share this sample project?
0
Nikolay
Telerik team
answered on 21 Oct 2011, 11:50 AM
Hello Dipak,

Please note that Mitch is targeting our Silverlight suite while you are mainly using our WinForms suite. Are you still interested in the Silverlight solution?

Mitch, if you have further questions regarding the current topic, I would kindly ask you to post them in the appropriate forum section. Please note that the current thread is in the WinForms forums. Posting your enquiry in the appropriate section will allow those interested in the same question to find the answer more easily.

Thank you for your understanding and cooperation.

All the best,
Nikolay
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

0
Mitch
Top achievements
Rank 1
answered on 21 Oct 2011, 01:10 PM
I resloved all the issues. Everything is working now.

Thanks,
Mitch Royster
Tags
GridView
Asked by
DNV Cleaner Energy
Top achievements
Rank 1
Answers by
DNV Cleaner Energy
Top achievements
Rank 1
Jack
Telerik team
Dipak
Top achievements
Rank 1
Martin Vasilev
Telerik team
Dale
Top achievements
Rank 1
Mitch
Top achievements
Rank 1
Nikolay
Telerik team
Share this question
or