radgrid export to excel on different worksheets

[Ruby]

Hi, I am trying to export 3 different radgrids to three excel worsheets (sheet1, sheet2, sheet3) within the same excel file. Could you please suggest some code on this.

[Princy]

Hi Ruby,

Please have a look into the following code-library project demonstrates how to export data to more than one worksheet. 
Multiple worksheets in ExcelML

Thanks,
Princy

[Ruby]

Hi Princy, I have gone through this code before which you suggested above, but not sure how to assign datatable to the new worksheet, could you please suggest some code on this. Thanks.

protected void RadGrid1_GridExporting(object source, GridExportingArgs e)
{
StringBuilder sb = new StringBuilder();
WorksheetElement workSheet = new WorksheetElement("ASP.NET Table"); //create new worksheet
workSheet.Table = ?
workSheet.Render(sb); //generate xmlss code
e.ExportOutput = e.ExportOutput.Replace("</Styles>", "</Styles>" + sb.ToString()); //add the rendered worksheet to the output
}

[Angel Petrov]

Hi Ruby,

I strongly suggest that you examine this link where a possible realization of the scenario is illustrated. The code in the example is configured in such way that the user has the option to export the grids in one spreadsheet or in different ones.

Regards,
Angel Petrov
Telerik