RadGridViewExcelExporter -- Export to multiple sheets

[DNV Cleaner Energy]

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?

[DNV Cleaner Energy]

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.

[Jack]

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

[Dipak]

I am also in need this feature. Can we have any work arround for this please?

Thanks
Dipak

[DNV Cleaner Energy]

Our development team went along with the export to multiple excel files and then working with them.

[Martin Vasilev]

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

[Dale]

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

[Mitch]

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.

[Dipak]

Could you please share this sample project?

[Nikolay]

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

[Mitch]

I resloved all the issues. Everything is working now.

Thanks,
Mitch Royster