如何使用EPPlus读取带有空单元格的excel文件

using OfficeOpenXml;

using (ExcelPackage package = new ExcelPackage(new FileInfo("path/to/excel/file.xlsx")))
{
    // 在这里进行Excel文件的读取操作
}

ExcelWorksheet worksheet = package.Workbook.Worksheets[1]; // 获取第一个工作表

int rowCount = worksheet.Dimension.Rows; // 获取行数
int colCount = worksheet.Dimension.Columns; // 获取列数

for (int row = 1; row <= rowCount; row++)
{
    for (int col = 1; col <= colCount; col++)
    {
        ExcelRangeBase cell = worksheet.Cells[row, col]; // 获取单元格

        if (cell.Value != null) // 判断单元格是否为空
        {
            string cellValue = cell.Value.ToString(); // 获取单元格的值
            Console.WriteLine("单元格({0},{1})的值为：{2}", row, col, cellValue);
        }
        else
        {
            Console.WriteLine("单元格({0},{1})为空", row, col);
        }
    }
}