Python实现Excel的分类汇总

import xlwings as xw
import pandas as pd
app = xw.App(visible=False, add_book=False)
workbook = app.books.open('销售表.xlsx')
worksheet = workbook.sheets['总表']
data = worksheet.range('A1').expand('table').options(pd.DataFrame, dtype=float).value
result = data.groupby('产品名称').sum()
worksheet1 = workbook.sheets.add(name='分类汇总')
worksheet1.range('A1').value = result[['销售数量', '销售金额']]
workbook.save('分类汇总表.xlsx')
workbook.close()
app.quit()