开发时需要写一个excel导出的需求,自己就参考了网上的一些方法,然后自己整理了一下。
需要引入的架包
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.14</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.14</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>3.14</version>
</dependency>
核心代码
public void exportExcel(String id,HttpServletResponse response) throws IOException {
response.setContentType("application/vnd.ms-excel");
response.setHeader("ContentDisposition