如何使用C#传递SQL表并将其格式化为excel？

using System;
using System.Data.SqlClient;
using Microsoft.Office.Interop.Excel;

namespace SQLToExcel
{
    class Program
    {
        static void Main(string[] args)
        {
            // 连接字符串
            string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True";

            // SQL查询语句
            string query = "SELECT * FROM YourTableName";

            // 创建连接对象
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                // 打开连接
                connection.Open();

                // 创建命令对象
                using (SqlCommand command = new SqlCommand(query, connection))
                {
                    // 执行查询
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        // 创建Excel应用程序对象
                        Application excelApp = new Application();

                        // 创建新的工作簿
                        Workbook workbook = excelApp.Workbooks.Add();

                        // 获取第一个工作表
                        Worksheet worksheet = workbook.ActiveSheet;

                        // 写入列标题
                        for (int i = 0; i < reader.FieldCount; i++)
                        {
                            worksheet.Cells[1, i + 1] = reader.GetName(i);
                        }

                        // 写入数据
                        int row = 2;
                        while (reader.Read())
                        {
                            for (int i = 0; i < reader.FieldCount; i++)
                            {
                                worksheet.Cells[row, i + 1] = reader[i];
                            }
                            row++;
                        }

                        // 格式化工作表（可根据需要进行设置）

                        // 保存工作簿
                        workbook.SaveAs("YourFilePath.xlsx");

                        // 关闭Excel应用程序
                        excelApp.Quit();
                    }
                }
            }
        }
    }
}