pom引用:
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.1.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.1.2</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>4.1.2</version>
</dependency>
- 创建输入流读取Excel
FileInputStream fis = new FileInputStream(file.getAbsolutePath());
2.使用XSSFWorkbook对象获取Excel文件
XSSFWorkbook sheets = new XSSFWorkbook(is);
3.一些方法
//获取单个sheet
sheet = sheets.getSheetAt(0);
// 得到所有的行数
int rows = sheet.getPhysicalNumberOfRows();
// 得到每一行的数据
XSSFRow row = sheet.getRow(j);
// 获取单元格的数据,去空格
row.getCell(0).toString().trim()