使用python实现数据库数据导出写入excel并邮件发送,代码如下:
#!/usr/bin/python3
#coding:utf-8
import pymysql
import NumberConRateSql
import xlwt
import datetime
import sys
import time
import os
import os.path
from email import encoders
from email.header import Header
from email.mime.text import MIMEText
from email.utils import parseaddr, formataddr
from email.mime.multipart import MIMEMultipart
from email.mime.application import MIMEApplication
import smtplib
import Config
#获取当前时间
now_time = datetime.datetime.now()
#获取昨天时间
yes_time = now_time + datetime.timedelta(days=-1)
#格式输出
yes_time_nyr = yes_time.strftime('%Y-%m-%d')
#curtime = time.strftime("%Y-%m-%d", time.localtime())
outpath = Config.OUTPATH
filename = yes_time_nyr + '.xls'
#定义导出excel函数
def export(table_name,outfile):
conndb = pymysql.connect(
host = Config.HOST,
port = Config.PORT,
user = Config.USER,
pas