RAD Grid - Export to excel - Adding worksheet dynamically

[Meenakshi Nagalingam]

Hi,

I have the following requirement in our application and i'm using RAD Grid Q2 2009 version:

1. The records in the grid should be grouped based on say column A

2. While exporting to excel, it should export the data in new worksheet for every new group (here column A).

Item# 1 can be achieved using <GroupByFields> option that comes with the grid. 

While exploring options for Item# 2, i came to know from the following url, 

http://www.telerik.com/help/aspnet-ajax/grdexport.html

we can override ExcelML exporting. So i thought of using RadGrid1_ExcelMLExportRowCreated event since that would be the apt event to create a worksheet for my requirement. But i couldn't find any stuff to create worksheet dynamically! 

Please let me know is that achievable?

Thanks

[Sebastian]

Hello Meenakshi,

Unfortunately the export functionality you request (exporting different groups in separate Excel sheets) is not supported by our web grid. I hope that exporting the entire grid in a single Excel sheet is feasible workaround for your situation.

Nevertheless, I will appreciate if you direct us to online resources or other web grids which have this type of functionality integrated. Thus we will research the matter further to consider it for implementation.
 
Kind regards,
Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Agm]

Hi Sebastian,

I want to export 100 records from RadGrid to 10 work sheets that having 10 records per sheet.

please give a solution for this.

Thanks in advance.

AGMRAJA

[Agm]

Hi Sebastian,

I want to export 100 records from RadGrid to 10 work sheets that having 10 records per sheet.

please give a solution for this.

Thanks in advance.

AGMRAJA