c# 获取excel列表长度

可以使用以下代码来获取Excel列表的长度：

using Excel = Microsoft.Office.Interop.Excel;

Excel.Application excelApp = new Excel.Application();
Excel.Workbook workbook = excelApp.Workbooks.Open("your_excel_file_path");
Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets[1];

int lastRow = worksheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Row;
int lastColumn = worksheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Column;

// The length of the Excel list is the number of rows in the worksheet
int listLength = lastRow;

// Close the Excel application
excelApp.Quit();

请注意，在使用上述代码之前，需要先安装 Microsoft Office Interop Excel 组件。