如何在c#中查找excel表格中每列的行数？

using Excel = Microsoft.Office.Interop.Excel;

public void FindRowCounts(string filePath)
{
    Excel.Application excelApp = new Excel.Application();
    Excel.Workbook workbook = excelApp.Workbooks.Open(filePath);
    Excel.Worksheet worksheet = workbook.ActiveSheet;

    int columnCount = worksheet.UsedRange.Columns.Count;

    for (int i = 1; i <= columnCount; i++)
    {
        Excel.Range columnRange = worksheet.Columns[i];
        int rowCount = columnRange.Cells.SpecialCells(Excel.XlCellType.xlCellTypeConstants).Count;
        Console.WriteLine("Column {0} has {1} rows.", i, rowCount);
    }

    workbook.Close();
    excelApp.Quit();
}