Python实现mysql中数据导成excel表格

1
# Create your views here.
2
# -*- coding: utf-8 -*-
3
import MySQLdb
4
import xlwt
5
from datetime import datetime
6

7
wbk=xlwt.Workbook(encoding='utf-8')
8
sheet=wbk.add_sheet('sheet 2')
9
sheet.write(0,0,'Uid')
10
sheet.write(0,1,u'姓名')
11
sheet.write(0,2,'password')
12
sheet.write(0,3,'Email')
13
sheet.write(0,4,'Date')
14
row=1
15
fmt='YYYY-MM-DD hh:mm:ss'
16
try:
17
    conn=MySQLdb.connect(host="localhost",user='root',passwd="",db="personalblog_db",charset='utf8')
18
    cur=conn.cursor()
19
    count=cur.execute('select * from users')
20
    print 'there has %s rows record' % count
21
    results=cur.fetchmany(count)
22
    for uid,uname,upassword,uemail,udate in results:
23
        sheet.write(row,0,uid)
24
        sheet.write(row,1,uname)
25
        sheet.write(row,2,upassword)
26
        sheet.write(row,3,uemail)
27
        style = xlwt.XFStyle()
28
        style.num_format_str = fmt
29
        sheet.write(row,4,udate,style)
30
        row+=1
31
    wbk.save('users1.xls')
32
    cur.close()
33
    conn.commit()
34
    conn.close()
35
except MySQLdb.Error,e:
36
    print "Mysql Error %d: %s"%(e.args[0],e.args[1])