**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(); } ```