CODEWITHSUNDEEP
javascriptangularag-gridag-grid-ng2
rkiyer
rkiyer

Reputation: 101

AG-Grid skip column on export to CSV

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?

Upvotes: 9

Views: 14538

Answers (4)

Jett
Jett

Reputation: 880

This is what worked for me:

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

You get the fields from the ColumnDef

Upvotes: 10

Tommy Hansen
Tommy Hansen

Reputation: 161

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);
    }

Upvotes: 0

gurpreet singh
gurpreet singh

Reputation: 11

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'];
};

Upvotes: 1

Paritosh
Paritosh

Reputation: 11570

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.

Upvotes: 3

Related Questions