excel poi导出总结

使用easypoi导出总结

建一个到处实体类对应，然后

需要的pom

<!-- easy-poi -->
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-base</artifactId>
    <version>3.2.0</version>
    <exclusions>
        <exclusion>
            <artifactId>guava</artifactId>
            <groupId>com.google.guava</groupId>
        </exclusion>
    </exclusions>
</dependency>
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-web</artifactId>
    <version>3.2.0</version>
</dependency>
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-annotation</artifactId>
    <version>3.2.0</version>
</dependency>

 

response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
response.setHeader("Content-Disposition", "attachment;filename=fileName.xlsx");
Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("1", "1", ExcelType.XSSF), ExportExcel.class, list);
ExportExcel对应刚才建的实体类，list查询的数据集合
这里面有两种格式设置如果要导出xlsx要注意配置上面的配置尤其是

要配置和上面同步，否则导出的xlsx文件打开提示文件格式或文件扩展名无效，

用的是这个类创建工作薄的时候，用Workbookworkbook=newXSSFWorkbook();
导出大量数据，POI3.8之后出现了SXSSFWorkbook ，用SXSSFWorkbook wb =new SXSSFWorkbook();

 

 

如果要导出xls格式 

response.setContentType("application/vnd.ms-excel");
response.addHeader("Content-Disposition","attachment;filename=fileName"+".xls");

将上面设置

Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("1", "1", ExcelType.HSSF), ExportExcel.class, list);
ExportExcel对应刚才建的实体类，list查询的数据集合