Export two grids to one excel sheet | Infragistics Forums

State See Verified Answer
Replies 9 replies
Subscribers 4 subscribers
Views 2157591 views
Users 0 members are here

165

Export two grids to one excel sheet

Srinivas posted over 15 years ago

Hi

I'm facing a problem that I have to export the data from two ultra web grids to one single excel sheet in a workbook.

can anybody help me in solving this.

Regards.

Parents

No Data

Reply

19308

[Infragistics] Tony Lombardo posted over 15 years ago

There are a bunch of overrides on the Export method. The one you'll want to use in particular is Export(grid, worksheet, startrow, startcolumn)

In order to use this method, you'll want to create a new workbook, which can be done by leveraging the Infragistics.Excel library.

Hope this helps,

-Tony
Cancel
Reply

Verify Answer

Cancel

Children

165

Srinivas posted over 15 years ago in reply to [Infragistics] Tony Lombardo

Thank u for ur reply tony.

the override you recommended is good, but using this we can export only one grid at a time. what exactly I need is to export 2 grids at a time to a single worksheet.

I tried to export 2 grids in a single postback with WebGridExcelExporter It is exporting only the last grid.

I think this behaviour is by design.

UltraWebGridExcelExporter clears the Output Stream when it is asked to render itself, renders the binary file to the stream, and then (to prevent later controls from rendering) it kills all other Controls on the Page except itself. Hence, the content is a pure XLS file.

If the UltraWebGridExeclExporter is asked to do this twice in a single post-back, the spreadsheet that opens would represent the last call made to Export() since the second Export() clears the stream established by the first Export().

Is there any another way to achieve this.?

regards

Ceenu
Cancel
Reply

Verify Answer

Cancel