-
文件路径及工作簿:
-
每张表格式相同,如下图所示:
-
Python 处理如下:
import os
import xlwings as xw
import pandas as pd
app = xw.App(visible=False,add_book=False)
file_path = r'D:\python_file\销售表'
file_list = os.listdir(file_path)
for i in file_list:
if os.path.splitext(i)[1] == '.xlsx':
workbook = app.books.open(file_path+'\\'+i)
worksheet = workbook.sheets['销售记录表'] # 指定要分类汇总的工作表
values = worksheet.range('a1').expand('table').options(pd.DataFrame).value
values['销售利润'] = values['销售利润'].astype('float')
result = values.groupby('销售区域').sum()
worksheet.range('o1').value = result['销售利润']
workbook.save()
workbook.close()
app.quit()
- 结果