AG-GRID Excel Export: Is there any way in AG-Grid to configure Records Export Limit per user?

Question

Is there any way to to restrict Excel Export limit from AG-Grid, so that only allowed number of rows can be exported by a User.

For an Example, if Grid is showing 75,000 Records, can we limit Excel to export only 10,000 (or any configurable number) records ?

Out of curiosity: did you ever solve your problem? – Alexander Zbinden Feb 24 '20 at 08:43 — Alexander Zbinden, Feb 24 '20 at 08:43
@AlexanderZbinden yes, It worked like a charm. Thanks – kashif Oct 16 '20 at 03:21 — kashif, Oct 16 '20 at 03:21

score 1 · Accepted Answer · answered Feb 05 '20 at 11:51

Not per configuration, no. But you can implement this functionality yourself as one of the exportparams for

gridOptions.api.exportDataAsExcel(exportParams);

is a callback function shouldRowBeSkipped.

So a possible implementation would look something like this (not tested):

var exportedRows = 0;

var exportParams = {
  shouldRowBeSkipped: function(params) {
    exportedRows++;
    return exportedRows <= 10000;
  }
};

gridOptions.api.exportDataAsExcel(exportParams);

Have a look at all the export params: https://www.ag-grid.com/javascript-grid-export/

AG-GRID Excel Export: Is there any way in AG-Grid to configure Records Export Limit per user?

1 Answers1