devbox
很楠不爱3
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Python脚本利用openoffice将office文档转为html或者pdf。_python 连接openoffice

作者：很楠不爱3 | 2024-03-16 14:16:48

赞

踩

python 连接openoffice

准备工作：

一.软件环境：

jdk-7u9-linux-i586.tar.gz    #openoffice安装需要有jdk支持 版本号你随便定

Apache_OpenOffice_4.1.1_Linux_x86_install-rpm_en-US.tar #openoffice软件请到官网下载，我的是最新版本

二.安装部署

1.查看是否安装了JDK


rpm -qa | grep java


如有显示说明已经安装了


那就删除掉


rmp -e java


2.拷贝jdk-7u9-linux-i586.tar.gz到数据库服务器的/web/下

mv  jdk-7u9-linux-i586.tar.gz /home/wwwroot/

解压


tar -zxvf jdk-7u9-linux-i586.tar.gz


3.修改环境变量


vim /etc/profile


添加下面的代码


export JAVA_HOME=/www/web/jdk1.7.0_09
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
export PATH=$PATH:$JAVA_HOME/bin


保存退出


4.重新加载环境变量


source /etc/profile


5.验证是否成功


java -version

如果出现下面三行
java version "1.7.0_09"
Java(TM) SE Runtime Environment (build 1.7.0_09-b05)
Java HotSpot(TM) Client VM (build 23.5-b02, mixed mode)

或者新建Test.java


class Test 
{
        public static void main(String[] args) 
        {
               System.out.println("Hello World!");
        }
}
保存


javac Test.java
java Test

运行结果如下

Hello World!

以上说明jdk没问题了。


6.安装openoffice

tar -zxvf Apache_OpenOffice_4.1.1_Linux_x86_install-rpm_en-US.tar.gz

进入里面RPMS去

ls查看

desktop-integration                           openoffice-en-US-calc-4.1.1-9775.i586.rpm
openoffice-4.1.1-9775.i586.rpm                openoffice-en-US-draw-4.1.1-9775.i586.rpm
openoffice-base-4.1.1-9775.i586.rpm           openoffice-en-US-help-4.1.1-9775.i586.rpm
openoffice-brand-base-4.1.1-9775.i586.rpm     openoffice-en-US-impress-4.1.1-9775.i586.rpm
openoffice-brand-calc-4.1.1-9775.i586.rpm     openoffice-en-US-math-4.1.1-9775.i586.rpm
openoffice-brand-draw-4.1.1-9775.i586.rpm     openoffice-en-US-res-4.1.1-9775.i586.rpm
openoffice-brand-en-US-4.1.1-9775.i586.rpm    openoffice-en-US-writer-4.1.1-9775.i586.rpm
openoffice-brand-impress-4.1.1-9775.i586.rpm  openoffice-gnome-integration-4.1.1-9775.i586.rpm
openoffice-brand-math-4.1.1-9775.i586.rpm     openoffice-graphicfilter-4.1.1-9775.i586.rpm
openoffice-brand-writer-4.1.1-9775.i586.rpm   openoffice-images-4.1.1-9775.i586.rpm
openoffice-calc-4.1.1-9775.i586.rpm           openoffice-impress-4.1.1-9775.i586.rpm
openoffice-core01-4.1.1-9775.i586.rpm         openoffice-javafilter-4.1.1-9775.i586.rpm
openoffice-core02-4.1.1-9775.i586.rpm         openoffice-math-4.1.1-9775.i586.rpm
openoffice-core03-4.1.1-9775.i586.rpm         openoffice-ogltrans-4.1.1-9775.i586.rpm
openoffice-core04-4.1.1-9775.i586.rpm         openoffice-onlineupdate-4.1.1-9775.i586.rpm
openoffice-core05-4.1.1-9775.i586.rpm         openoffice-ooofonts-4.1.1-9775.i586.rpm
openoffice-core06-4.1.1-9775.i586.rpm         openoffice-ooolinguistic-4.1.1-9775.i586.rpm
openoffice-core07-4.1.1-9775.i586.rpm         openoffice-pyuno-4.1.1-9775.i586.rpm
openoffice-draw-4.1.1-9775.i586.rpm           openoffice-ure-4.1.1-9775.i586.rpm
openoffice-en-US-4.1.1-9775.i586.rpm          openoffice-writer-4.1.1-9775.i586.rpm
openoffice-en-US-base-4.1.1-9775.i586.rpm     openoffice-xsltfilter-4.1.1-9775.i586.rpm

然后rpm -ivh *.rpm

很快就安装完成了

7.启动openoffice

cd /opt/openoffice4/program/

我装的是openoffice4，你自己看清楚，使用命令启动

./soffice -headless -accept="socket,host=127.0.0.1,port=8100;urp;" -nofirststartwizard &

如果出现下面
[1] 1784

再查看一下进程

[root@www program]# netstat -tnlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name   
tcp        0      0 0.0.0.0:21                  0.0.0.0:*                   LISTEN      1560/pure-ftpd (SER 
tcp        0      0 0.0.0.0:22                  0.0.0.0:*                   LISTEN      1083/sshd           
tcp        0      0 127.0.0.1:631               0.0.0.0:*                   LISTEN      1027/cupsd          
tcp        0      0 127.0.0.1:25                0.0.0.0:*                   LISTEN      1543/sendmail       
tcp        0      0 127.0.0.1:8100              0.0.0.0:*                   LISTEN      1814/soffice.bin    
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      1494/mysqld         
tcp        0      0 127.0.0.1:11211             0.0.0.0:*                   LISTEN      1576/memcached      
tcp        0      0 127.0.0.1:6379              0.0.0.0:*                   LISTEN      1523/redis-server 1 
tcp        0      0 0.0.0.0:80                  0.0.0.0:*                   LISTEN      1067/nginx          
tcp        0      0 :::21                       :::*                        LISTEN      1560/pure-ftpd (SER 
tcp        0      0 :::22                       :::*                        LISTEN      1083/sshd           
tcp        0      0 ::1:631                     :::*                        LISTEN      1027/cupsd  

可以发现8100端口已经处在监听状态

三、测试文档装换

需要一个Python脚本

注意我直接放在/opt/openoffice4/program 下面建了。

命名为DocumentConvert.py 

直接用了网上一个哥们的代码

  1. #
  2. # PyODConverter (Python OpenDocument Converter) v1.1 - 2009-11-14
  3. #
  4. # This script converts a document from one office format to another by
  5. # connecting to an OpenOffice.org instance via Python-UNO bridge.
  6. #
  7. # Copyright (C) 2008-2009 Mirko Nasato <mirko@artofsolving.com>
  8. # Licensed under the GNU LGPL v2.1 - http://www.gnu.org/licenses/lgpl-2.1.html
  9. # - or any later version.
  10. #
  11. DEFAULT_OPENOFFICE_PORT = 8100
  12.  
  13. import uno
  14. from os.path import abspath, isfile, splitext
  15. from com.sun.star.beans import PropertyValue
  16. from com.sun.star.task import ErrorCodeIOException
  17. from com.sun.star.connection import NoConnectException
  18.  
  19. FAMILY_TEXT = "Text"
  20. FAMILY_WEB = "Web"
  21. FAMILY_SPREADSHEET = "Spreadsheet"
  22. FAMILY_PRESENTATION = "Presentation"
  23. FAMILY_DRAWING = "Drawing"
  24.  
  25. #---------------------#
  26. # Configuration Start #
  27. #---------------------#
  28.  
  29. # see http://wiki.services.openoffice.org/wiki/Framework/Article/Filter
  30.  
  31. # most formats are auto-detected; only those requiring options are defined here
  32. IMPORT_FILTER_MAP = {
  33.     "txt": {
  34.         "FilterName": "Text (encoded)",
  35.         "FilterOptions": "utf8"
  36.     },
  37.     "csv": {
  38.         "FilterName": "Text - txt - csv (StarCalc)",
  39.         "FilterOptions": "44,34,0"
  40.     }
  41. }
  42.  
  43. EXPORT_FILTER_MAP = {
  44.     "pdf": {
  45.         FAMILY_TEXT: { "FilterName": "writer_pdf_Export" },
  46.         FAMILY_WEB: { "FilterName": "writer_web_pdf_Export" },
  47.         FAMILY_SPREADSHEET: { "FilterName": "calc_pdf_Export" },
  48.         FAMILY_PRESENTATION: { "FilterName": "impress_pdf_Export" },
  49.         FAMILY_DRAWING: { "FilterName": "draw_pdf_Export" }
  50.     },
  51.     "html": {
  52.         FAMILY_TEXT: { "FilterName": "HTML (StarWriter)" },
  53.         FAMILY_SPREADSHEET: { "FilterName": "HTML (StarCalc)" },
  54.         FAMILY_PRESENTATION: { "FilterName": "impress_html_Export" }
  55.     },
  56.     "odt": {
  57.         FAMILY_TEXT: { "FilterName": "writer8" },
  58.         FAMILY_WEB: { "FilterName": "writerweb8_writer" }
  59.     },
  60.     "doc": {
  61.         FAMILY_TEXT: { "FilterName": "MS Word 97" }
  62.     },
  63.     "rtf": {
  64.         FAMILY_TEXT: { "FilterName": "Rich Text Format" }
  65.     },
  66.     "txt": {
  67.         FAMILY_TEXT: {
  68.             "FilterName": "Text",
  69.             "FilterOptions": "utf8"
  70.         }
  71.     },
  72.     "ods": {
  73.         FAMILY_SPREADSHEET: { "FilterName": "calc8" }
  74.     },
  75.     "xls": {
  76.         FAMILY_SPREADSHEET: { "FilterName": "MS Excel 97" }
  77.     },
  78.     "csv": {
  79.         FAMILY_SPREADSHEET: {
  80.             "FilterName": "Text - txt - csv (StarCalc)",
  81.             "FilterOptions": "44,34,0"
  82.         }
  83.     },
  84.     "odp": {
  85.         FAMILY_PRESENTATION: { "FilterName": "impress8" }
  86.     },
  87.     "ppt": {
  88.         FAMILY_PRESENTATION: { "FilterName": "MS PowerPoint 97" }
  89.     },
  90.     "swf": {
  91.         FAMILY_DRAWING: { "FilterName": "draw_flash_Export" },
  92.         FAMILY_PRESENTATION: { "FilterName": "impress_flash_Export" }
  93.     }
  94. }
  95.  
  96. PAGE_STYLE_OVERRIDE_PROPERTIES = {
  97.     FAMILY_SPREADSHEET: {
  98.         #--- Scale options: uncomment 1 of the 3 ---
  99.         # a) 'Reduce / enlarge printout': 'Scaling factor'
  100.         "PageScale": 100,
  101.         # b) 'Fit print range(s) to width / height': 'Width in pages' and 'Height in pages'
  102.         #"ScaleToPagesX": 1, "ScaleToPagesY": 1000,
  103.         # c) 'Fit print range(s) on number of pages': 'Fit print range(s) on number of pages'
  104.         #"ScaleToPages": 1,
  105.         "PrintGrid": False
  106.     }
  107. }
  108.  
  109. #-------------------#
  110. # Configuration End #
  111. #-------------------#
  112.  
  113. class DocumentConversionException(Exception):
  114.  
  115.     def __init__(self, message):
  116.         self.message = message
  117.  
  118.     def __str__(self):
  119.         return self.message
  120.  
  121.  
  122. class DocumentConverter:
  123.     
  124.     def __init__(self, port=DEFAULT_OPENOFFICE_PORT):
  125.         localContext = uno.getComponentContext()
  126.         resolver = localContext.ServiceManager.createInstanceWithContext("com.sun.star.bridge.UnoUrlResolver", localContext)
  127.         try:
  128.             context = resolver.resolve("uno:socket,host=localhost,port=%s;urp;StarOffice.ComponentContext" % port)
  129.         except NoConnectException:
  130.             raise DocumentConversionException, "failed to connect to OpenOffice.org on port %s" % port
  131.         self.desktop = context.ServiceManager.createInstanceWithContext("com.sun.star.frame.Desktop", context)
  132.  
  133.     def convert(self, inputFile, outputFile):
  134.  
  135.         inputUrl = self._toFileUrl(inputFile)
  136.         outputUrl = self._toFileUrl(outputFile)
  137.  
  138.         loadProperties = { "Hidden": True }
  139.         inputExt = self._getFileExt(inputFile)
  140.         if IMPORT_FILTER_MAP.has_key(inputExt):
  141.             loadProperties.update(IMPORT_FILTER_MAP[inputExt])
  142.         
  143.         document = self.desktop.loadComponentFromURL(inputUrl, "_blank", 0, self._toProperties(loadProperties))
  144.         try:
  145.             document.refresh()
  146.         except AttributeError:
  147.             pass
  148.  
  149.         family = self._detectFamily(document)
  150.         self._overridePageStyleProperties(document, family)
  151.         
  152.         outputExt = self._getFileExt(outputFile)
  153.         storeProperties = self._getStoreProperties(document, outputExt)
  154.  
  155.         try:
  156.             document.storeToURL(outputUrl, self._toProperties(storeProperties))
  157.         finally:
  158.             document.close(True)
  159.  
  160.     def _overridePageStyleProperties(self, document, family):
  161.         if PAGE_STYLE_OVERRIDE_PROPERTIES.has_key(family):
  162.             properties = PAGE_STYLE_OVERRIDE_PROPERTIES[family]
  163.             pageStyles = document.getStyleFamilies().getByName('PageStyles')
  164.             for styleName in pageStyles.getElementNames():
  165.                 pageStyle = pageStyles.getByName(styleName)
  166.                 for name, value in properties.items():
  167.                     pageStyle.setPropertyValue(name, value)
  168.  
  169.     def _getStoreProperties(self, document, outputExt):
  170.         family = self._detectFamily(document)
  171.         try:
  172.             propertiesByFamily = EXPORT_FILTER_MAP[outputExt]
  173.         except KeyError:
  174.             raise DocumentConversionException, "unknown output format: '%s'" % outputExt
  175.         try:
  176.             return propertiesByFamily[family]
  177.         except KeyError:
  178.             raise DocumentConversionException, "unsupported conversion: from '%s' to '%s'" % (family, outputExt)
  179.     
  180.     def _detectFamily(self, document):
  181.         if document.supportsService("com.sun.star.text.WebDocument"):
  182.             return FAMILY_WEB
  183.         if document.supportsService("com.sun.star.text.GenericTextDocument"):
  184.             # must be TextDocument or GlobalDocument
  185.             return FAMILY_TEXT
  186.         if document.supportsService("com.sun.star.sheet.SpreadsheetDocument"):
  187.             return FAMILY_SPREADSHEET
  188.         if document.supportsService("com.sun.star.presentation.PresentationDocument"):
  189.             return FAMILY_PRESENTATION
  190.         if document.supportsService("com.sun.star.drawing.DrawingDocument"):
  191.             return FAMILY_DRAWING
  192.         raise DocumentConversionException, "unknown document family: %s" % document
  193.  
  194.     def _getFileExt(self, path):
  195.         ext = splitext(path)[1]
  196.         if ext is not None:
  197.             return ext[1:].lower()
  198.  
  199.     def _toFileUrl(self, path):
  200.         return uno.systemPathToFileUrl(abspath(path))
  201.  
  202.     def _toProperties(self, dict):
  203.         props = []
  204.         for key in dict:
  205.             prop = PropertyValue()
  206.             prop.Name = key
  207.             prop.Value = dict[key]
  208.             props.append(prop)
  209.         return tuple(props)
  210.  
  211.  
  212. if __name__ == "__main__":
  213.     from sys import argv, exit
  214.     
  215.     if len(argv) < 3:
  216.         print "USAGE: python %s <input-file> <output-file>" % argv[0]
  217.         exit(255)
  218.     if not isfile(argv[1]):
  219.         print "no such input file: %s" % argv[1]
  220.         exit(1)
  221.  
  222.     try:
  223.         converter = DocumentConverter()    
  224.         converter.convert(argv[1], argv[2])
  225.     except DocumentConversionException, exception:
  226.         print "ERROR! " + str(exception)
  227.         exit(1)
  228.     except ErrorCodeIOException, exception:
  229.         print "ERROR! ErrorCodeIOException %d" % exception.ErrCode
  230.         exit(1)


ok我们放一个doc文档转一下试试

[root@www program]# python DocumentConvert.py 1.doc 1.html
[root@www program]# 

没问题

转pdf试试呢

[root@www program]# python DocumentConvert.py 1.doc 1.pdf
[root@www program]# 


没问题。一切OK


声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/很楠不爱3/article/detail/250003
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号