private static void getXLSDate(String filePath) throws BiffException, IOException{
List<Map<String, String>> listMaps = new ArrayList<Map<String,String>>();
Workbook book = Workbook.getWorkbook(new File(filePath));
Sheet sheet = book.getSheet(0);
for (int i = 11; i < sheet.getRows(); i++) {
Map<String, String> map = new HashMap<String, String>();
for (int j = 0; j < sheet.getColumns(); j++) {
Cell cell = sheet.getCell(j, i);
String result = cell.getContents();
map.put(new String("key" + j), result);
System.out.println("key" + j + "<-->" + result);
}
System.out.println("-------------------------------------");
listMaps.add(map);
}
System.out.println(listMaps.size());
}
根据路径 读取excel 文件内容
最新推荐文章于 2024-05-17 11:22:12 发布