python 读取 xlsx 最后保存者信息

python 读取 xlsx 文件最后保存者信息

import os,re
import logging
from openpyxl import load_workbook

logger = logging.getLogger('openpyxl')
logger.setLevel(logging.ERROR)

base = r'PATH_TO_CHECK'
base = os.path.join(os.path.dirname(__file__),base)
print(f'根目录：{base}')
for root,dirs,files in os.walk(base):
  for f in files:
    if re.match(r'^\.xlsx$',os.path.splitext(f)[1],flags=re.I):
      try:
        file = os.path.join(root,f)
        wb = load_workbook(filename=file)
        author = wb.properties.lastModifiedBy
        relpath = os.path.relpath(file,base)
        print(relpath,author,sep='\t')
      except Exception as e:
        print(f'Fail to check file {file}')