from datetime import *
from openpyxl import load_workbook
import window
# t = datetime.strptime(str(window.day()),'%Y-%m-%d')
t = datetime.strptime(input('开始时间:'),'%Y-%m-%d')
# 读取工作日志文件
f = open('C:\\Users\\Administrator\\Desktop\\工作日志.docx','w')
# 获取每日报表内容
d = t.day
m = t.month
s = str(t.year)+'-'+str(t.month)+'-'+str(t.day)
file_path = "D:\周继彪\法国兰斐\报表数据统计\每日报表\\2021法国兰斐综合报表(勿动).xlsx"
wb = load_workbook(file_path,data_only=True)
sheets = wb.worksheets
sheet1 = sheets[m*2-2]
sheet2 = sheets[m*2-1]
# 获取对应单元格的值
def work_cell():
cell1 = sheet1.cell((d + 1)*12+1,4).value
cell2 = sheet1.cell((d + 2)*12+1,3).value
cell3 = sheet1.cell((d + 2) * 12 + 1, 16).value
cell4 = sheet1.cell((d + 2) * 12 + 1, 17).value
cell5 = sheet1.cell((d + 1) * 12 + 4, 16).value
cell6 = sheet1.cell((d + 1) * 12 + 4, 17).value
cell7 = sheet1.cell((d + 1) * 12 + 10, 16).value
cell8 = sheet1.cell((d + 1) * 12 + 10, 17).value
cell9 = sheet1.cell((d + 1) * 12 + 11, 16).value
cell10 = sheet1.cell((d + 1) * 12 + 11, 17).value
cell11 = sheet1.cell((d + 1) * 12 + 7, 16).value
cell12 = sheet1.cell((d + 1) * 12 + 7, 17).value
cell13 = sheet1.cell((d + 1) * 12 + 9, 16).value
cell14 = sheet1.cell((d + 1) * 12 + 9, 17).value
cell15 = sheet1.cell((d + 2) * 12, 16).value
cell16 = sheet1.cell((d + 2) * 12, 17).value
cell17 = sheet2.cell((d + 2) * 11 + 1, 3).value
cell18 = sheet2.cell((d + 2) * 11 + 1, 4).value
cell19 = sheet1.cell((d + 1) * 12 + 1, 20).value
cell20 = sheet1.cell((d + 1) * 12 + 1, 18).value
cell21 = sheet1.cell((d + 2) * 12 + 1, 7).value
cell22 = sheet2.cell((d + 2) * 11 + 1, 13).value
cell23 = sheet1.cell((d + 2) * 12 + 1, 19).value
cell24 = sheet1.cell(25,5).value
cell25 = sheet1.cell(25,16).value
cell26 = sheet1.cell(25,17).value
cell27 = sheet2.cell(23,3).value
cell28 = sheet2.cell(23,4).value
cell29 = sheet1.cell(25,20).value
cell30 = sheet1.cell(25,21).value
cell31 = sheet1.cell(25,22).value
cell32 = sheet1.cell(25,7).value
cell33 = sheet2.cell(23,13).value
# return cell1,cell2,cell3,cell4,cell5,cell6,cell7,cell8,cell9,cell10,cell11,cell12,cell13,cell14,cell15,cell16,cell17,\
# cell18,cell19,cell20,cell21,cell22,cell23,cell24,cell25,cell26,cell27,cell28,cell29,cell30,cell31,cell32,cell33
def work():
print(s,'工作总结:',file=f)
print('1.昨日花费:',work_cell.cell1,file=f)
print('2.今日账户总余额:',work_cell.cell2,file=f)
print('3.今日投放毛客资:',work_cell.cell3,file=f)
print('4.今日投放有效客资:',work_cell.cell4,file=f)
print('5.今日微信毛客资:',work_cell.cell5,file=f)
print('6.今日微信有效客资:',work_cell.cell6,file=f)
print('7.今日美团毛客资:',work_cell.cell7,file=f)
print('8.今日美团有效客资:',work_cell.cell8,file=f)
print('9.今日美团优美毛客资:',work_cell.cell9,file=f)
print('10.今日美团优美有效客资:',work_cell.cell10,file=f)
print('11.今日抖音自营毛客资:',work_cell.cell11,file=f)
print('12.今日抖音自营有效客资:',work_cell.cell12,file=f)
print('13.今日抖音蓝V毛客资:',work_cell.cell13,file=f)
print('14.今日抖音蓝V有效客资:',work_cell.cell14,file=f)
print('15.今日哪拍毛客资:',work_cell.cell15,file=f)
print('16.今日哪拍有效客资:',work_cell.cell16,file=f)
print('17.今日免费渠道毛客资:',work_cell.cell17,file=f)
print('18.今日免费渠道有效客资:',work_cell.cell18,file=f)
print('19.昨日毛客资均价:','%.2f' % work_cell.cell19,file=f)
print('20.昨日订单成本:',work_cell.cell20,file=f)
print('21.今日投放渠道订单量:',work_cell.cell21,file=f)
print('22.今日免费渠道订单量',work_cell.cell22,file=f)
print('23.昨日投入产出比:',work_cell.cell23,file=f)
print('24.月累计花费:',work_cell.cell24,file=f)
print('25.月累计投放毛客资:',work_cell.cell25,file=f)
print('26.月累计投放有效客资:',work_cell.cell26,file=f)
print('27.月累计免费毛客资:',work_cell.cell27,file=f)
print('28.月累计免费有效客资:',work_cell.cell28,file=f)
print('29.月累计毛客资均价:','%.2f' % work_cell.cell29,file=f)
print('30.月累计有效毛客资均价:','%.2f' % work_cell.cell30,file=f)
print('31.月累计有效客资均价:','%.2f' % work_cell.cell31,file=f)
print('32.月累计投放渠道订单:',work_cell.cell32,file=f)
print('33.月累计免费渠道订单:',work_cell.cell33,file=f)
print('34.日工作总结:',file=f)
print('a、整理客资系统,',file=f)
print('b、整理数据,',file=f)
print('c、优化抖音蓝V、自营广告',file=f)
print('d、发布小红书笔记',file=f)
print('e、美团客资整理',file=f)
print('f、查看小红书投放',file=f)
# 输出工作日志内容
def main():
work()
work_cell()
if __name__ == '__main__':
main()
retun 啊,按下标取
def aa():
a = 1
b = 2
c = 3
return a, b, c
a = aa()
print(a[1])