Python实现批量将word转html并将html内容发布至网站的方法

本文实例讲述了Python实现批量将word转html并将html内容发布至网站的方法。分享给大家供大家参考。具体实现方法如下：

#coding=utf-8
__author__ = 'zhm'
from win32com import client as wc
import os
import time
import random
import MySQLdb
import re
def wordsToHtml(dir):
#批量把文件夹的word文档转换成html文件
#金山WPS调用，抢先版的用KWPS，正式版WPS
word = wc.Dispatch('KWPS.Application')
for path, subdirs, files in os.walk(dir):
 for wordFile in files:
  wordFullName = os.path.join(path, wordFile)
  #print "word:" + wordFullName
  doc = word.Documents.Open(wordFullName)
  wordFile2 = unicode(wordFile, "gbk")
  dotIndex = wordFile2.rfind(".")
  if(dotIndex == -1):
   print '********************ERROR: 未取得后缀名！'
  fileSuffix = wordFile2[(dotIndex + 1) : ]
  if(fileSuffix == "doc" or fileSuffix == "docx"):
   fileName = wordFile2[ : dotIndex]
   htmlName = fileName + ".html"
   htmlFullName = os.path.join(unicode(path, "gbk"), htmlName)
   # htmlFullName = unicode(path, "gbk") + "\\" + htmlName
   print u'生成了html文件：' + htmlFullName
   doc.SaveAs(htmlFullName, 8)
   doc.Close()
word.Quit()
print ""
print "Finished!"
def html_add_to_db(dir):
#将转换成功的html文件批量插入数据库中。
conn = MySQLdb.connect(
 host='localhost',
 port=3306,
 user='root',
 passwd='root',
 db='test',
 charset='utf8'
 )
cur = conn.cursor()
for path, subdirs, files in os.walk(dir):
 for htmlFile in files:
  htmlFullName = os.path.join(path, htmlFile)
  title = os.path.splitext(htmlFile)[0]
  targetDir = 'D:/files/htmls/'
  #D:/files为web服务器配置的静态目录
  sconds = time.time()
  msconds = sconds * 1000
  targetFile = os.path.join(targetDir, str(int(msconds))+str(random.randint(100, 10000)) +'.html')
  htmlFile2 = unicode(htmlFile, "gbk")
  dotIndex = htmlFile2.rfind(".")
  if(dotIndex == -1):
   print '********************ERROR: 未取得后缀名！'
  fileSuffix = htmlFile2[(dotIndex + 1) : ]
  if(fileSuffix == "htm" or fileSuffix == "html"):
   if not os.path.exists(targetDir):
    os.makedirs(targetDir)
   htmlFullName = os.path.join(unicode(path, "gbk"), htmlFullName)
   htFile = open(htmlFullName,'rb')
   #获取网页内容
   htmStrCotent = htFile.read()
   #找出里面的图片
   img=re.compile(r"""<img\s.*?\s?src\s*=\s*['|"]?([^\s'"]+).*?>""",re.I)
   m = img.findall(htmStrCotent)
   for tagContent in m:
    imgSrc = unicode(tagContent, "gbk")
    imgSrcFullName = os.path.join(path, imgSrc)
    #上传图片
    imgTarget = 'D:/files/images/whzx/'
    img_sconds = time.time()
    img_msconds = sconds * 1000
    targetImgFile = os.path.join(imgTarget, str(int(img_msconds))+str(random.randint(100, 10000)) +'.png')
    if not os.path.exists(imgTarget):
     os.makedirs(imgTarget)
    if not os.path.exists(targetImgFile) or(os.path.exists(targetImgFile) and (os.path.getsize(targetImgFile) != os.path.getsize(imgSrcFullName))):
     tmpImgFile = open(imgSrcFullName,'rb')
     tmpWriteImgFile = open(targetImgFile, "wb")
     tmpWriteImgFile.write(tmpImgFile.read())
     tmpImgFile.close()
     tmpWriteImgFile.close()
     htmStrCotent=htmStrCotent.replace(tagContent,targetImgFile.split(":")[1])
   if not os.path.exists(targetFile) or(os.path.exists(targetFile) and (os.path.getsize(targetFile) != os.path.getsize(htmlFullName))):
    #用iframe包装转换好的html文件。
    iframeHtml='''
    <script type="text/javascript" language="javascript">
     function iFrameHeight() {
      var ifm= document.getElementById("iframepage");
      var subWeb = document.frames ? document.frames["iframepage"].document:ifm.contentDocument;
      if(ifm != null && subWeb != null) {
       ifm.height = subWeb.body.scrollHeight;
      }
     }
    </script>
    <iframe src='''+targetFile.split(':')[1]+'''
     marginheight="0" marginwidth="0" frameborder="0" scrolling="no" width="765" height=100％ id="iframepage" name="iframepage" onLoad="iFrameHeight()" ></iframe>
    '''
    tmpTargetFile = open(targetFile, "wb")
    tmpTargetFile.write(htmStrCotent)
    tmpTargetFile.close()
    htFile.close()
    try:
     # 执行
     sql = "insert into common_article(title,content) values(％s,％s)"
     param = (unicode(title, "gbk"),iframeHtml)
     cur.execute(sql,param)
    except:
     print "Error: unable to insert data"
cur.close()
conn.commit()
# 关闭数据库连接
conn.close()
if __name__ == '__main__':
wordsToHtml('d:/word')
html_add_to_db('d:/word')

希望本文所述对大家的Python程序设计有所帮助。