EasyExcel朝左excel进行读写操作

EasyExcel朝左excel进行读写操作

写操作步骤：
1.引入依赖

<!-- https://mvnrepository.com/artifact/com.alibaba/easyexcel -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>easyexcel</artifactId>
        <version>2.1.1</version>
    </dependency>
  <!--xls-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
        </dependency>
        <dependency>
            <groupId>commons-fileupload</groupId>
            <artifactId>commons-fileupload</artifactId>
        </dependency>

2.创建实体类，和excel对应起来

@Data
public class DemoDate {
    //设置excel表头名称
    @ExcelProperty("学生编号")
    private  Integer sno;
    @ExcelProperty("学生姓名")
    private  String sname;

}

3.实现写的功能

public class TestTasyExcel {
    public static void main(String[] args) {
        //实现Excel写的操作
        //1.设置入文件夹地址和Excel文件名称
        String fileName="E:\\学习资料\\在线教育平台\\EasyExcel读写操作.xls";

        //调用EasyExcel里面的方法实现操作
        //第一个参数是文件路径，第二个是实体类
        EasyExcel.write(fileName,DemoDate.class)
                .sheet("学生列表").doWrite(getDate());
    }

    //创建方法返回list集合
    private static List<DemoDate> getDate(){
        ArrayList<DemoDate> list = new ArrayList<>();
        for (int i = 0; i < 10; i++) {
            DemoDate date = new DemoDate();
            date.setSno(i);
            date.setSname("lucy"+i);
            list.add(date);
        }
        return list;
    }
}

读操作步骤：
1.和excel对应实体类，标注对应列关系

2.创建监听进行读取

public class ExcelLinstener extends AnalysisEventListener<DemoDate> {
    //一行一行的读取
    @Override
    public void invoke(DemoDate demoDate, AnalysisContext analysisContext) {
        System.out.println("=======>"+demoDate);
    }
    //读取表头内容
    public void invokeHeadMap(Map<Integer, String> headMap, AnalysisContext context) {
        System.out.println("=======>"+headMap);
    }

    //读取完成后
    @Override
    public void doAfterAllAnalysed(AnalysisContext analysisContext) {

    }
}

//实现操作

  //实现读的操作
        String fileName="E:\\\\学习资料\\\\在线教育平台\\\\EasyExcel读写操作.xls";
        EasyExcel.read(fileName,DemoDate.class,new ExcelLinstener()).sheet().doRead();