07python excel 一键式统计系统0.10几乎全量数据

import openpyxl
#
# # 加载 excel 文件

########################资产负债表
fn_fuzhaibiao = 'C:/Users/laiwu/Desktop/一键式统计/资产负债表.xlsx'
wb_fuzhaibiao = openpyxl.load_workbook(fn_fuzhaibiao)

ws_fuzhaibiao = wb_fuzhaibiao.get_sheet_by_name('资产负债表')
print("年初存货：")
print(ws_fuzhaibiao['D13'].value)

print("流动资产合计：")
print(ws_fuzhaibiao['C19'].value)


print("应收账款：")
print(ws_fuzhaibiao['C8'].value)

print("存货：")
print(ws_fuzhaibiao['C13'].value)


print("固定资产原价：")
print(ws_fuzhaibiao['C23'].value)



print("本年折旧：")
print(ws_fuzhaibiao['C24'].value)


print("资产总计：")
print(ws_fuzhaibiao['C35'].value)



print("负债合计：")
print(ws_fuzhaibiao['G26'].value)

########################利润表
fn_lirunbiao = 'C:/Users/laiwu/Desktop/一键式统计/利润表.xlsx'
wb_lirunbiao = openpyxl.load_workbook(fn_lirunbiao)

ws_lirunbiao = wb_lirunbiao.get_sheet_by_name('利润表')
print("营业收入：")
print(ws_lirunbiao['C4'].value)

print("营业成本：")
print(ws_lirunbiao['C5'].value)

print("税金及附加：")
print(ws_lirunbiao['C6'].value)

print("销售费用：")
print(ws_lirunbiao['C14'].value)

print("管理费用：")
print(ws_lirunbiao['C17'].value)

print("研发费用：")
print(ws_lirunbiao['C20'].value)

print("利息收入：")
print(ws_lirunbiao['C22'].value)

print("利息费用：")
print(ws_lirunbiao['C22'].value)

print("营业利润：")
print(ws_lirunbiao['C24'].value)

print("营业外收入：")
print(ws_lirunbiao['C25'].value)

print("营业外支出：")
print(ws_lirunbiao['C27'].value)

print("利润总额：")
print(ws_lirunbiao['C33'].value)

print("所得税费用：")
print(ws_lirunbiao['C34'].value)

########################财务状况表
fn_caiwuzhuangkuang = 'C:/Users/laiwu/Desktop/一键式统计/财务状况.xlsx'
wb_caiwuzhuangkuang = openpyxl.load_workbook(fn_caiwuzhuangkuang)

ws_caiwuzhuangkuang = wb_caiwuzhuangkuang.get_sheet_by_name('Sheet')


ws_caiwuzhuangkuang['AA18'] = ws_fuzhaibiao['D13'].value
ws_caiwuzhuangkuang['AA20'] = ws_fuzhaibiao['C19'].value
ws_caiwuzhuangkuang['AA21'] = ws_fuzhaibiao['C8'].value
ws_caiwuzhuangkuang['AA22'] = ws_fuzhaibiao['C13'].value
ws_caiwuzhuangkuang['AA23'] = ws_fuzhaibiao['C23'].value
ws_caiwuzhuangkuang['AA25'] = ws_fuzhaibiao['C24'].value
ws_caiwuzhuangkuang['AA26'] = ws_fuzhaibiao['C35'].value
ws_caiwuzhuangkuang['AA27'] = ws_fuzhaibiao['G26'].value

ws_caiwuzhuangkuang['AA29'] = ws_lirunbiao['C4'].value
ws_caiwuzhuangkuang['AA30'] = ws_lirunbiao['C5'].value
ws_caiwuzhuangkuang['AA21'] = ws_lirunbiao['C6'].value
ws_caiwuzhuangkuang['AA32'] = ws_lirunbiao['C14'].value
ws_caiwuzhuangkuang['AA33'] = ws_lirunbiao['C17'].value
ws_caiwuzhuangkuang['AA34'] = ws_lirunbiao['C20'].value
ws_caiwuzhuangkuang['AA36'] = ws_lirunbiao['C22'].value
ws_caiwuzhuangkuang['AA37'] = ws_lirunbiao['C22'].value
ws_caiwuzhuangkuang['AA38'] = ws_lirunbiao['C24'].value
ws_caiwuzhuangkuang['AA39'] = ws_lirunbiao['C25'].value
ws_caiwuzhuangkuang['AA40'] = ws_lirunbiao['C27'].value
ws_caiwuzhuangkuang['AA41'] = ws_lirunbiao['C33'].value
ws_caiwuzhuangkuang['AA42'] = ws_lirunbiao['C34'].value


print("年初存货：")
print(ws_caiwuzhuangkuang['AA18'].value)


print("流动资产合计：")
print(ws_caiwuzhuangkuang['AA20'].value)


print("应收账款：")
print(ws_caiwuzhuangkuang['AA21'].value)

print("存货：")
print(ws_caiwuzhuangkuang['AA22'].value)


print("固定资产原价：")
print(ws_caiwuzhuangkuang['AA23'].value)



print("本年折旧：")
print(ws_caiwuzhuangkuang['AA25'].value)


print("资产总计：")
print(ws_caiwuzhuangkuang['AA26'].value)



print("负债合计：")
print(ws_caiwuzhuangkuang['AA27'].value)


print("营业收入：")
print(ws_lirunbiao['C4'].value)

print("营业成本：")
print(ws_lirunbiao['C5'].value)

print("税金及附加：")
print(ws_lirunbiao['C6'].value)

print("销售费用：")
print(ws_lirunbiao['C14'].value)

print("管理费用：")
print(ws_lirunbiao['C17'].value)

print("研发费用：")
print(ws_lirunbiao['C20'].value)

print("利息收入：")
print(ws_lirunbiao['C22'].value)

print("利息费用：")
print(ws_lirunbiao['C22'].value)

print("营业利润：")
print(ws_lirunbiao['C24'].value)

print("营业外收入：")
print(ws_lirunbiao['C25'].value)

print("营业外支出：")
print(ws_lirunbiao['C27'].value)

print("利润总额：")
print(ws_lirunbiao['C33'].value)

print("所得税费用：")
print(ws_lirunbiao['C34'].value)








wb_caiwuzhuangkuang.save('c:/Users/laiwu/Desktop/一键式统计/财务状况.xlsx')