Python从数据库导出数据至Excel

基于Python3.6.4，导出Excel的文件后缀为.xls

#coding=utf-8
import pymysql
import xlwt
import importlib,sys
importlib.reload(sys)
#    __author__ = 'itechzero'
#    __date__ = '2018/02/26'
#    __Desc__ = 从数据库中导出数据到excel数据表中

def export(host,user,password,dbname,table_name,outputpath):
    conn = pymysql.connect(host,user,password,dbname,charset='utf8')
    cursor = conn.cursor()

    count = cursor.execute('select * from '+table_name)