将数据从Excel获取到DataTable时跳过空行

using OfficeOpenXml;
using System;
using System.Data;
using System.IO;

public class ExcelHelper
{
    public static DataTable GetDataTableFromExcel(string filePath)
    {
        DataTable dataTable = new DataTable();
        using (var stream = new FileStream(filePath, FileMode.Open, FileAccess.Read))
        {
            using (var package = new ExcelPackage(stream))
            {
                var worksheet = package.Workbook.Worksheets[0];
                int rowCount = worksheet.Dimension.End.Row;
                int colCount = worksheet.Dimension.End.Column;

                // 添加列
                for (int col = 1; col <= colCount; col++)
                {
                    dataTable.Columns.Add(worksheet.Cells[1, col].Value.ToString());
                }

                // 添加行并跳过空行
                for (int row = 2; row <= rowCount; row++)
                {
                    bool isEmptyRow = true;
                    for (int col = 1; col <= colCount; col++)
                    {
                        if (worksheet.Cells[row, col].Value != null)
                        {
                            isEmptyRow = false;
                            break;
                        }
                    }
                    if (!isEmptyRow)
                    {
                        DataRow dataRow = dataTable.NewRow();
                        for (int col = 1; col <= colCount; col++)
                        {
                            dataRow[col - 1] = worksheet.Cells[row, col].Value;
                        }
                        dataTable.Rows.Add(dataRow);
                    }
                }
            }
        }
        return dataTable;
    }
}