导出mysql查询到Excel（xlsx）

#!/user/bin/env/ python
# -*-coding:utf-8-*-
import pymysql
import pandas as pd
import xlsxwriter


conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',passwd='songwq12',db='whzc2019',charset='utf8')
cursor = conn.cursor()

count = cursor.execute('select * from 公参;')
# 打印出总共条数
print(count)

# 重置游标位置,指定游标位置从最初开始
cursor.scroll(0,mode='absolute')
# 查询所有结果
results = cursor.fetchall()
# print(results)  遍历所有数据，在一个元组中
# for result in results:
    # print(result) 一条条遍历所有数据
    # print('id:%s' % result[0])
    # print('时间:%s' % result[1])
    # print('uid:%s' % result[2])
    # print('姓名:%s' % result[3])
    # print('所属地市:%s' % result[4])

# 获取mysql里面的数据字段名称
fields = cursor.description
workbook = xlsxwriter.Workbook('gc.xlsx')
sheet = workbook.add_worksheet('gc')

# 字段信息
for field in range(0,len(fields)):
    sheet.write(0,field,fields[field][0])
    # print(fields[field][0])   打印出mysql字段名称

# 获取并写入数据库字段信息
row = 1
col = 0
for row in range(1,len(results)+1):
    for col in range(0,len(fields)):
        sheet.write(row,col,'%s' % results[row-1][col])
workbook.close()
print('导出结束！总共导出：%d 条数据！' % count)
conn.close()