Export datagrid to excel sheets

[VK]

Hey,

I have some nested datagrids, which I would like to
export to a excel. Exporting is not a problem - however I
would like to export the nested data into different sheets
on the same excel page. Is that possible. Basically I just
need to know how to create new sheets in excel.

Thanks

 

[Steve C. Orr [MVP, MCSD]]

For this functionality I'd suggest a 3rd party component such as this:
http://SteveOrr.net/reviews/AsposeExcel.aspx