How can we merge multiple grid excelExporter data in a single excel file.?
Support Forum
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
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