python 数据库导出excle 分sheet

#!/usr/bin/python
# -*- coding: UTF-8 -*-
import sys
reload(sys)
sys.setdefaultencoding('utf8')
import xlwt
import MySQLdb
def export(host,user,password,dbname,table_name,outputpath):
    conn = MySQLdb.connect(host=host,port=3307,user=user,passwd=password,db=dbname,charset='utf8')
    cursor = conn.cursor()


    count = cursor.execute("select distinct SNAME from "+table_name+"")
    cursor.scroll(0,mode='absolute')
    resultsSNAME =cursor.fetchall()


    workbook = xlwt.Workbook()
    for sname in resultsSNAME:
        sql="select * from "+table_name+" where SNAME='%s' order by TIME desc" % (sname[0])
        print sql
        cursor.execute(sql)
        results = cursor.fetc