SpringBoot下载Excel模板

1、首先创建一个Excel模板

2、将模板放在项目的resources目录下，我在此放在了resources/excelTemplates目录下

3、写接口

@GetMapping("/download") @Operation(summary = "获取Excel模板") public void download(HttpServletResponse response) throws IOException { //定义要下载的Excel文件名 String excelName="学生信息.xlsx"; //获取classpath下的模板文件资源 ClassPathResource resource = new ClassPathResource("excelTemplates/"+excelName); // 读取资源并写入 HTTP 响应 try (InputStream in = resource.getInputStream()) { //设置 HTTP 响应头 String fileName = URLEncoder.encode(excelName , StandardCharsets.UTF_8); response.setContentType("application/octet-stream"); response.setHeader("Content-Disposition", "attachment; filename=\"" + fileName + "\""); in.transferTo(response.getOutputStream()); } }