EasyPoi 使用记录
EasyPoi 官网
官网文档很详细, 在此记录实际开发中使用代码备忘
解析Excel表格
@Data
public class ExcelMediaInfo {
// orderNum:A=1,B=2,类推
@Excel(name = "姓名", orderNum = "2")
private String title;
@Excel(name = "年龄", orderNum = "4")
private int age;
}
InputStream inputStream = file.getInputStream();
long start = System.currentTimeMillis();
ImportParams params = new ImportParams();
params.setHeadRows(1); // 忽略文档标题栏内容
List<ExcelInfo> mediaInfos = ExcelImportUtil.importExcel(inputStream, ExcelInfo.class, params);
System.out.println("解析Excel表>> 总:" + mediaInfos.size() + "条 耗时:" + (System.currentTimeMillis() - start) + "毫秒");