pip install xlwings

import xlwings as xw

# 輸入表名
title = input()

# 指定不顯示地打開(kāi)Excel，讀取Excel文件
app = xw.App(visible=False, add_book=False)
wb = app.books.open(title) # 打開(kāi)Excel文件
sheet = wb.sheets[0] # 選擇第0個(gè)表單

# 獲取表行數(shù)
sheetInfo = sheet.used_range
maxRow = sheetInfo.last_cell.row
# maxColumn = sheetInfo.last_cell.column
# print('表行數(shù):',maxRow)

# 單據(jù)編號(hào)
num = []
# 報(bào)銷類型
baoxiaoType = []
# 部門(mén)
department = []
# 收款方
name = []
# 報(bào)銷金額
money = []

# 將需要的數(shù)據(jù)讀取保存
for row in range(2, maxRow):
  value = sheet.range("A" + str(row)).value
  num.append(value)

  value = sheet.range("C" + str(row)).value
  baoxiaoType.append(value)

  value = sheet.range("H" + str(row)).value
  department.append(value)

  value = sheet.range("N" + str(row)).value
  name.append(value)

  value = sheet.range("K" + str(row)).value
  money.append(value)

# print(num)
# print(baoxiaoType)
# print(department)
# print(name)
# print(money)

# 保存標(biāo)記為重復(fù)的行號(hào)
flag = []
# 判斷是否已經(jīng)標(biāo)記為重復(fù)
# 重復(fù)返回Ture
# 否則返回False
def isRepeat(index):
  for num in flag:
    if num == index:
      return True
    else:
      continue
  return False


# 遍歷每一行，進(jìn)行查重
for row in range(0, len(money)):
  # 判斷是否已經(jīng)標(biāo)記為重復(fù)
  # 如果重復(fù)不做判斷，結(jié)束本次循環(huán)
  # 否則斷續(xù)向下執(zhí)行
  if True == isRepeat(row + 2):
    continue
  elif False == isRepeat(row + 2):
    # 獲取當(dāng)前行數(shù)據(jù)
    current = money[row]
    # 遍歷后面行是否和當(dāng)前行數(shù)據(jù)重復(fù)
    for subRow in range(1, len(money)):
      # 獲取下一行數(shù)據(jù)
      subCur = money[subRow]
      # 判斷當(dāng)前行內(nèi)容和對(duì)比行內(nèi)容是否相等
      if current == subCur:
        # 再判斷編號(hào)行內(nèi)容是否相等
        if num[row] == num[subRow]:
          continue
        else:
          # 對(duì)比其它內(nèi)容是否相等
          if (
            (department[row] == department[subRow])
            and (baoxiaoType[row] == baoxiaoType[subRow])
            and (name[row] == name[subRow])
          ):
            # 將重復(fù)行行號(hào)保存，表格的表頭，且表頭行號(hào)從1 開(kāi)始，所以行號(hào)等于當(dāng)前索引+2
            flag.append(subRow + 2)
            # 設(shè)置兩個(gè)重復(fù)行的首列單元格顏色
            cell = sheet.range("A" + str(row + 2))
            cell.color = 0, 255, 255
            subcell = sheet.range("A" + str(subRow + 2))
            subcell.color = 0, 255, 255
            # 打印提示
            print("重復(fù)起始行：", row + 2, "重復(fù)行", subRow + 2)

# 保存當(dāng)前工作簿
wb.save()
# 關(guān)閉當(dāng)前工作簿
wb.close()
# 退出excel程序
app.quit()
# 阻塞不退出
input("Press Any Key")

pip install pyinstaller

# -F 打包為單文件
# -i 指定圖標(biāo)
pyinstaller -F *.py -i *.ico