怎么将mysql数据库导出到excel

import pandas as pd
from sqlalchemy import create_engine

# 创建数据库连接
engine = create_engine('mysql+pymysql://username:password@host/database_name')

# 读取数据
df = pd.read_sql_table('table_name', engine)

# 导出到Excel
df.to_excel('output.xlsx', index=False)

Sub ExportToExcel()
    Dim conn As Object
    Dim rs As Object
    Dim sql As String
    Dim i As Integer

    Set conn = CreateObject("ADODB.Connection")
    Set rs = CreateObject("ADODB.Recordset")

    ' 设置连接字符串
    conn.Open "Driver={MySQL ODBC 8.0 Driver};Server=your_server;Database=your_database;Uid=your_username;Pwd=your_password;"

    ' 执行SQL查询
    sql = "SELECT * FROM your_table"
    rs.Open sql, conn

    ' 将结果写入Excel
    For i = 0 To rs.Fields.Count - 1
        Sheet1.Cells(1, i + 1).Value = rs.Fields(i).Name
    Next i
    Sheet1.Range("A2").CopyFromRecordset rs

    rs.Close
    conn.Close
End Sub