mysql->excel

最新推荐文章于 2023-09-02 12:58:22 发布

柳荫飞阳

最新推荐文章于 2023-09-02 12:58:22 发布

阅读量62

点赞数

本文链接：https://blog.csdn.net/u014625298/article/details/79518267

版权

#!/usr/bin/env python3
#coding=utf-8
import xlwt
import pymysql

#打开数据库连接
db = pymysql.connect("localhost","root","123","credit",charset = 'utf8')
cursor=db.cursor()
count=cursor.execute('select * from c_company_data')
print("总行数是：",count)
#重置游标位置
cursor.scroll(0,mode='absolute')
#搜取所有结果
results=cursor.fetchall()
#获取MySQL里的数据字段
fields=cursor.description
#print(fields)
#将字段导入到表的第一行
wbk=xlwt.Workbook(encoding='utf-8')
sheet=wbk.add_sheet('credit data',cell_overwrite_ok=True)
style = xlwt.XFStyle()
font = xlwt.Font()
font.name = 'SimSun' # 指定“宋体”
style.font = font
for ifs in range(0,len(fields)):
    sheet.write(0,ifs,fields[ifs][0])

for i in range(1,len(results)+1):
    for j in range(0,len(fields)):
        sheet.write(i,j,results[i-1][j],style)
wbk.save('C:/Users/PC-User/Desktop/credit.xls')
print('已导出credit.xls')