Telerik Forums / UI for ASP.NET AJAX
This is a migrated thread and some comments may be shown as answers.

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

1 Answer 35 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Steven
Top achievements
Rank 1
Steven asked on 20 Jun 2013, 05:22 PM

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


1 Answer, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 21 Jun 2013, 06:07 AM
Hi,

Check the following code library.
Multiple worksheets in ExcelML

Thanks,
Shinu.
Tags
Grid
Asked by
Steven
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
Share this question
or