I wrote a script which uses OpenOffice. It can
convert and read a lot of formats.
#!/usr/bin/env python
#Old: !/optlocal/OpenOffice.org/program/python
# (c) 2003-2006 Thomas Guettler
http://www.tbz-pariv.de/
# OpenOffice1.1 comes with its own python interpreter.
# This Script needs to be run with the python from OpenOffice1:
# /opt/OpenOffice.org/program/python
# Start the Office before connecting:
# soffice "-accept=socket,host=localhost,port=2002;urp;"
#
# With OpenOffice2 you can use the default Python-Interpreter (at least on SuSE)
#
# Python Imports
import os
import re
import sys
import getopt
default_path="/usr/lib/ooo-2.0/program"
sys.path.insert(0, default_path)
# pyUNO Imports
try:
import uno
from com.sun.star.beans import PropertyValue
except:
print "This Script needs to be run with the python from OpenOffice.org"
print "Example: /opt/OpenOffice.org/program/python %s" % (
os.path.basename(sys.argv[0]))
print "Or you need to insert the right path at the top, where uno.py is."
print "Default: %s" % default_path
raise
sys.exit(1)
extension=None
format=None
def usage():
scriptname=os.path.basename(sys.argv[0])
print """Usage: %s [--extension pdf --format writer_pdf_Export] files
All files or directories will be converted to HTML.
You must start the office with this line before starting
this script:
soffice "-accept=socket,host=localhost,port=2002;urp;"
If you want to export to something else, you need to use give the extension *and*
the format.
For a list of possible export formats see
http://framework.openoffice.org/files/documents/25/897/filter_description.html
or
/opt/OpenOffice.org/share/registry/data/org/openoffice/Office/TypeDetection.xcu
or
grep -ri MYEXTENSION /usr/lib/ooo-2.0/share/registry/modules/org/openoffice/TypeDetection/
the format is <node oor:name="FORMAT" ...
Attention: Writer (.xls) needs an other export format than Writer (.doc)
Example: calc_pdf_Export instead of writer_pdf_Export
""" % (scriptname)
def do_dir(dir, desktop):
# Load File
dir=os.path.abspath(dir)
if os.path.isfile(dir):
files=[dir]
else:
files=os.listdir(dir)
files.sort()
for file in files:
if file.startswith("."):
continue
file=os.path.join(dir, file)
if os.path.isdir(file):
do_dir(file, desktop)
else:
do_file(file, desktop)
def do_file(file, desktop):
file_l=file.lower()
global format
if extension=="html":
if file_l.endswith(".xls"):
format="HTML (StarCalc)"
elif file_l.endswith(".doc"):
format="HTML (StarWriter)"
else:
print "%s: unkown extension" % file
return
assert(format)
assert(extension)
file_save="%s.%s" % (file, extension)
properties=[]
p=PropertyValue()
p.Name="Hidden"
p.Value=True
properties.append(p)
doc=desktop.loadComponentFromURL(
"file://%s" % file, "_blank", 0, tuple(properties));
if not doc:
print "Failed to open '%s'" % file
return
# Save File
properties=[]
p=PropertyValue()
p.Name="Overwrite"
p.Value=True
properties.append(p)
p=PropertyValue()
p.Name="FilterName"
p.Value=format
properties.append(p)
p=PropertyValue()
p.Name="Hidden"
p.Value=True
try:
doc.storeToURL(
"file://%s" % file_save, tuple(properties))
print "Created %s" % file_save
except ValueError:
import sys
import traceback
import cStringIO
(exc_type, exc_value, tb) = sys.exc_info()
error_file = cStringIO.StringIO()
traceback.print_exception(exc_type, exc_value, tb,
file=error_file)
stacktrace=error_file.getvalue()
print "Failed while writing: '%s'" % file_save
print stacktrace
doc.dispose()
def init_openoffice():
# Init: Connect to running soffice process
context = uno.getComponentContext()
resolver=context.ServiceManager.createInstanceWithContext(
"com.sun.star.bridge.UnoUrlResolver", context)
try:
ctx = resolver.resolve(
"uno:socket,host=localhost,port=2002;urp;StarOffice.ComponentContext")
except:
print "Could not connect to running openoffice."
usage()
sys.exit(1)
smgr=ctx.ServiceManager
desktop = smgr.createInstanceWithContext("com.sun.star.frame.Desktop",ctx)
return desktop
def main():
try:
opts, args = getopt.getopt(sys.argv[1:], "", [
"extension=", "format="])
except getopt.GetoptError,e:
print e
usage()
sys.exit(1)
global extension
global format
for o, a in opts:
if o=="--extension":
extension=a
assert(not extension.startswith("."))
elif o=="--format":
format=a
else:
raise("Internal Error, undone option: %s %s" % (
o, a))
if (not extension) and (not format):
extension="html"
elif extension and format:
pass
else:
print "You need to set format and extension."
usage()
sys.exit(1)
if not args:
usage()
sys.exit(1)
desktop=init_openoffice()
for file in args:
do_dir(file, desktop)
if __name__=="__main__":
main()
