OLEDB，写入不带前导撇号的 Excel 单元格

使用OLEDB可以方便地将数据写入Excel单元格中，而且可以实现不带前导撇号的写入操作。本文将介绍如何使用OLEDB库实现这一功能，并提供一个案例代码供参考。

csharp
using System;
using System.Data;
using System.Data.OleDb;
namespace ExcelWriting
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=test.xlsx;Extended Properties='Excel 12.0;HDR=YES;IMEX=1;'";
            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                connection.Open();
                // 创建一个新的工作表
                using (OleDbCommand command = new OleDbCommand())
                {
                    command.Connection = connection;
                    command.CommandText = "CREATE TABLE [Sheet1] (ID INT, Name VARCHAR, Age INT)";
                    command.ExecuteNonQuery();
                }
                // 向工作表中写入数据
                using (OleDbCommand command = new OleDbCommand())
                {
                    command.Connection = connection;
                    command.CommandText = "INSERT INTO [Sheet1$] (ID, Name, Age) VALUES (1, 'John', 25)";
                    command.ExecuteNonQuery();
                }
            }
        }
    }
}