**1. 前端代码** 前端代码可以参考【SpringBoot->导出功能实现】，或【SpringBoot->实现文件下载】小节来编写。 **2. 后端代码** ```java /** * 导出方法只能返回 void，返回其他会报错 */ @RequestMapping("/excel/download") public void download(HttpServletResponse response) throws IOException { ... SXSSFWorkbook workbook = new SXSSFWorkbook(); ... //导出的文件名，fileName如下写可以防止导出的文件名中文乱码 String fileName = URLEncoder.encode("excel导出", "UTF-8").replaceAll("\\+", "%20"); //设置响应的数据类型 //03版本的.xls设置为：application/vnd.ms-excel //07版本的.xlsx设置为：application/vnd.openxmlformats-officedocument.spreadsheetml.sheet response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); response.setCharacterEncoding("utf-8"); response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx"); //调用workbook.write(response.getOutputStream())即可实现导出 workbook.write(response.getOutputStream()); workbook.dispose(); workbook.close(); } ```