onexport() {
// this.downloadLoading = true
import('@/vendor/Export2Excel').then(excel => {
const tHeader = ['账期', '供应商名称', '供应商提交数', '供应商计费数', '结算提交数', '结算计费数', '结算金额', '应付金额', '应扣条数', '确认状态', '付款凭证状态', '付款状态', '发票状态', '账单状态', '返佣金额', '返佣状态', '返补贴金额', '返补贴状态', '返代理费金额', '返代理费状态', '返服务费金额', '返服务费状态']
const filterVal = ['BillData', 'SupplierName', 'SupplierSubmitCnt', 'SupplierChargingCnt', 'SettlementSubmitCnt', 'SettlementChargingCnt', 'SettlementTotalPrice', 'CopeWithTotalPrice', 'DeductionCnt', 'SupplierStatus', 'UploadStatus', 'UploadStatus', 'UploadStatus', 'UploadStatus', 'CommissionTotalPrice', 'CommissionStatus', 'SubsidyTotalPrice', 'SubsidyStatus', 'ProxyTotalPrice', 'ProxyStatus', 'ServiceTotalPrice', 'ServiceStatus']
const list = this.tableData
const data = this.formatJson(filterVal, list)
excel.export_json_to_excel({
header: tHeader, // 表头 必填
data, // 具体数据 必填
filename: '供应商账单', // 非必填
autoWidth: true, // 非必填
bookType: 'xlsx' // 非必填
})
// this.downloadLoading = false
})
},
formatJson(filterVal, jsonData) {
return jsonData.map(v => filterVal.map(j => {
if (j === 'timestamp') {
return parseTime(v[j])
} else {
return v[j]
}
}))
},
下载表格--导出
于 2022-03-30 17:49:47 首次发布