C#读取excel，但仍从空白单元格获取数据

using Excel = Microsoft.Office.Interop.Excel;

public void ReadExcel(string filePath)
{
    Excel.Application excelApp = new Excel.Application();
    Excel.Workbook workbook = excelApp.Workbooks.Open(filePath);
    Excel.Worksheet worksheet = workbook.Sheets[1]; // 假设数据在第一个工作表中

    int rowCount = worksheet.UsedRange.Rows.Count;
    int colCount = worksheet.UsedRange.Columns.Count;

    for (int i = 1; i <= rowCount; i++)
    {
        for (int j = 1; j <= colCount; j++)
        {
            Excel.Range cell = worksheet.Cells[i, j];
            string value = cell.Value != null ? cell.Value.ToString() : "";
            Console.WriteLine("Cell({0}, {1}): {2}", i, j, value);
        }
    }

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

using OfficeOpenXml;

public void ReadExcel(string filePath)
{
    using (ExcelPackage package = new ExcelPackage(new FileInfo(filePath)))
    {
        ExcelWorksheet worksheet = package.Workbook.Worksheets[1]; // 假设数据在第一个工作表中

        int rowCount = worksheet.Dimension.Rows;
        int colCount = worksheet.Dimension.Columns;

        for (int i = 1; i <= rowCount; i++)
        {
            for (int j = 1; j <= colCount; j++)
            {
                string value = worksheet.Cells[i, j].Value != null ? worksheet.Cells[i, j].Value.ToString() : "";
                Console.WriteLine("Cell({0}, {1}): {2}", i, j, value);
            }
        }
    }
}