使用Apache 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>

File file = new File("path/to/excel.xlsx");

Workbook workbook = WorkbookFactory.create(file);

Sheet sheet = workbook.getSheetAt(0); // 通过索引获取第一个工作表
// 或者
Sheet sheet = workbook.getSheet("Sheet1"); // 通过名称获取工作表

int rowCount = sheet.getLastRowNum() + 1;

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

import java.io.File;
import java.io.IOException;

public class ExcelReader {
    public static void main(String[] args) {
        File file = new File("path/to/excel.xlsx");

        try {
            Workbook workbook = WorkbookFactory.create(file);
            Sheet sheet = workbook.getSheetAt(0);
            int rowCount = sheet.getLastRowNum() + 1;
            System.out.println("Total rows: " + rowCount);

            workbook.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}