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')
网友评论