Python 数据库到处到Excel

最新推荐文章于 2024-07-30 21:09:58 发布

weixin_34228617

最新推荐文章于 2024-07-30 21:09:58 发布

阅读量69

点赞数

文章标签： python 数据库

原文链接：https://my.oschina.net/u/2254175/blog/369531

版权

2019独角兽企业重金招聘Python工程师标准>>>

 1 import MySQLdb
 2 import xlwt
 3 def outMySQL(file_name):
 4     wb = xlwt.Workbook()
 5     sh = wb.add_sheet('sheet 1',cell_overwrite_ok=True)
 6 
 7     db = MySQLdb.connect("localhost","root","123","STUDENTS",use_unicode=1,charset='utf8')
 8     cursor = db.cursor()
 9 
10     sql = '''SELECT * FROM STUDENTS '''
11 
12     cursor.execute(sql)
13     data = cursor.fetchall()
14     value = cursor.description
15     rows = len(data)
16     cols = len(map(list,zip(*data)))
17     for v in range(0,len(value)):
18         sh.write(0,v,value[v][0])
19     for i in range(1,rows+1):
20         for j in range(0,cols):
21             sh.write(i,j,data[i-1][j])
22     wb.save(file_name)
23     cursor.close()
24     db.commit()
25     db.close()
26 if __name__=="__main__":
27     outMySQL('/home/wangzhch/excel.xls');