2

Trying to access all data rendered in Ag-Grid - including the value of calculated columns which use value getters. I have only been able to access the data provided to Ag-Grid, but not any calculated columns (see code below).

  var items = [];
  var cnt = gridOptions.api.getDisplayedRowCount();
  for (var i = 0; i < cnt; i++) {
    var rowNode = gridOptions.api.getDisplayedRowAtIndex(i);
    items.push(rowNode.data);
  }

Any suggestions would be greatly appreciated. I'm trying to save the output of the calculated columns to a database.

FirstRedPepper
  • 452
  • 5
  • 20

2 Answers2

2

Thought of a workaround - write to the data within the valueGetter function. This way the data stores the calculated values and can then be exported using the built-in api functions (such as using forEachNode). 

valueGetter: function (params){

  //your normal value getter logic here
  var output = params.data['column1'] + params.data['column2']

  //write to the data
  var col = params.colDef.field;
  params.data[col] = output;

  return output;

}
FirstRedPepper
  • 452
  • 5
  • 20
  • This is really interesting. In my case, this doesn't work for those lazy loaded columns at the far right of my table until I scroll to them. If I scroll to the lazy-loaded calculated fields, only then the calculated data becomes available with the above code. I'm on `ag-grid-community: 24.1.0` and `ag-grid-angular: 24.1.0`. – Qarun Qadir Bissoondial Sep 13 '21 at 15:26
1

This is how I did it without having to directly to data within the valueGetter function. It's not super clean but it gets the calculated value as expected. I'm on version 24.1.0.

const columnKeys = this.gridColumnApi.getColumnState().map(c => c.colId);
const rows = [];

this.gridApi.forEachNode(rowNode => {
  const row = [];
  for (const key of columnKeys) {
    // getValue will get the calculated value at key in the rowNode
    row.push(this.gridApi.getValue(key, rowNode));
  }

  rows.push(row);
});

console.log(rows);
Qarun Qadir Bissoondial
  • 194
  • 13