springboot项目resource导出excel模板问题_获取resource下的excel模板导出

excel模板位于resource下面时

直接用文件流导出

    public void getTemplate(HttpServletRequest request, HttpServletResponse response) {
        try (InputStream inputStream = this.getClass().getClassLoader().getResourceAsStream("template/template.xls");
             OutputStream out = response.getOutputStream()
        ){
            if (inputStream == null) {
                throw  new GlobalException("模板不存在！");
            }

            response.setContentType("application/octet-stream");
            String fileName = URLEncoder.encode("模板","utf-8");
            response.setCharacterEncoding("utf-8");
            response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xls");
            response.setContentType("application/vnd.ms-excel ;charset=UTF-8");
            byte[] bytes = new byte[1024 * 2];
            while(inputStream.read(bytes) != -1){
                out.write(bytes);
            }
            out.flush();
        } catch (Exception e) {
            e.printStackTrace();
            throw  new GlobalException("导出失败！");
        }
    }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

结果会文件损坏，或乱码，如下图

原因分析-sprintboot默认会压缩resource下的excel

解决方法

pom文件的build下添加关闭压缩配置

		<plugin>
			<groupId>org.apache.maven.plugins</groupId>
			<version>2.6</version>
			<artifactId>maven-resources-plugin</artifactId>
			<configuration>
				<encoding>UTF-8</encoding>
				<nonFilteredFileExtensions>
					<nonFilteredFileExtension>xls</nonFilteredFileExtension>
					<nonFilteredFileExtension>xlsx</nonFilteredFileExtension>
				</nonFilteredFileExtensions>
			</configuration>
		</plugin>
1
2
3
4
5
6
7
8
9
10
11
12