基于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)