一.依赖
<dependencies>
<!-- https://mvnrepository.com/artifact/com.alibaba/easyexcel -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.1.1</version>
</dependency>
</dependencies>
二.创建实体类
三.监听器
public class ExcelListener extends AnalysisEventListener<UserData> {
//一行一行读取Excel的内容,从第二行读
@Override
public void invoke(UserData userData, AnalysisContext analysisContext) {
System.out.println(userData);
}
@Override
public void invokeHeadMap(Map<Integer, String> headMap, AnalysisContext context) {
System.out.println("表头信息"+headMap);
}
//读取之后执行
@Override
public void doAfterAllAnalysed(AnalysisContext analysisContext) {
}
}
4.读
public class testRead {
public static void main(String[] args) {
//读取的路径
String filename="C:\\Users\\dell\\Desktop\\excel\\01.xlsx";
//调用方法 实现读取操作
EasyExcel.read(filename, UserData.class,new ExcelListener()).sheet().doRead();
}
}
5.写
public class TestWrite {
public static void main(String[] args) {
//构建一个数据的集合
List<UserData> list = new ArrayList<>();
for (int i=0;i<10;i++){
UserData data=new UserData();
data.setUid(i);
data.setUsername("lucy"+i);
list.add(data);
}
//设置Excel文件的路径和文件名称
String filename="C:\\Users\\dell\\Desktop\\excel\\01.xlsx";
//调用方法实现写的操作
EasyExcel.write(filename,UserData.class).sheet("用户的信息")
.doWrite(list);
}
}