Java 读取 Excel 最简单 POI 示例

  org.apache.poi
  poi-ooxml
  5.2.4

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.io.IOException;

public class ExcelReader {
  public static void main(String[] args) throws IOException {
    try (FileInputStream fis = new FileInputStream("test.xlsx");
        Workbook workbook = new XSSFWorkbook(fis)) {

      Sheet sheet = workbook.getSheetAt(0); // 第一个 sheet

      // 读第 0 行（标题）
      Row headerRow = sheet.getRow(0);
      if (headerRow != null) {
        System.out.print("标题：");
        for (int i = 0; i < headerRow.getLastCellNum(); i++) {
          Cell cell = headerRow.getCell(i);
          System.out.print(getCellValue(cell) + "\t");
        }
        System.out.println();
      }

      // 读第 1 行（示例数据）
      Row dataRow = sheet.getRow(1);
      if (dataRow != null) {
        System.out.print("数据：");
        for (int i = 0; i < dataRow.getLastCellNum(); i++) {
          Cell cell = dataRow.getCell(i);
          System.out.print(getCellValue(cell) + "\t");
        }
        System.out.println();
      }
    }
  }

  private static String getCellValue(Cell cell) {
    if (cell == null) return "";
    switch (cell.getCellType()) {
      case STRING: return cell.getStringCellValue();
      case NUMERIC:
        if (DateUtil.isCellDateFormatted(cell)) {
          return cell.getDateCellValue().toString();
        } else {
          return String.valueOf(cell.getNumericCellValue());
        }
      case BOOLEAN: return String.valueOf(cell.getBooleanCellValue());
      default: return "";
    }
  }
}

DataFormatter formatter = new DataFormatter();
String value = formatter.formatCellValue(cell); // 自动按 Excel 显示样式转字符串