public class DemoMD5 {
public static void main(String[] args) throws Exception {
List<List<Object>> allList = ExcelUtil.getReader(FileUtil.file("C:\\temp\\test001.xlsx")).read();
allList.remove(0);
// 获得标题行
List<Object> objectList1 = allList.get(0);
System.out.println(objectList1);
List<JSONObject> list = Lists.newArrayList();
for (List<Object> objectList : allList) {
JSONObject jsonObject = new JSONObject();
for (int i = 0; i < objectList1.size(); i++) {
jsonObject.put(objectList1.get(i).toString(), objectList.get(i));
}
list.add(jsonObject);
}
System.out.println(list);
}
}
excel转json
最新推荐文章于 2024-05-27 17:10:02 发布