EasyExcel的基本使用

    com.alibaba
    easyexcel
    2.1.1




    org.apache.poi
    poi
    3.17



    org.apache.poi
    poi-ooxml
    3.17

package com.xsha.demo.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;

@Data
public class MyData {
    // 设置excel表表头
    @ExcelProperty(value = "学生编号")
    private String sno;

    @ExcelProperty(value = "学生姓名")
    private String sname;
}

  // 实现EasyExcel写操作
  @Test
  public void writeExcel() {
      // 1.设置写入文件夹地址和excel文件名称
      String filename = "D:\xusha\SpringProjects\guli_parent\service\service_education\src\test\java\com\xsha\demo\excel\files\write.xlsx";
      // 2.准备数据集
      List list = new ArrayList<>();
      for (int i = 0; i <5; i++) {
          MyData data = new MyData();
          data.setSno(i);
          data.setSname("xiansen"+i);
          list.add(data);
      }
      // 3.调用EasyExcel里面的方法实现写的操作，第一个参数是文件路径，第二个参数是实体类名称
      EasyExcel.write(filename, MyData.class).sheet("学生列表").doWrite(list);
  }  

package com.xsha.demo.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;

@Data
public class MyData {

    // 设置excel表表头
    @ExcelProperty(value = "学生编号", index = 0)
    private Integer sno;

    @ExcelProperty(value = "学生姓名", index = 1)
    private String sname;
}

package com.xsha.demo.excel;

import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;

import java.util.Map;

public class ExcelListener extends AnalysisEventListener {
    // 逐行读取excel表格的内容
    @Override
    public void invoke(MyData data, AnalysisContext analysisContext) {
        System.out.println(data.getSno()+"-----"+data.getSname());
    }
    
    // 读取表头的内容
    @Override
    public void invokeHeadMap(Map headMap, AnalysisContext context) {
        System.out.println("表头："+headMap);
    }
    
    // 读取完成之后
    @Override
    public void doAfterAllAnalysed(AnalysisContext analysisContext) {
    
    }
}  

// 实现EasyExcel读操作
@Test
public void readExcel() {
    // 1.设置读取文件夹地址和excel文件名称
    String filename = "D:\xusha\SpringProjects\guli_parent\service\service_education\src\test\java\com\xsha\demo\excel\files\write.xlsx";
    // 3.调用EasyExcel里面的方法实现读的操作，第一个参数是文件路径，第二个参数是实体类名称，第三个参数是监听器
    EasyExcel.read(filename, MyData.class, new ExcelListener()).sheet("学生列表").doRead();
}