使用oledb从Excel读取合并的单元格

using System;
using System.Data.OleDb;

namespace ExcelReader
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\path\\to\\excel.xlsx;Extended Properties='Excel 12.0;HDR=YES;IMEX=1;'";

            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                connection.Open();

                OleDbCommand command = new OleDbCommand("SELECT * FROM [Sheet1$]", connection);

                using (OleDbDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        string cellValue = reader.GetString(0); // 读取第一列的值
                        Console.WriteLine(cellValue);
                    }
                }
            }
        }
    }
}