I have a column in a table which has only buttons in it. The button is a download button. I dont what this column to be exported when i click on export to csv. Can this be done?

I have a column in a table which has only buttons in it. The button is a download button. I dont what this column to be exported when i click on export to csv. Can this be done?

• javascript
• angular
• ag-grid
• ag-grid-ng2

4 Answers 4

This is what worked for me:

exportToExcel() {
var params = {
    columnKeys: ['FIELDA', 'FIELDB', 'FIELDC']
};
this.gridApi.exportDataAsCsv(params);
}

You get the fields from the ColumnDef

You can specify which columns data you want in export while calling gridApi.exportDataAsCsv(params). You can mention that in columnKeys parameter.

params.columnKeys = ["country", "bronze"];
this.gridApi.exportDataAsCsv(params);

Reference: ag-grid: CSV export

Check the result - if you check Specify Columns checkbox, only the above mentioned columns will be there in the CSV.

Internally it search for colId of a particular column. AG Grid adds '_1' to every field as a unique colId.

Try this , It will work.

Under ColDefs , if your field name is : FieldA , FieldB.

const params = {
columnKeys: ['FieldA_1','FieldB_1'];
};

To avoid a 1st checkbox column in an export:

    exportToExcel() {
       let params = {
          columnKeys: this.gridApi.getColumns().slice(1).map((col: Column) => col.getColId())
        };

       this.gridApi.exportDataAsCsv(params);
    }