.net数据库导出excel

using OfficeOpenXml;
using System.IO;
using System.Data.SqlClient;

public void ExportToExcel(string connectionString, string tableName, string filePath)
{
    // 连接数据库
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();

        // 查询数据
        string query = $"SELECT * FROM {tableName}";
        using (SqlCommand command = new SqlCommand(query, connection))
        {
            using (SqlDataReader reader = command.ExecuteReader())
            {
                // 创建 Excel 文件
                FileInfo fileInfo = new FileInfo(filePath);
                using (ExcelPackage package = new ExcelPackage(fileInfo))
                {
                    ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet1");

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

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

                    // 保存文件
                    package.Save();
                }
            }
        }
    }
}