Our blazing fast Grid component built with pure JavaScript


Post by Webethics »

How can we merge multiple grid excelExporter data in a single excel file.?


Post by alex.l »

Could you please clarify? Export works per grid, it's not supported to do single export for few datasets.

All the best,
Alex


Post by Webethics »

We have implemented multiple grids in my project. please have a look at the screenshot- https://prnt.sc/7ACPbx3eICbU.
For that, we have generated the multiple excel file for each grid by calling the export excel instance.

But now I want to merge the export excel instance into a single export.

Is it possible to merge the export excel instance of multiple grids?
Or Can we generate a separate sheet for each grid within the single Excel file?

Thanks


Post by alex.l »

Not supported out of the box, but we have https://bryntum.com/docs/gantt/api/Grid/util/TableExporter that you may use to prepare your data, merge arrays as you need and use https://www.npmjs.com/package/zipcelx to export that to Excel file.

All the best,
Alex


Post Reply