EasyExcel操作excel文档

EasyExcel操作excel文档

EasyExcel

导入依赖

<dependency><groupId>com.alibaba</groupId><artifactId>easyexcel</artifactId><version>3.0.5</version>
</dependency>

读文件：

public class TestUserinfo {String path = "C:\work\hl\IT\apache-maven-3.8.1\ideaPro\poi-easyexcel\";//详细步骤@Testpublic void readUserinfo() {//1、构建建造者对象ExcelReaderBuilder readerBuilder = ad();//2、获取文件对象readerBuilder.file(path+"userinfo.xlsx");//3、指定sheetreaderBuilder.sheet(0);//4、自动关闭流readerBuilder.autoCloseStream(true);//5、设置文件格式xls  or   lType(ExcelTypeEnum.XLSX);//6、注册监听器进行数据解析isterReadListener(new AnalysisEventListener() {@Overridepublic void invoke(Object o, AnalysisContext analysisContext) {System.out.println(o);}@Overridepublic void doAfterAllAnalysed(AnalysisContext analysisContext) {System.out.println("数据已读取");}});//7、构建读取器，开始读取数据ExcelReader reader=readerBuilder.build();adAll();reader.finish();}//简洁写法@Testpublic void easyReadUserinfo(){List<UserInfo> list=new LinkedList<>();ad(path+"userinfo.xlsx").head(UserInfo.class).sheet(0).registerReadListener(new AnalysisEventListener<UserInfo>() {@Overridepublic void invoke(UserInfo userInfo, AnalysisContext analysisContext) {list.add(userInfo);}@Overridepublic void doAfterAllAnalysed(AnalysisContext analysisContext) {}}).doRead();for (UserInfo users : list) {System.out.println(users);}}
}

写文件：

@Test
public void writeUserinfo(){List<UserInfo> list=getUserExcel(path);EasyExcel.write(path+"userinfo_副本.xlsx").head(UserInfo.class).excelType(ExcelTypeEnum.XLSX).sheet().doWrite(list);
}public static List<UserInfo> getUserExcel(String path){List<UserInfo> list=new LinkedList<>();ad(path+"userinfo.xlsx").head(UserInfo.class).sheet(0).registerReadListener(new AnalysisEventListener<UserInfo>() {@Overridepublic void invoke(UserInfo userInfo, AnalysisContext analysisContext) {list.add(userInfo);}@Overridepublic void doAfterAllAnalysed(AnalysisContext analysisContext) {}}).doRead();return list;
}

userinfo

@Data
public class UserInfo {@ExcelProperty("id")private String id;@ExcelProperty("username")private String username;@ExcelProperty("post")private String post;@ExcelProperty("permisson")private Integer permisson;
}