2020-01-16

import pymysql
import xlwt
#连接数据库，并通过sql语句查询字段
db = pymysql.connect(host='10.1.3.24',user='erpdev',database='',password='zaq1@WSX',port=3306,charset='utf8')
cursor= db.cursor()
cursor.execute('select area_id,name from erptest.areas')

fields= [field[0] for field in cursor.description]    #获取所有字段名
all_data= cursor.fetchall()  #抓取所有数据

#写入excel
book = xlwt.Workbook()
sheet = book.add_sheet('sheet1')

for col,field in enumerate(fields):
    sheet.write(0,col,field)

row = 1
for data in all_data:
    for col,field in enumerate(data):
        sheet.write(row,col,field)
    row +=1
book.save('write1.xls')