InputStream inputStream = new FileInputStream("c:\\工作薄.xls");读取工作簿
POIFSFileSystem fileSystem = new POIFSFileSystem(inputStream);//获取工作簿流
HSSFWorkbook workbook = new HSSFWorkbook(fileSystem);创建工作簿
workbook.getNumberOfSheets()//获取到工作簿的个数
HSSFSheet hssfSheet = workbook.getSheetAt(0);//创建一个Sheet页
if (hssfSheet == null) {
return;
}
//row
for (int rowNum = 0; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {
HSSFRow hssfRow = hssfSheet.getRow(rowNum);
if (hssfRow == null) {
continue;
}
//单元格
for (int cellNum = 0; cellNum <= hssfRow.getLastCellNum(); cellNum++) {
HSSFCell cell = hssfRow.getCell(cellNum);
if (cell == null) {
continue;
}
System.out.print(" " + getValue(cell));
}
System.out.println();
}