[Solved] is it possible to export multiple grids into individual worksheets in an excel file

[Steven]

I've got a page with 4 grids on it. For exporting we have a button that uses the following code to export the data.

protected void ExportToExcel_Click(object sender, EventArgs e)
{

    RG.ExportSettings.ExportOnlyData = true;
    RG.ExportSettings.IgnorePaging = true;
    RG.ExportSettings.OpenInNewWindow = true;
    RG.ExportSettings.FileName = "Assessment_Outcomes_Detail_" + DateTime.Today.Month.ToString() + "_" + DateTime.Today.Day.ToString() + "_" + DateTime.Today.Year.ToString();
    RG.MasterTableView.ExportToExcel();
}

Is it possible to do something so that each grid is placed into a worksheet  and then the excel file exported? Instead of having our user export each grid into its own excel file.

thanks

[Shinu]

Hi,

Check the following code library.
Multiple worksheets in ExcelML

Thanks,
Shinu.