1 获取所有表格内容
ExcelReader reader = ExcelUtil.getReader("d:/aaa.xlsx");
List<Map<String,Object>> readAll = reader.readAll();
2 获取单个sheet内容
//通过sheet编号获取
ExcelReader reader = ExcelUtil.getReader(FileUtil.file("test.xlsx"), 0);
//通过sheet名获取
ExcelReader reader2 = ExcelUtil.getReader(FileUtil.file("test.xlsx"), "sheet1");
List<Map<String,Object>> readAll = reader.readAll();
3 获取单行内容
ExcelReader reader = ExcelUtil.getReader("d:/aaa.xlsx");
//获取第一行内容
List<Map<String, Object>> mapList =reader.read(0,1,1);
//第一行无数据
if(mapList==null||mapList.size==0){
return;
}
4 获取单个单元格内容
ExcelReader reader = ExcelUtil.getReader("d:/aaa.xlsx");
//获取第四行第三列单