Question

java 怎么读取excel单元格

Answer 1

InputStream is = new FileInputStream("*****.xls");//加载excel文档
HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is);
// 工作表Sheet
for (int numSheet = 0; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++) {
HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(numSheet);
if (hssfSheet == null) {
continue;
}
// 循环行Row
for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {
HSSFRow hssfRow = hssfSheet.getRow(rowNum);
if (hssfRow == null) {
continue;
}
//doSomething 做具体的逻辑
}
}

Answer 2

Apache 网站上有 POI 教程。