from sqlalchemy import create_engine
import pandas as pd
import os
from datetime import datetime, date, timedelta
yesterday = (date.today() + timedelta(days = -1)).strftime("%Y-%m-%d")
engine =create_engine('mysql+pymysql://',encoding='utf-8')
con = engine.connect()
#数据库查询前一天数据：sql="""select * from table1 where save_time>sysdate-1"""
sql = 'SELECT * '
df_read = pd.read_sql_query(sql, engine)
data = {'分工': ["小王", "小林", "小李", "66"],
}
df = pd.DataFrame(data)
df_read.insert(0,'分工',df)#加一列“分工”
path = f'd:\导出\{yesterday}工单.xlsx'
df_read.to_excel(path, index=False)
