1.添加依赖
maven中写入
<!-- 2007 xls 版本 -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
<!-- 2013 xlsx版本-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
2.java代码
public static void main(String[] args) throws Exception {
// FileInputStream fileInputStream = new FileInputStream("E:\\testfile\\台账.xls");
FileInputStream fileInputStream = new FileInputStream(path);
// 讲输入流转为Workbook
Workbook workbook = new XSSFWorkbook(fileInputStream);
// 得到总表数
int sheet_num =