使用Easypoi 4.0
1、 使用Map方式
String[] titles = {"学校名称","班级","学生姓名","身份证号"};
ImportParams params = new ImportParams();
String [] t = titleList.toArray(new String[titleList.size()]);
params.setImportFields(t);
List<Map<String, Object>> list =
ExcelImportUtil.importExcel(file.getInputStream(), Map.class, params);
2、 使用实体类方式
实体类
public class ExamineeImportBO {
//
@Excel(name = "学校",type=1)
private String school;
@Excel(name = "姓名",type=1)
private String name;
//...
List<ExamineeImportBO> dataList =
ExcelImportUtil.importExcel(file.getInputStream(),
ExamineeImportBO.class, new ImportParams());
for (ExamineeImportBO examineeBO : examineeImportBOList) {
List<String> errMessageList = new ArrayList<>();
Map<String, Object> dbObj = new HashMap<>();
Map<String, Object> rowObj = BeanUtils.toMap(examineeBO);
