python读取数据库后保存为表格

记录一个做过的问题，python从数据库读取数据后，数据类型是实例不太好操作，可以转换为DataFram格式然后操作，一个小问题，直接上代码。

import pymysql
import pandas as pd

conn = pymysql.connect(
    host='*',
    user='*',
    password='*',
    db='*',
    charset='utf8',
       
)

cur = conn.cursor()
sqli = "select ** from *** limit 10;"
ad = pd.read_sql_query(sqli,conn)

writer = pd.ExcelWriter("*.xlsx", encoding="utf-8-sig")
ad.to_excel(writer, "sheet1")
writer.save()



cur.close()

conn.close()