ag-grid 20 with Angular 6 export functionality

Question

Need help to export some records in ag-grid.

I am trying to export(csv) certain records from ag-grid in my application. I can't use rowSelection. Manually selecting some records and wants to export those records only.

  const selectedRows = [{name: 'A'}, {name: 'b'}];

   const params = {
    skipHeader: false,
    columnKeys: ['name'],
    fileName: 'Test_' + Date.now()
  };

  this.GridOptions.api.exportDataAsCsv(params);

Here how can I pass the selectedRows to the API?

Thanks in advance!!!

abd995 · Accepted Answer · 2019-07-25 18:45:53Z

You can programatically select the desired RouterLinkWithHref, ask ag-grid to export the selected rows and then deselect them after printing if necessary.

  const selectedRows = [{name: 'A'}, {name: 'b'}];

  this.GridOptions.api.forEachNode((node) => {
    // Check to determine if the row should be selected for printing
    // Replace with your logic if necessary
    if (selectedRows.findIndex((x) => x.name === node.data.name)) {
      // select the row
      node.setSelected(true);
    } else {
      // deselect the row
      node.selected(false);
    }
  });

   const params = {
    // only selected rows will be exported
    onlySelected: true,
    skipHeader: false,
    columnKeys: ['name'],
    fileName: 'Test_' + Date.now()    
  };

  this.GridOptions.api.exportDataAsCsv(params);

  // deselect all rows
  this.GridOptions.api.foreachNode((node) => {
      node.setSelected(false);
  });

Collectives™ on Stack Overflow

ag-grid 20 with Angular 6 export functionality

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related