Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

185
Views
How to export multiple grids data into single excel file in the single sheet

i have multiple ag grids running under foreach loop , i want to perform excel export and all the data from multiple grids should be exported into single excel within the single sheet. Can someone help me on that . Any help on this will be helpful

about 4 years ago · Santiago Trujillo
1 answers
Answer question

0

Not sure that I understand your use case:

  1. if your AG Grid instances have different column definitions, then the best solution would be to use an external library which handles the export to excel
  2. if all your grid instances have the same column definitions and only the dataset(rowdata) is different, then you could: a. collect the data from all grids in a single colletion b. create a "headless" AG Grid instance on the fly, pass the columnDefs & rowData and use the exporting mechanism via the API:

    const gridOptions: GridOptions = {
      columnDefs, // shared column defs
      rowData, // aggregated data from all grid instances
    };

    const grid = new Grid(document.createElement('div'), gridOptions);

    gridOptions.api.exportDataAsExcel({
      sheetName: 'Sheet 1',
      fileName: fileName,
    });

    grid.destroy();

about 4 years ago · Santiago Trujillo Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!