06python excel 一键式统计系统0.02_批量写入多组数据_是否可以批量抓取应收账款并做统计工作-优快云博客

本文介绍了一个使用Python的openpyxl库从一个包含资产负债表的Excel文件中读取特定单元格的数据，并将这些数据写入另一个Excel文件的指定位置的简单脚本。此脚本有助于实现财务数据的自动化处理。

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_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



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)












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