谷神Ag-Grid导出Excel
let allDiscolumns = detailTable.getAllDisColumns()
let columnColIds = columns.map(column => column.colId)
let columnKeys = columnColIds.filter(item => !['select', "_OPT_FIELD_"].includes(item))
detailTable.table.api.exportDataAsExcel({columnKeys,onlySelected: true,
})
batchSetDataValue
function batchSetDataValue (detailTable, fieldName, value) {detailTable.getData().forEach(row => {detailTable.setDataValue(row[detailTable.BILL_BATCH], fieldName, value)})
}
detailTable.getData().forEach(row => {detailTable.setDataValue(row[detailTable.BILL_BATCH], fieldName, value)
})