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