handleExport: () => {
state.paramsExport = {};
state.paramsExport = {
ids: state.selectedRowKeys,
...state.searchData,
};
excelExport(state.paramsExport).then(response => {
const blob = new Blob([response], {
type:
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
})
const objectUrl = window.URL.createObjectURL(blob)
const a = document.createElement('a')
document.body.appendChild(a)
a.style = 'display: none'
a.href = objectUrl
a.download = '任务导出'
a.click()
document.body.removeChild(a)
})
},
export const excelExport = (data) => {
return request({
url: '/api/whles-les/v1/les/vTsTaskInfo/exportFile',
method: 'post',
data: data,
responseType: 'blob',
});
};
try {
String fileName = "任务导出" + ".xlsx";
fileName = new String(fileName.getBytes(StandardCharsets.UTF_8), StandardCharsets.ISO_8859_1);
response.addHeader("Content-Disposition", "filename=" + fileName);
response.setContentType("application/vnd.ms-excel");
ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).build();
WriteSheet writeSheet1 = EasyExcel.writerSheet(0, "叉车").head(TsTaskInfoDto.class).build();
WriteSheet writeSheet2 = EasyExcel.writerSheet(1, "拖拉机").head(TsTaskInfoDto.class).build();
WriteSheet writeSheet3 = EasyExcel.writerSheet(2, "汽车吊").head(TsTaskInfoDto.class).build();
WriteSheet writeSheet4 = EasyExcel.writerSheet(3, "液压平板车").head(TsTaskInfoDto.class).build();
excelWriter.write(forklift, writeSheet1);
excelWriter.write(tractor, writeSheet2);
excelWriter.write(truckCrane, writeSheet3);
excelWriter.write(flatCar, writeSheet4);
excelWriter.finish();
response.flushBuffer();
} catch (Exception e) {
throw new IllegalArgumentException("导出失败");
}
return "导出成功";