GIS PY S3E10 Excel和word操作

import os
from openpyxl import load_workbook
from tqdm import tqdm

# 指定文件夹路径
folder_path = r"E:\项目资料\2022\监测\慈城新城酒店地块(CC09-03-01b)建设项目基坑监测\报表"

dicCX = {'CX1': 0, 'CX2': 0, 'CX3': 0, 'CX4': 0, 'CX5': 0,
         'CX6': 0, 'CX7': 0, 'CX8': 0, 'CX9': 0, 'CX10': 0,
         'CX11': 0, 'CX12': 0, 'CX13': 0, 'CX14': 0, 'CX15': 0
        }

print(dicCX)

for cxn in dicCX:
    for file in os.listdir(folder_path):
        if file.endswith(".xlsx"):
            report = os.path.join(folder_path, file)
            wb = load_workbook(report)
            if cxn in wb.sheetnames and wb[cxn].sheet_state != 'hidden':
                dicCX[cxn] += 1
                
            wb.close()

    print(cxn, dicCX[cxn])

老师帮我看看这个代码优化，147个excel，运行比较慢