SpringBoot+Jxls

1.导入jar包
<!-- https://mvnrepository.com/artifact/org.jxls/jxls -->
<dependency>
   <groupId>org.jxls</groupId>
   <artifactId>jxls</artifactId>
   <version>2.6.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.jxls/jxls-poi -->
<dependency>
   <groupId>org.jxls</groupId>
   <artifactId>jxls-poi</artifactId>
   <version>2.6.0-rc1</version>
</dependency>
2.编码
Context context = new Context();
context.putVar("underwriteExpInfos", underwriteExpInfos);
response.setHeader("content-type", "application/octet-stream");
response.setCharacterEncoding("utf-8");
response.setHeader("Content-Disposition", "attachment;fileName=" + new String(("***.xls").getBytes(),"ISO-8859-1"));
JxlsHelper.getInstance().processTemplate(fis, response.getOutputStream(), context);
3.模板
　　第一个单元格添加批注 jx:area(lastCell=”L3”) jxls解析模板面积到3行L列
　　第一行数据添加备注 jx:each(items=”underwriteExpInfos”,var=”underwriteExpInfo”,lastCell=”L3”) 行数据解析到3行L列

 

转载于:https://www.cnblogs.com/god-monk/p/11322197.html