[Solved] Export to Excel - Adding Sheets dynamically

[Agm]

Hi,

I am using RadGrid in my webpage.

I want to use the Export to Excel option for my criteria.

If I am having 1000 rows in a grid , that should be exported to 10 sheets in a same Excel workbook.

that is 1000 rows split into 10 sheets each having 100 rows in that.(Row Count is variable)

Please anyone help me in this.

Thanks in advance.
---------
AGMRAJA