Export several grid to a single Excel | Infragistics Forums

1965

Export several grid to a single Excel

Parthiban posted over 12 years ago

Hi,

could any one help to export several grids' data to a single export file?

I would appreciate, if any one oculd provide sample.

Thanks in advance,

Parthiban Sekar

37874

[Infragistics] Nikolay posted over 12 years ago in reply to Parthiban

Hi Parthiban,

I'm glad you solved your issue.

Feel free to contact me if you have any other questions regarding the matter.
Cancel
Reply

Cancel
1965

Parthiban posted over 12 years ago

Thanks, i found the option for exporting to seperate sheets of excel.
Cancel
Reply

Cancel
1965

Parthiban posted over 12 years ago in reply to [Infragistics] Nikolay

but i need it in different sheets of the same excel file.

Thanks,

Parthiban Sekar
Cancel
Reply

Cancel
37874

[Infragistics] Nikolay posted over 12 years ago

Hi Parthiban,

You should just pass an array of WebDataGrids to the Export method:

protected void Button1_Click(object sender, EventArgs e)

{

    WebDataGrid[] gridsToExport = new WebDataGrid[2];

    gridsToExport[0] = WebDataGrid1;

    gridsToExport[1] = WebDataGrid2;

    WebExcelExporter1.Export(gridsToExport);

}

Let me know if you have any further questions.
Cancel
Reply

Cancel