c# - EPPlus:查找Excel中整行是否为空

Question

我在我的 .net 核心 web api 中使用 EPPlus 库。在上述方法中，我想验证他上传的 excel。我想知道我的整行是否为空。我有以下代码:

using (ExcelPackage package = new ExcelPackage(file.OpenReadStream()))
{
    ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
    int rowCount = worksheet.Dimension.End.Row;
    int colCount = worksheet.Dimension.End.Column;

    //loop through rows and columns
    for (int row = 1; row <= rowCount; row++)
    {
        for (int col = 1; col <= ColCount; col++)
        {
            var rowValue = worksheet.Cells[row, col].Value;
            //Want to find here if the entire row is empty
        }
    }
}

上面的 rowValue 会告诉我特定单元格是否为空。是否可以检查整行，如果为空则继续下一行。

Answer 1

您可以使用 linq 检查行单元格范围值:

var startRow = 1;
var endRow = 1;
var columnStart = 1;
var columnEnd = worksheet.Cells.End.Column;

var cellRange = worksheet.Cells[startRow, columnStart , endRow, columnEnd];

var isRowEmpty = cellRange.All(c => c.Value == null)