import datetime
date_today = datetime.date.today()
date_today = date_today.strftime('%Y%m%d')
dotname = os.path.splitext('D:/test/test.xlsx')[1]#尾缀格式,.xlsx
filename = os.path.basename('D:/test/test.xlsx')#剥离路径后的文件名,test.xlsx
filename = filename.split(".")[0]#剥离路径、尾缀的文件名,test
targetfile = D:/test/'+filename+'_'+date_today()+dotname
df = pd.DataFrame(pd.read_excel('D:/test/test.xlsx',‘Sheet1’))
#xxxx处理处理
df.to_excel(targetfile,sheet_name='Sheet1',index=False)
或
wb = load_workbook(targetfile)
ws = wb['Sheet1']
#xxxx处理处理
wb.save(targetfile)