看看 AI 的优化:

    # 定义支持的格式和对应的读取方法
    readers = [
        (pd.read_excel, {"engine": "openpyxl"}),  # xlsx
        (pd.read_excel, {"engine": "xlrd"}),      # xls
        (pd.read_csv, {"sep": "\t", "encoding": "gbk"})  # 银河数据csv
    ]
    
    file_path = os.path.join(path, filename)
    for reader, kwargs in readers:
        try:
            return reader(file_path, **kwargs)
        except Exception as e:
            print(f"尝试使用 {reader.__name__} 读取失败: {e}")
            continue
    print(f"无法读取文件：{filename}")
    return None


【 在 finlab 的大作中提到: 】
:         try:
:             df = pd.read_excel(path + '/' + fn,engine='openpyxl')  #xlsx
:         except:
: ...................
--
FROM 222.128.195.*