jidawanghao的专栏

""" 用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) .

import os import win32com.client as win32 import easygui as eg def save_as_xlsx(fname): excel = win32.DispatchEx('Excel.Application') wb = excel.Workbooks.Open(fname) wb.SaveAs(fname + "x", FileFormat=51) # FileFormat =...