Python3 xlwings 替换xlsx文件中指定字符串

Python版本 3.6.8 xlwings插件需要安装
本机需要装有office软件
原文件：



将 类似于 DataCenter Edition 64bit Chinese Edition 这些的 替换为空

Python代码如下：

import time
import xlwings as xw
##Author XC 2022-08-23
app = xw.App(visible=False, add_book=False)
wb = app.books.open('C:/server_support/01_ECS/count/test.xlsx')
rows = wb.sheets['ECS'].used_range.last_cell.row
for cell in wb.sheets['ECS'].range('A1:M{}'.format(rows)):
  dic1 = {"chr1": "Data Center Edition 64bit Chinese Edition",
         "chr2": "with Container DataCenter Edition 64bit Chinese",
        "chr3": "Data Center Edition 64bit English Edition",
        "chr4": "DataCenter Edition 64bit Chinese Edition",
        "chr5": "with Container DataCenter Edition 64bit English Edition"
  }
  try:
    for intem in dic1.items():
      k, v = intem
     if dic1[k] in cell.value:
       cell.value = cell.value.replace(dic1[k],'')
 except:
    pass
## 设置自动列宽
wb.sheets['ECS'].range('A1:M{}'.format(rows)).columns.autofit()
# 保存文件
new_file = time.strftime("%Y-%m-%d-%H-%M-%S", time.localtime())
wb.save('C:/server_support/01_ECS/count/ecs_count-{}.xlsx'.format(new_file))
wb.close()
app.quit()


替换后的结果：