数据:
代码:
import xlwings as xw
try:
app = xw.App(visible=False, add_book=False)
app2 = xw.App(visible=False, add_book=True)
wb = app.books.open(r'F:\python_抖音课程\01python办公自动化课件\素材\Excel\各区销售情况表.xlsx') # 打开原始数据表
sht = wb.sheets[0] #获取第一个sheet
wb2 = app2.books.add() # 新建工作簿
#获取源工作表最大单元格
cell = sht.used_range.last_cell
max_col = cell.column
max_rows = cell.row
#取得全部原始数据
data_list = sht.range((2,1),(max_rows,max_col)).value
#获取循环的列表,进行去重
chengqu_list = sht.range((2,2),(max_rows,2)).value
chengqu_list = list(dict.fromkeys(chengqu_list))
#循环列表处理数据
for chengqu in chengqu_list:
# 如