使用C#以编程方式获取最后填充的excel行

Install-Package EPPlus

using OfficeOpenXml;
using System;
using System.IO;

public class ExcelHelper
{
    public static int GetLastRow(string filePath, string sheetName)
    {
        using var package = new ExcelPackage(new FileInfo(filePath));
        var worksheet = package.Workbook.Worksheets[sheetName];
        return worksheet.Dimension.End.Row;
    }
}

var filePath = "path/to/your/excel/file.xlsx";
var sheetName = "Sheet1";
var lastRow = ExcelHelper.GetLastRow(filePath, sheetName);
Console.WriteLine($"The last row is: {lastRow}");