装载流
public static List<Map<String, Object>> importExcel(MultipartFile file, Object obj) throws Exception {
//装载流
XSSFWorkbook hw = new XSSFWorkbook(file.getInputStream());
//获取第一个sheet页
XSSFSheet sheet = hw.getSheetAt(0);
//容器
List<Map<String, Object>> ret = new ArrayList<Map<String, Object>>();
//遍历行 从下标第一行开始(去除标题)
for (int i = 2; i <= sheet.getLastRowNum(); i++) {
XSSFRow row = sheet.getRow(i);
if (row != null) {
//装载obj
ret.add(dataObj(obj, row));
}
}
return ret;
}
拼装单个obj
private static Map<String, Object> dataObj(Object obj, XSSFRow row) throws Exception {
Class<?> rowClazz = obj.getClass();
Field[] fields = FieldUtils.getAllF