angular5 - ag-grid angular 5 导出隐藏，列

Question

我正在为 angular 5 上的 ag-grid 列开发导出功能

这是我的专栏的代码：

columnDefs = [{  
  headerName:'',
  field:'',
  pinned:true,
  headerCheckboxSelection:true,
  headerCheckboxSelectionFilteredOnly:true,
  width:42,
  checkboxSelection:true
}, {  
  headerName:'Actions',
  field:'_id.$oid',
  cellRenderer:'viewModalRenderer',
  pinned:true
}, {  
  headerName:'Status',
  field:'status'
}, {  
  headerName:'Category',
  field:'category',
  cellRenderer:'viewCetegoryRenderer',
  width:120,
  editable:true,
  hide:true
}, {  
  headerName:'Created',
  field:'created',
  editable:true,
  filter:'agDateColumnFilter'
}, {  
  headerName:'Price',
  field:'price',
  filter:'agNumberColumnFilter',
  width:120,
  editable:true
}];

我正在调用这个函数来导出

onBtnExport() {
  let params = {}
  this.gridApi.exportDataAsCsv(params);
}

如何在我的导出中包含标记为 hide: true 的 Category 列？

标签： angular5ag-grid

Answer 1

试试这个代码：

   exportCsv() {       
    var excelParams = {
        columnKeys: ['firstName', 'middleName','lastName', 'dob'],
        allColumns: false,
        fileName: 'Student List.csv',
        skipHeader: false,
        customHeader: 'Student List' + '\n',
        customFooter: '\n \n Total No.Of Students :' + this.gridOptions.api.getModel().getRowCount() + ' \n'
    }
    this.gridOptions.api.exportDataAsCsv(excelParams);
}

定义要在 columnKeys 中显示的列