Export multiple grids into single excel file

Hi,

We have a page with 4 grids, all the 4 have individual export to excel buttons and export works fine. Recently our end user asked if we can download all these grids into a single excel file. IgxGrid doesn’t seem to have an immediate solution. Please let me know if there is anything we can do with underlying apis to achieve this.

Thank you.

Hello,

Currently the IgxExcelExporterService creates a new file everytime the export method is used, so I can suggest combining all data in one array, and then using the exportData method instead.

Or you are looking to add them on separate worksheets?

Sincerely,
Tihomir Tonev
Associate Software Developer
Infragistics

Hi Tihomir,

We have already explored exportData method. Using this method, we were losing the format as displayed in the grid, and it prints the raw data from the grids. Instead we are looking for a way to combine the output of export method on to a single sheet or multiple sheets if possible.

Thank you.

Hello Lohith,

Currently the ExcelExportService does not support exporting multiple grids to the same file, so that would be a feature request.

You can submit feature request in our GitHub repository here.  

Remember when submitting your idea to explain the context in which a feature would be used and why it is needed as well as anything that would prevent you from accomplishing this today. You can even add screenshots to build a stronger case. 

This will give you the opportunity do directly communicate with our development team regarding the issue and get notifications whenever a new information is available. 

Please let me know if you need any further assistance. 

 

Regards, 
Tihomir Tonev
Associate Software Developer
Infragistics