Java 读取excel

<dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>4.1.0</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>4.1.0</version> </dependency>
二.读取excel

1.遍历行列package com.miracle; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import java.io.File; import java.io.FileInputStream; import java.io.IOException; public class ExcelTest { public static void main(String[] args) throws IOException { File xlsFile = new File("/home/miracle/Desktop/workspace_java/testmaven/src/test/java/com/miracle/his.xlsx"); /** * 这里根据不同的excel类型 * 可以选取不同的处理类： * 1.XSSFWorkbook * 2.HSSFWorkbook */ // 获得工作簿 XSSFWorkbook workbook = new XSSFWorkbook(new FileInputStream(xlsFile)); // 获得工作表 XSSFSheet sheet = workbook.getSheetAt(0); int rows = sheet.getPhysicalNumberOfRows(); for (int i = 0; i < rows; i++) { // 获取第i行数据 XSSFRow sheetRow = sheet.getRow(i); // 获取第0格数据 XSSFCell cell = sheetRow.getCell(0); // 调用toString方法获取内容 System.out.println(cell); } } }