使用easyPoi导入导出Excel

老规矩，先导入jar

      <dependency>
          <groupId>cn.afterturn</groupId>
          <artifactId>easypoi-base</artifactId>
          <version>3.2.0</version>
      </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>

首先将目标实体类添加序列化

implements java.io.Serializable

然后在每个属性上设置，name就是相应excel上面的列名

@Excel(name = "name",height = 20,width = 30)

然后就可以导入了

//需要前端传入multipartFile，可以将excel文件解析成相应的实体类        
ImportParams params = new ImportParams();
params.setTitleRows(1);
params.setHeadRows(1);
List list =ExcelImportUtil.importExcel(multipartFile.getInputStream(),entity.class,params);

然后就可以处理了

 

导出

Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("测试1","表1"),
                entity.class, list);

然后对用流对workbook进行处理就可以了