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,
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?