后端代码
/** * 小票数据导出 */ @RequestMapping(value = "/export.do" ) public ResponseEntity<byte[]> receiptRawExport(HttpServletRequest request, @RequestBody FilterReceiptDto dto) throws IOException { // 干了很多活 HSSFWorkbook workbook = ExcelUtils.excel(newlist,requestContext); ByteArrayOutputStream output = new ByteArrayOutputStream(); workbook.write(output); return new ResponseEntity<byte[]>(output.toByteArray(), headers, HttpStatus.CREATED); }
前端代码
that.$axios({ // 用axios发送post请求 method: 'post', // 请求地址 url: '/export.do', // 参数 data: { orgId: 1 }, // 表明返回服务器返回的数据类型 responseType: 'blob' }) .then((res) => { // 处理返回的文件流 debugger; const content = res.data const blob = new Blob([content]) const fileName = '导出.xls' if ('download' in document.createElement('a')) { // 非IE下载 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) // 释放URL 对象 document.body.removeChild(elink) } else { // IE10+下载 navigator.msSaveBlob(blob, fileName) } })