¹«Ë¾°ì¹«ÈËÔ±Èç¹û¾­³£ÐèÒª¶ÔÎı¾Îĵµ¿ªÕ¹´òÓ¡²Ù×÷£¬¿ÉÒÔÊÔÊÔÎÒ²úÉúµÄÕâ¿î´òÓ¡³öexcelÇ¿ÖÆÐÔÍøÒ³Ò³Ãæ×ÝÏò.exeÈí¼þ£¬ÕâÊÇÒ»¸öºÜʵÓõĴòÓ¡³ö¸¨ÖúÈí¼þ£¬¿ÉÒÔ°ïÖúÓû§½«¸÷ÖÖ²»Í¬ÀàÐͺ͸ñʽµÄÎļþÉú³ÉΪ×ÝÏòµÄЧ¹û£¬´Ó¶øÈÃÎļþÍê³É×ÝÏò´òÓ¡³ö£¬Âú×ã¿Í»§µÄ´òÓ¡³öÒªÇ󣬽öÐèÒ»¼ü¾Í¿ÉÒÔת»»¡£

Èí¼þ¹¦ÄÜ

Ö÷ҪΪ¿ìËٵĽ«Îļþ¼ÐÀïµÄPPT¡¢EXCEL¡¢WORDÉú³É¶ÔÓ¦µÄPDF¡£

PS£ºÓ¡ÏóÖÐÈç²»ÄÜת»»·Â·ð±ØÐë×é×°ÓÐoffice£¬ÖƳÉÆ·ÊÇд¶¨ÁËΪ×ÝÏò»¹¿ÉÒԸijɺá×Å»òÊDz»ÉèÖá£

ʹÓ÷½·¨

¿ªÆôExcel£¬//µãÒ»ÏÂ×óÉÏ·½µÄ±¨±í±êʾ£¬µãһϴòÓ¡³ö£¬È»ºóÑ¡Ôñ´òÓ¡Ô¤ÀÀ£¬//ÔÚ´òÓ¡Ô¤ÀÀÀïÓиö¶ÔÍøÒ³Ò³Ãæ×ݺáµÄÉèÖ㬵ãһϺá×Å£¬//µ÷½Ú±¨±íµÄ´óС£¬µãÒ»ÏÂËõ·Å±ÈÀý£¬·ÅËõµ÷Õûµ½´óСºÏÊʵıÈÀý£¬//ÏÂÃæÌôÑ¡Ò³Ãæ²¼¾Ö£¬µãÒ»ÏÂÒ³ÃæÉèÖ㬴¹Ö±¾ÓÖз½·¨µãÒ»ÏÂˮƽºÍ´¹Ö±£¬É趨½áÊøºóÈ«²¿±¨±í¾Í¿É´¹Ö±¾ÓÖÐÁË£¬È»ºó¾Í¿ÉÒÔ´òӡͼƬÁË¡£

±àÂë±íÃ÷

"""

¡¾³ÌÐòÁ÷³Ì¹¦ÄÜ¡¿£º½«¡¾×ÜÌåÄ¿±êÎļþ¼Ð¡¿ÄÚÿһ¸ö ppt¡¢excel¡¢word ¾ùÉú³ÉÒ»·Ý¶ÔÓ¦µÄ PDF Îļþ

¡¾´´×÷Õß¡¿£ºqzw,¸øÓèÄÚ²¿Ê¹ÓÃ

¡¾×ÜÌåÄ¿±êÎļþ¼Ð¡¿£ºÄ¬ÈÏÉèÖÃÒò´Ë³ÌÐòÁ÷³ÌÏֽ׶ÎËùÔÚµÄÎļþ¼Ð£»

Èô¼üÈë;¾¶£¬ÄËΪ¸ÃÎļþ¼Ð£¨Ö»×ª»»¸Ã²ã£¬²»×ª»»×ÓÎļþ¼ÐϾßÌåÄÚÈÝ£©

¡¾Éú³ÉµÄpdfÃû×Ö¡¿£º³õʼÃû×Ö .pdf

"""

import os, win32com.client, gc

# Word

def word2Pdf(filePath, words):

# ÒªÊÇûÓÐÎļþÔòÌáÐѺóÖ±½Ó³·³ö

if(len(words)lt;1):

print ("¡¾ÎÞ Word Îļþ¡¿")

return

# Öð½¥×ª»»

print ("¡¾Öð½¥ Word -gt; PDF ת»»¡¿")

try:

print ("¿ªÆô Word ½ø³Ì...")

word = win32com.client.Dispatch("Word.Application")

word.Visible = 0

word.DisplayAlerts = False

doc = None

for i in range(len(words)):

print(i)

fileName = words[i] # ÎļþÃû×Ö

fromFile = os.path.join(filePath, fileName) # ÎļþÏêϸµØÖ·

toFileName = changeSufix2Pdf(fileName) # Éú³ÉµÄÎļþÃû×Ö

toFile = toFileJoin(filePath,toFileName) # Éú³ÉµÄÎļþÏêϸµØÖ·

print ("ת»»£º" fileName "ÎļþÖÐ...")

# ijÎļþ³ö²î´í²»ÊÜÓ°Ïì±ðµÄÎļþ´òÓ¡³ö

try:

doc = word.Documents.Open(fromFile)

doc.SaveAs(toFile,17) # Éú³ÉµÄËùÓÐ PDF ¶¼»áÔÚ PDF Îļþ¼ÐÖÐ

print ("ת»»µ½£º" toFileName "½øÐÐ")

except Exception as e:

print(e)

# ¹Øµô Word ½ø³Ì

print ("È«²¿ Word ÎļþÒÑ´òÓ¡½áÊø")

print ("Íê±Ï Word ½ø³Ì...")

doc.Close()

doc = None

word.Quit()

word = None

except Exception as e:

print(e)

finally:

gc.collect()

# Excel

def excel2Pdf(filePath, excels):

# ÒªÊÇûÓÐÎļþÔòÌáÐѺóÖ±½Ó³·³ö

if(len(excels)lt;1):

print ("¡¾ÎÞ Excel Îļþ¡¿")

return

# Öð½¥×ª»»

print ("¡¾Öð½¥ Excel -gt; PDF ת»»¡¿")

try:

print ("¿ªÆô Excel ½ø³ÌÖÐ...")

excel = win32com.client.Dispatch("Excel.Application")

excel.Visible = 0

excel.DisplayAlerts = False

wb = None

ws = None

for i in range(len(excels)):

print(i)

fileName = excels[i] # ÎļþÃû×Ö

fromFile = os.path.join(filePath, fileName) # ÎļþÏêϸµØÖ·

print ("ת»»£º" fileName "ÎļþÖÐ...")

# ijÎļþ³ö²î´í²»ÊÜÓ°Ïì±ðµÄÎļþ´òÓ¡³ö

try:

wb = excel.Workbooks.Open(fromFile)

for j in range(wb.Worksheets.Count): # ¹¤×÷²¾×ÜÊý£¬Ò»¸ö¹¤×÷±í¿ÉÄÜÓкü¸ÕŹ¤×÷²¾

toFileName = addWorksheetsOrder(fileName, j 1) # Éú³ÉµÄÎļþÃû×Ö

toFile = toFileJoin(filePath,toFileName) # Éú³ÉµÄÎļþÏêϸµØÖ·

ws = wb.Worksheets(j 1) # ÈôÊÇΪ[0]Ôò×°°üÖ®ºóÌáÐÑÔ½¾³

ws.PageSetup.Orientation=2 # ÉèÖÃÒ³Ã淽룬×ÝÏò=1£¬ºá×Å=2

ws.ExportAsFixedFormat(0,toFile) # ÿһÕŶ¼Òª´òÓ¡³ö

print ("ת»»ÖÁ£º" toFileName "Îļþ½øÐÐ")

except Exception as e:

print(e)

# ¹Øµô Excel ½ø³Ì

print ("È«²¿ Excel ÎļþÒÑ´òÓ¡½áÊø")

print ("Íê±Ï Excel ½ø³ÌÖÐ...")

ws = None

wb.Close()

wb = None

excel.Quit()

excel = None

except Exception as e:

print(e)

finally:

gc.collect()

# PPT

def ppt2Pdf(filePath, ppts):

# ÒªÊÇûÓÐÎļþÔòÌáÐѺóÖ±½Ó³·³ö

if(len(ppts)lt;1):

print ("¡¾ÎÞ PPT Îļþ¡¿")

return

# Öð½¥×ª»»

print ("¡¾Öð½¥ PPT -gt; PDF ת»»¡¿")

try:

print ("¿ªÆô PowerPoint ½ø³ÌÖÐ...")

= win32com.client.Dispatch("PowerPoint.Application")

ppt = None

# ijÎļþ³ö²î´í²»ÊÜÓ°Ïì±ðµÄÎļþ´òÓ¡³ö

for i in range(len(ppts)):

print(i)

fileName = ppts[i] # ÎļþÃû×Ö

fromFile = os.path.join(filePath, fileName) # ÎļþÏêϸµØÖ·

toFileName = changeSufix2Pdf(fileName) # Éú³ÉµÄÎļþÃû×Ö

toFile = toFileJoin(filePath,toFileName) # Éú³ÉµÄÎļþÏêϸµØÖ·

print ("ת»»£º" fileName "ÎļþÖÐ...")

try:

ppt = powerpoint.Presentations.Open(fromFile,WithWindow=False)

if ppt.Slides.Countgt;0:

ppt.SaveAs(toFile, 32) # ¼ÙÈçΪ¿ÕÍùÍù»áÌø³öÀ´µ¯³ö¿ò£¨ÁÙʱÕÒ²»µ½Çå³ý·½·¨£©

print ("ת»»ÖÁ£º" toFileName "Îļþ½øÐÐ")

else:

print("£¨²»ÕýÈ·£¬³öÏÖÒâÍ⣺´ËÎļþΪ¿Õ£¬Èƹý´ËÎļþ£©")

except Exception as e:

print(e)

# ¹Øµô PPT ½ø³Ì

print ("È«²¿ PPT ÎļþÒÑ´òÓ¡½áÊø")

print ("Íê±Ï PowerPoint ½ø³ÌÖÐ...")

ppt.Close()

ppt = None

powerpoint.Quit()

powerpoint = None

except Exception as e:

print(e)

finally:

gc.collect()

# ¸Ä¶¯Îļþºó׺Ãû

def changeSufix2Pdf(file):

return file[:file.rfind('.')] ".pdf"

# ¼ÓÉϹ¤×÷±í±àºÅ

def addWorksheetsOrder(file, i):

return file[:file.rfind('.')] "_¹¤×÷²¾" str(i) ".pdf"

# ת»»ÏêϸµØÖ·

def toFileJoin(filePath,file):

return os.path.join(filePath,'pdf',file[:file.rfind('.')] ".pdf")

# Öð½¥³ÌÐòÁ÷³Ì

print ("====================³ÌÐòÁ÷³ÌÖð½¥====================")

print ("¡¾³ÌÐòÁ÷³Ì¹¦ÄÜ¡¿½«Ä¿±ê·¾¶ÏÂÄÚÿһ¸ö ppt¡¢excel¡¢word ¾ùÉú³ÉÒ»·Ý¶ÔÓ¦µÄ PDF Îļþ£¬´æÓÐÐÂÉú³ÉµÄ pdf Îļþ¼ÐÖУ¨ÐèÔçÒÑ°²×°office£¬²»°üº¬×ÓÎļþ¼Ð£©")

print ("ÁôÒ⣺Èôij PPT ºÍ Excel ÎļþΪ¿Õ£¬ÍùÍù»á³ö²î´íÈƹý´ËÎļþ¡£Èôת»» PPT ʱ¼ä¹ý³¤£¬Çë²é¿´ÊÇ·ñÓгö´í¶Ô»°¿òµÈºòÈ·¶¨£¬ÔÝÇÒ²»Äܳ¹µ×Ïû³ý PPT µÄ¶Ô»°¿òÄÑÌâ¡£Ôڹصô½ø³Ì»·½ÚÖУ¬Ê±³¤¿ÉÄܺܳ¤£¬Ê®ÃëÉÏÏ£¬ÇëÄÍÐĵȴý¡£")

filePath = input ("¼üÈëÄ¿±ê·¾¶£º(ÈôÊÇΪµ±Ç°Â·¾¶£º" os.getcwd() "£¬ÇëÁ¢¼´»Ø³µ¼ü£©")

# Ä¿±ê·¾¶£¬ÈôûÓмüÈë;¾¶ÄËΪµ±Ç°Â·¾¶

if(filePath==""):

filePath = os.getcwd()

# ½«×ÜÌåÄ¿±êÎļþ¼ÐÈ«²¿Îļþ·ÖÀ࣬ת»»Ê±Ö»´ò¿ªÒ»¸ö½ø³Ì

words = []

ppts = []

excels = []

for fn in os.listdir(filePath):

if fn.endswith(('.doc', 'docx')):

words.append(fn)

if fn.endswith(('.ppt', 'pptx')):

ppts.append(fn)

if fn.endswith(('.xls', 'xlsx')):

excels.append(fn)

# µ÷Ó÷½·¨

print ("====================Öð½¥×ª»»====================")

# д´½¨ pdf Îļþ¼Ð£¬È«²¿Éú³ÉµÄ PDF Îļþ¶¼·ÅÔÚÀïÃæ

folder = filePath '\pdf\'

if not os.path.exists(folder):

os.makedirs(folder)

word2Pdf(filePath,words)

excel2Pdf(filePath,excels)

ppt2Pdf(filePath,ppts)

print ("====================ת»»Íê±Ï====================")

print ("====================³ÌÐò½áÊø====================")

os.system("pause")

Èí¼þ²âÆÀ

ÊÖ»úÈí¼þÄܹ»¶ÔÎı¾Îĵµ¿ªÕ¹Ç¿ÖƵÄÒ³Ãæת»»Êµ¼Ê²Ù×÷£¬ÊÊÓÃExcel¡¢Word¡¢PPT¡¢PDFµÈ¼¸ÖÖ¸ñʽµÄÎļþ£¬ÈÃÓû§Äܹ»ºáÏò´òÓ¡ÎļþÒ²¿ÉÒÔ×ÝÏò´òÓ¡³öÎļþ£¬Ìá¸ß¹¤×÷ЧÂÊ¡£