Python实现批量转word和excel工具

# -*- coding: utf-8 -*-
"""
Created on Thu Aug  9 14:21:16 2018

@author: wangxihe
"""
try:
   import os
   os.chdir(r'D:\ExpPdf')
   from win32com.client import Dispatch,constants,gencache
except Exception as e:
   print(str(e))
#   input('Please press enter key to exit0 ...')
#%%
def word2Pdf(wordFile,pdfFile):
    try:
        print('Word Excel Export ...')
        word=gencache.EnsureDispatch('Word.Application')
        doc=word.Documents.Open(wordFile,ReadOnly=1)
#        input('Open ...')
        doc.ExportAsFixedFormat(pdfFile,
                                constants.wdExportFormatPDF,
                                Item=constants.wdExportDocumentWithMarkup,
                                CreateBookmarks=constants.wdExportCreateHeadingBookmarks)
        print("pdfFile:",pdfFile)
        word.Quit(constants.wdDoNotSaveChanges)
    except Exception as e:
       print(str(e))
        #让程序停在这里等待回车键退出
#       input('Please press enter key to exit1 ...')
#%%
def excel2Pdf(excelFile,pdfFile):
    try:
        print('Begin Excel Export ...')
        xlApp=Dispatch('Excel.Application')
        books=xlApp.Workbooks.Open(excelFile)
        books.ExportAsFixedFormat(0,pdfFile)
        print("pdfFile:",pdfFile)
        xlApp.Quit()
    except Exception as e:
       print(str(e))
        #让程序停在这里等待回车键退出
#       input('Please press enter key to exit1 ...')
#%%
def ExportWord():
    wordFiles=[fn for fn in os.listdir('.') if fn.endswith(('.doc','.docx')) ]
    for wordFile in wordFiles:
        wordFile=os.path.abspath(wordFile)
        index=wordFile.rindex('.')
        pdfFile=wordFile[:index]+'.pdf'
        word2Pdf(wordFile,pdfFile)
#%%
def ExportExcel():
    try:
        excelFiles=[fn for fn in os.listdir('.') if fn.endswith(('.xls','.xlsx')) ]
        for excelFile in excelFiles:
#            print("excelFiles:",excelFiles)
            excelFile=os.path.abspath(excelFile)
            index=excelFile.rindex('.')
            pdfFile=excelFile[:index]+'.pdf'
            excel2Pdf(excelFile,pdfFile)
    except Exception as e:
        print(str(e))
        #让程序停在这里等待回车键退出
#        input('Please press enter key to exit3 ...')

#%%

print("开始导出。。。")
ExportWord()
ExportExcel()
print("导出完成。。。")

展开阅读全文

没有更多推荐了,返回首页