批量将excel另存为pdf时报错。
File "
将报错文件提取出来后运行原路径无误，单独运行报错文件仍然不行。
此时可以将问题定位到文件。
这是一个模糊的报错信息，网上众说纷纭，或说权限问题，或说文件已被打开，或说服务器未正确启动，一一排除后发现是文件存在隐藏表，读取第一个sheet时读取到了隐藏表导致报错。
将隐藏表取消隐藏，或者获取当前活跃表，解决问题。
ws.Visible= False
a=1
while not wb.Worksheets(a).Visible:
a+=1
ws = wb.Worksheets(a)
import os
import win32process,win32api,win32con
import win32com.client
class abc():
def __init__(self,path):
self.path_excels = path
self.excels = []
self.name=[]
self.pdf_small = os.path.join(path, 'pdf')
if not os.path.exists(self.pdf_small):
os.makedirs(self.pdf_small)
def getexcels(self):
a=0
for i in os.listdir(self.path_excels):
if i.split('.')[-1] in ['xlsx', 'xls']:
a+=1
this_excel = os.path.join(self.path_excels, i)
self.excels.append(this_excel)
target_name = os.path.join(self.pdf_small, str(a) + '.pdf')
self.name.append(target_name)
def openexcel(self):
self.excel = win32com.client.DispatchEx('Excel.Application')
self.excel.Visible = False # 是否可视化
self.excel.DisplayAlerts = False
for i in range(len(self.excels)):
self.exceltopdf(i)
self.close_excel_by_force()
def exceltopdf(self, i):
wb = self.excel.Workbooks.Open(self.excels[i], ReadOnly=False)
ws = wb.Worksheets(1)
ws.Show(True)
# target_name=os.path.join(self.pdf_small,self.name[i])
ws.PageSetup.Zoom = False
ws.PageSetup.FitToPagesTall = 1
ws.PageSetup.FitToPagesWide = 1
print(self.excels[i], self.name[i])
ws.ExportAsFixedFormat(0, self.name[i][:-4]) # 不需带文件后缀
wb.Close()
def run(self):
try:
self.getexcels()
if not self.name: raise TypeError('没有excel文件')
self.openexcel()
# shutil.rmtree(self.pdf_small)
except:
if self.excel:
self.close_excel_by_force()
import traceback
print(traceback.format_exc())
# wx.MessageBox(traceback.format_exc())
def close_excel_by_force(self): # 关闭进程
# Get the window's process id's
hwnd = self.excel.Hwnd
t, p = win32process.GetWindowThreadProcessId(hwnd)
# Ask window nicely to close
try:
handle = win32api.OpenProcess(win32con.PROCESS_TERMINATE, 0, p)
if handle:
win32api.TerminateProcess(handle, 0)
win32api.CloseHandle(handle)
except:
pass
if __name__=='__main__':
path = r"C:\Users\gzyz\Desktop\dd\b1"
abc(path).run()
参考文章
您阅读本篇文章共花了：
发表评论