Java 利用poi解析Excel文件

1.导入依赖如下:

<dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.14</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>3.14</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml-schemas</artifactId> <version>3.14</version> </dependency>

2.简单示例如下:

import org.apache.poi.openxml4j.exceptions.InvalidFormatException; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; public class AnalyzeExcell { public static void main(String[] args) throws IOException, InvalidFormatException { // 获取文件流 InputStream inputStream = new FileInputStream("C:/Users/Mypc/Desktop/原系统数据/用户升级报表.xlsx"); // 获取Excell工作薄对象 XSSFWorkbook workbook = new XSSFWorkbook(inputStream); // 获取sheet页总数量 int numberOfSheets = workbook.getNumberOfSheets(); for (int i = 0; i < numberOfSheets; i++) { // 获取每一个sheet对象 XSSFSheet sheet = workbook.getSheetAt(i); for (Row row : sheet) { // 获取每一行对象 for (Cell cell : row) { // 获取每一个单元格对象 // 根据单元格对象获取值 String stringCellValue = cell.getStringCellValue(); System.out.println(stringCellValue); } } } } }

3.解析结果如下:

用户昵称用户手机用户现等级升级前等级升级后等级升级时间玉兰 ♪137*****592初级会员注册用户初级会员2018-04-28 10:49:13沿路观景131*****987初级会员注册用户初级会员

2018-04-28 09:41:37

........