python初学者,这里想调用work_cell中的cell1,怎么调用

 

 

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])