pom.xml 配置poi版本
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.13</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.13</version>
</dependency>
读取本地Excel文件
private HSSFWorkbook getWorkBookFromExcel(){
POIFSFileSystem filein = new POIFSFileSystem(new FileInputStream("E:\\files\\11.xls"));
HSSFWorkbook workbook = new HSSFWorkbook(filein);
HSSFSheet aging = workbook.getSheet("Aging");
HSSFSheet tmp = workbook.getSheet("tmp");
HSSFSheet sheet0 = workbook.getSheetAt(0);
return workbook ;
}
<