把各个学校单独的月成本表汇总到一张表上
import os
import openpyxl
import pandas as pd
from pathlib import Path
workbook_to = openpyxl.load_workbook(r'G:\所有学校月成本汇总表.xlsx')
sheet_to = workbook_to.active
path = r'G:\月成本汇总表'
file_list = os.listdir(path)
for file in file_list:
print('*'*10, file, '*'*10)
workbook_from = openpyxl.load_workbook(os.path.join(path, file))
sheet_from = workbook_from.active
for i in range(2, 34):
if sheet_from.cell(row=i, column=1).value != None:
for j in range(2, 34):
if sheet_from.cell(row=i, column=1).value == sheet_to.cell(row=j, column=1).value:
row_to = j
for k in range(2, 17):
sheet_to.cell(row=row_to, column=k).value = float(sheet_to.cell(row=row_to, column=k).value) + float(sheet_from.cell(row=i, column=k).value)
sheet_to.cell(row=row_to, column=19).value = float(sheet_to.cell(row=row_to, column=19).value) + float(sheet_from.cell(row=i, column=19).value)
workbook_from.save(os.path.join(path, file))
workbook_to.save(r'G:\所有学校月成本汇总表.xlsx')
print('全部合并完成!')