使用for循环使用Apache POI读取Excel工作表

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

public class ExcelReader {
    public static void main(String[] args) {
        String filePath = "path/to/excel/file.xlsx";
        
        try (Workbook workbook = WorkbookFactory.create(new File(filePath))) {
            Sheet sheet = workbook.getSheetAt(0); // 获取第一个工作表
            
            int lastRowNum = sheet.getLastRowNum();
            for (int i = 0; i <= lastRowNum; i++) {
                Row row = sheet.getRow(i);
                if (row != null) {
                    int lastCellNum = row.getLastCellNum();
                    for (int j = 0; j < lastCellNum; j++) {
                        Cell cell = row.getCell(j);
                        if (cell != null) {
                            CellType cellType = cell.getCellType();
                            if (cellType == CellType.STRING) {
                                String cellValue = cell.getStringCellValue();
                                // 处理字符串类型的单元格值
                            } else if (cellType == CellType.NUMERIC) {
                                double cellValue = cell.getNumericCellValue();
                                // 处理数值类型的单元格值
                            } else if (cellType == CellType.BOOLEAN) {
                                boolean cellValue = cell.getBooleanCellValue();
                                // 处理布尔类型的单元格值
                            } else if (cellType == CellType.BLANK) {
                                // 处理空单元格
                            }
                        }
                    }
                }
            }
        } catch (IOException | InvalidFormatException e) {
            e.printStackTrace();
        }
    }
}