Use pandas to write the results of MySQL query to an Excel file

#!/usr/bin/env Python3

Import Pandas as PD

Import Pymysql

#返回SQL结果的函数

def Getrel (SQL):

conn = pymysql.connect (host= ' localhost ', user= ' root ', password= ' 123456 ', db= ' test ')

cur = conn.cursor ()

Cur.execute (' Set names UTF8 ')

Cur.execute (' Select App,name from TB ') # Enter the SQL to query

Rel= Cur.fetchall ()

cur . Close ()

conn.close ()  

return rel

#生成xlsx文件的函数

def Get xlsx (REL,DT):

dret = PD. Dataframe.from_records (List (rel)) # MySQL query results are tuples and need to be converted to lists

dret.to_excel ("filename.xlsx",Index=false,header= ("app", "name")#header Specify the column name, Index default is true, write line name

# # XLSX file by default using Xlsxwriter, can be specified by engine= "Xlsxwriter"

Use pandas to write the results of MySQL query to an Excel file