后端
设置响应
response.setContentType("application/octet-stream;charset=UTF-8");
String returnName = null;
try {
returnName = URLEncoder.encode(fileName, "UTF-8");
} catch (UnsupportedEncodingException e) {
throw new RuntimeException(e);
}
response.setHeader("Content-Disposition", "attachment;filename=" + returnName);
往response 写入数据
try (ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).build();) {
if (hasXL) {
WriteSheet writeSheet2 = EasyExcel.writerSheet(2, "小料费用差异对比").head(DepreciationEquipXLDto.class).build();
List<DepreciationEquipXLDto> data2 = assetDepreciationSingleDetailService.getDepreciationEquXLCompare(entityList);
excelWriter.write(data2, writeSheet2);
}
if (hasJL) {
WriteSheet writeSheet = EasyExcel.writerSheet(0, "其他费用差异对比").head(DepreciationOtherDto.class).build();
List<DepreciationOtherDto> data = assetDepreciationSingleDetailService.getDepreciationOtherCompare(entityList);
excelWriter.write(data, writeSheet);
WriteSheet writeSheet1 = EasyExcel.writerSheet(1, "胶料费用差异对比").head(DepreciationEquipJLDto.class).build();
List<DepreciationEquipJLDto> data1 = assetDepreciationSingleDetailService.getDepreciationEquJLCompare(entityList);
excelWriter.write(data1, writeSheet1);
}
WriteSheet writeSheet3 = EasyExcel.writerSheet(3, "总费用差异对比").head(DepreciationTotalDto.class).build();
List<DepreciationTotalDto> data3 = assetDepreciationSingleDetailService.getDepreciationTotalCompare(entityList);
excelWriter.write(data3, writeSheet3);
WriteSheet writeSheet4 = EasyExcel.writerSheet(4, "折旧明细").head(DepreciationSingleDetailDto.class).build();
List<DepreciationSingleDetailDto> data4 = assetDepreciationSingleDetailService.getDepreciationSingleDetail(entityList);
excelWriter.write(data4, writeSheet4);
} catch (IOException e) {
throw new RuntimeException(e);
}
前端
- 后端返回了之后,有响应数据,但是不会自动下载
- 前端定义的返回类型必须是blob类型
- 创建隐式a标签,自动点击下载
export function downloadCompareFile(data) {
return request({
url: '/client/depreciationDetail/downloadCompareFile',
method: 'post',
data: data,
responseType: 'blob'
})
}
downloadCompareFile(){
downloadCompareFile(this.compareDataListParams)
.then((res) => {
const content = res
const blob = new Blob([content])
console.log(content)
const fileName = 'xxx.xlsx'
if ('download' in document.createElement('a')) {
const elink = document.createElement('a')
elink.download = fileName
elink.style.display = 'none'
elink.href = URL.createObjectURL(blob)
document.body.appendChild(elink)
elink.click()
URL.revokeObjectURL(elink.href)
document.body.removeChild(elink)
}
}
)
},
参考
https://blog.csdn.net/weixin_43597991/article/details/127861599