Spring boot Spring cloudSpringboot

SpringBoot整合EasyPOI实现Excel、Word的

2019-05-30  本文已影响77人  消失的码农

一、EsayPOI的介绍

easypoi 功能如同名字easy,主打的功能就是容易。让一个没见接触过poi的人员就可以方便的写出Excel导出,Excel导出,Excel导入,Word模板导出,通过简单的注解和模板语言(熟悉的表达式语法),完成以前复杂的写法


二、EsayPOI引入依赖并配置

1.引入依赖

      <!--引入EasyPOI-->
      <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version>3.0.3</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>3.0.3</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>3.0.3</version>
        </dependency>

2.引入依赖

 public class StudentEntity implements java.io.Serializable {
    /** id*/
    private String id;
    /** 学生姓名*/
    @Excel(name = "学生姓名", height = 20, width = 30, isImportField = "true_st")
    private String name;
    /**学生性别*/
    @Excel(name = "学生性别", replace = { "男_1", "女_2" }, suffix = "生", isImportField = "true_st")
    private int sex;

    @Excel(name = "出生日期", databaseFormat = "yyyyMMddHHmmss", format = "yyyy-MM-dd", isImportField = "true_st", width = 20)
    private Date birthday;

    @Excel(name = "进校日期", databaseFormat = "yyyyMMddHHmmss", format = "yyyy-MM-dd")
    private Date registrationDate;
 }

样例如下所示:


导出的表格

3.导出的Java代码

FileOutputStream fos = null;
try (Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("2412312", "测试", "测试"), Area.class, list)) {
    fos = new FileOutputStream("G:/ExcelExportHasImgTest.exportCompanyImg.xls");
    workbook.write(fos);
}catch (IOException e){
    e.printStackTrace();
}finally {
    fos.close();
}
上一篇 下一篇

猜你喜欢

热点阅读