C# ExcelDataReader仅从特定列读取

using System;
using System.Data;
using System.IO;
using ExcelDataReader;

class Program
{
    static void Main(string[] args)
    {
        string filePath = "data.xlsx";
        using (var stream = File.Open(filePath, FileMode.Open, FileAccess.Read))
        {
            using (var reader = ExcelReaderFactory.CreateReader(stream))
            {
                while (reader.Read())
                {
                    // 读取第二列的数据（索引从 0 开始）
                    string secondColumnValue = reader.GetValue(1).ToString();
                    Console.WriteLine(secondColumnValue);
                }
            }
        }
    }
}

using (var reader = ExcelReaderFactory.CreateReader(stream, Encoding.UTF8))

using (var reader = ExcelReaderFactory.CreateReader(stream))
{
    while (reader.Read())
    {
        // 处理数据
    }
}

string secondColumnValue = reader.GetValue(1).ToString(); // 确保第二列存在