C#仅将表中的第一列文本添加到List<string>以进行断言

using System;
using System.Collections.Generic;
using System.IO;
using OfficeOpenXml;

public class Program
{
    public static void Main()
    {
        string filePath = "path/to/your/excel/file.xlsx";
        List<string> firstColumnData = new List<string>();

        using (var package = new ExcelPackage(new FileInfo(filePath)))
        {
            ExcelWorksheet worksheet = package.Workbook.Worksheets[0]; // 假设表格在第一个工作表中

            int rowCount = worksheet.Dimension.Rows;

            for (int row = 1; row <= rowCount; row++)
            {
                string cellValue = worksheet.Cells[row, 1].Value?.ToString(); // 获取第一列的单元格值

                if (!string.IsNullOrEmpty(cellValue))
                {
                    firstColumnData.Add(cellValue); // 将单元格值添加到List<string>中
                }
            }
        }

        // 对List<string>进行断言操作或其他处理
        foreach (string data in firstColumnData)
        {
            Console.WriteLine(data);
        }
    }
}