首先创建此方法以获取单元格的值。

public static string GetCellValue(WorkbookPart workbookPart, Cell cell)
{
    string value = null;
    if (cell.InnerText.Length > 0)
    {
        value = cell.InnerText;

        // If the cell represents an integer number, you are done. 
        // For dates, this code returns the serialized value that 
        // represents the date. The code handles strings and 
        // Booleans individually. For shared strings, the code 
        // looks up the corresponding value in the shared string 
        // table. For Booleans, the code converts the value into 
        // the words TRUE or FALSE.
        if (cell.DataType != null)
        {
            switch (cell.DataType.Value)
            {
                case CellValues.SharedString:

                    // For shared strings, look up the value in the
                    // shared strings table.
                    var stringTable =
                        workbookPart.GetPartsOfType<SharedStringTablePart>()
                        .FirstOrDefault();

                    // If the shared string table is missing, something 
                    // is wrong. Return the index that is in
                    // the cell. Otherwise, look up the correct text in 
                    // the table.
                    if (stringTable != null)
                    {
                        value =
                            stringTable.SharedStringTable
                            .ElementAt(int.Parse(value)).InnerText;
                    }
                    break;

                case CellValues.Boolean:
                    value = value switch
                    {
                        "0" => "FALSE",
                        _ => "TRUE",
                    };
                    break;
            }
        }
    }
    return value;
}

然后在内部for循环中使用以下代码：

foreach (Cell c in r.Elements<Cell>())
{
    string str = GetCellValue(workbookPart, c);
    cols.add(str);
}

GetCellValue方法的灵感来源于Microsoft的this page文档