export multiple grids to one excel file

[VLADISLAV]

I need to export data from 3 different grids into one excel file.How can i do that?

 

[Dimitar]

Hi Vladislav,

Thank you for writing.

You can use the SpreadExport functionality and export each grid in a separate sheet: 

private void radButton1_Click(object sender, EventArgs e)
{
    foreach (Control grd in this.Controls)
    {
        if (grd is RadGridView)
        {
            GridViewSpreadExport spreadExporter = new GridViewSpreadExport(((RadGridView)grd));
            SpreadExportRenderer exportRenderer = new SpreadExportRenderer();

            spreadExporter.SheetName = grd.Name;
            spreadExporter.FileExportMode = FileExportMode.NewSheetInExistingFile;
            spreadExporter.RunExport(@"C:\sample.xslx", exportRenderer);
        }
    }
}

Please let me know if there is something else I can help you with. 

 

Regards,
Dimitar
Telerik

[VLADISLAV]

oh, thanks for reply.

in exportToExcelML method im used exporter_ExcelTableCreated method fo headers on the sheet.

but for spreadexport i found only cellformatting event.So how i can edit tables and headers for sheet?

[Dimitar]

Hello Vladislav,

Thank you for writing back.

The following article shows how you can add header and footer: Add Header and Footer to the Exported Document.

Please let me know if there is something else I can help you with. 

 

Regards,
Dimitar
Telerik