package com.codvision.gms.easyExcel;
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
import com.alibaba.excel.support.ExcelTypeEnum;
import com.codvision.gms.easyExcel.bean.ExcelData;
import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;
public class TestWrite {
public static void main(String[] args) {
List<ExcelData> list = parseData();
EasyExcel.write("C:\\Users\\dongbobo\\Desktop\\测试文件.xls")
.head(ExcelData.class)
.excelType(ExcelTypeEnum.XLS)
.sheet("测试文件")
.doWrite(list);
}
public static List<ExcelData> parseData() {
final List<ExcelData> list = new LinkedList<>();
EasyExcel.read("C:\\Users\\dongbobo\\Desktop\\测试名单.xls")
.head(ExcelData.class)
.sheet().registerReadListener(new AnalysisEventListener<ExcelData>() {
@Override
public void invoke(ExcelData excelData, AnalysisContext analysisContext) {
list.add(excelData);
}
@Override
public void doAfterAllAnalysed(AnalysisContext analysisContext) {
System.out.println("数据读取完毕");
}
}).doRead();
for (ExcelData excelData : list) {
System.out.println(excelData);
}
return list;
}
}
package com.codvision.gms.easyExcel.bean;
import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;
import java.util.Date;
@Data
public class ExcelData {
@ExcelProperty("ID")
private String id;
@ExcelProperty("用户名")
private String name;
@ExcelProperty("性别")
private String gender;
@ExcelProperty("积分")
private Integer score;
@ExcelProperty("IP")
private String ip;
@ExcelProperty("登入次数")
private Integer count;
@ExcelProperty("加入时间")
private Date date;
}