Python 数据库到处到Excel

 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');

 

posted @ 2014-10-18 10:34  王志超i  阅读(279)  评论(0编辑  收藏  举报