How to Excel Export multiple grids to the same file using worksheets

1 Answer 27 Views
Grid
Enzo
Top achievements
Rank 1
Enzo asked on 03 Feb 2022, 04:06 PM | edited on 03 Feb 2022, 04:08 PM

Hello,

How can we export multiple telerikgrids to the same excel file ? When using the built-in export it's easy to get one file per grid, but is there any way (maybe using the MemoryStream) to merge those files together into one file with multiple worksheets ?

 

1 Answer, 1 is accepted

Sort by
0
Matthias
Top achievements
Rank 5
Bronze
Bronze
Iron
answered on 04 Feb 2022, 06:09 PM

Hi Enzo,

one possibility is to change the following example. I also use a customized variant of it.

Telerik-Example

This gives you more control - but the columns should be present in all workbooks.

Alternatively, you can use the standard method, save it on the server and then load and merge it with Telerik Spread Processing.

best regards

Tags
Grid
Asked by
Enzo
Top achievements
Rank 1
Answers by
Matthias
Top achievements
Rank 5
Bronze
Bronze
Iron
Share this question
or