poi组件读取xls文件
程序员文章站
2022-07-13 13:11:24
...
依赖:
<dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.10-FINAL</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml-schemas</artifactId> <version>3.10-FINAL</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>3.10-FINAL</version> </dependency>
读操作:
public void poi() throws Exception {
String path = "/home/linkrmb/领客网data/linkrmb.com.xls";
InputStream is = new FileInputStream(path);
HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is);
// Read the Sheet
for (int numSheet = 0; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++) {
HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(numSheet);
if (hssfSheet == null) {
continue;
}
for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {
HSSFRow hssfRow = hssfSheet.getRow(rowNum);
for (Cell cell : hssfRow) {
log.info("value:{}", cell.getStringCellValue());
}
}
}
}
另外一种做法,通用性比较好,支持xls的03,07版本
Workbook workbook = WorkbookFactory.create(new FileInputStream(path));
Sheet hssfSheet = workbook.getSheetAt(0);
for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {
Row hssfRow = hssfSheet.getRow(rowNum);
for (Cell cell : hssfRow) {
System.out.println(CommonUtils.getXlsValue(cell));
}
}
上一篇: 使用POI操作XLS文件
下一篇: jquery 选择器