python成功实现xls转xlsx，并批量迁移

最新推荐文章于 2025-03-10 11:09:36 发布

原创最新推荐文章于 2025-03-10 11:09:36 发布 · 327 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#python

xls转xlsx 专栏收录该内容

2 篇文章

订阅专栏

"""
用python批量获取某路径文件夹及子文件夹下的指定类型文件excel，并按指定路径进行存储
"""

import os
import os
import win32com.client as win32
import shutil

file_excel = []

path = os.getcwd()
path_listdir = os.listdir(path)

for s in path_listdir:
    path_excel = os.path.join(path, s)  # 将文件名加入到当前文件路径后面
    if os.path.isfile(path_excel):  # 如果是文件


        if os.path.splitext(path_excel)[1] == ".xls":  # 如果文件是".xls"后缀的

            excel = win32.gencache.EnsureDispatch('Excel.Application')
            wb = excel.Workbooks.Open(path_excel)
            print(path_excel)
            path_dir = os.path.split(path_excel)[0]
            path_file = os.path.split(path_excel)[1]
            print(path_dir)
            print(path_file)
            wb.SaveAs(path_dir  + '/bak/' + path_file + 'x', FileFormat=51)  # FileFormat = 51 is for .xlsx extension


            wb.Close()  # FileFormat = 56 is for .xls extension
            excel.Application.Quit()

            print(path_excel)
        elif os.path.splitext(path_excel)[1] == ".xlsx":  # 如果文件是".xlsx"后缀的
            excel = win32.gencache.EnsureDispatch('Excel.Application')
            wb = excel.Workbooks.Open(path_excel)
            print(path_excel)
            path_dir = os.path.split(path_excel)[0]
            path_file = os.path.split(path_excel)[1]
            print(path_dir)
            print(path_file)
            wb.SaveAs(path_dir  + '/bak/' + path_file , FileFormat=51)  # FileFormat = 51 is for .xlsx extension
            wb.Close()  # FileFormat = 56 is for .xls extension
            excel.Application.Quit()

            print(path_excel)



    elif os.path.isdir(path_excel):  # 如果是路径
        continue