469,365 Members | 1,769 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,365 developers. It's quick & easy.

Python/UNO/OpenOffice?

Are then any currently active and reasonably mature Python plugins/
apis/whatever for programming/scripting OpenOffice? The page I've
found is http://udk.openoffice.org/python/python-bridge.html, but
it was last updated more than a year ago.

Thanks,
Ken
Sep 30 '06 #1
7 3435
Just because the last code update was a little over a year ago doesn't
mean the UNO project is dead. If the OpenOffice API has remained
basically the same since UNO was last updated and the Python wrappers
are relatively comprehensive then it should fit the bill. Googling
around the UNO project was the only thing I found off-hand as well...

ke****************@sbcglobal.net wrote:
Are then any currently active and reasonably mature Python plugins/
apis/whatever for programming/scripting OpenOffice? The page I've
found is http://udk.openoffice.org/python/python-bridge.html, but
it was last updated more than a year ago.

Thanks,
Ken
Sep 30 '06 #2
ke****************@sbcglobal.net wrote:
Are then any currently active and reasonably mature Python plugins/
apis/whatever for programming/scripting OpenOffice? The page I've
found is http://udk.openoffice.org/python/python-bridge.html, but
it was last updated more than a year ago.

Thanks,
Ken
I don't believe that information is out-of-date. I use the python-bridge
with the OpenOffice version 2.0.3 quite successfully. In my case I open
a spread sheet and search around for and extract various values. It
works just fine for me.

Gary Herron

Sep 30 '06 #3
That's what I would imagine. Kind of like calling some Microsoft Office
COM/OLE methods in a wrapper. As long as the wrapper has most of the
methods you need and the core COM/OLE calls don't change then that's a
great start.

Gary Herron wrote:
ke****************@sbcglobal.net wrote:
Are then any currently active and reasonably mature Python plugins/
apis/whatever for programming/scripting OpenOffice? The page I've
found is http://udk.openoffice.org/python/python-bridge.html, but
it was last updated more than a year ago.

Thanks,
Ken
I don't believe that information is out-of-date. I use the python-bridge
with the OpenOffice version 2.0.3 quite successfully. In my case I open
a spread sheet and search around for and extract various values. It
works just fine for me.

Gary Herron
Sep 30 '06 #4
ke****************@sbcglobal.net enlightened us with:
Are then any currently active and reasonably mature Python plugins/
apis/whatever for programming/scripting OpenOffice? The page I've
found is http://udk.openoffice.org/python/python-bridge.html, but it
was last updated more than a year ago.
Aside from what has already been said, it might be nice for you to
read my article about OOo and Python at
http://www.stuvel.eu/ooo-python ;-)

Sybren
--
Sybren Stüvel
Stüvel IT - http://www.stuvel.eu/
Sep 30 '06 #5
Sybren Stuvel wrote:
ke****************@sbcglobal.net enlightened us with:
Are then any currently active and reasonably mature Python plugins/
apis/whatever for programming/scripting OpenOffice? The page I've
found is http://udk.openoffice.org/python/python-bridge.html, but it
was last updated more than a year ago.

Aside from what has already been said, it might be nice for you to
read my article about OOo and Python at
http://www.stuvel.eu/ooo-python ;-)
Hi, Sybren. I tried folloing your recipe on Windows with OOo 2.0 ...

Minor problem: the executable is called soffice, not ooffice.

Major problem: it crashed right at the start, somewhere in the maze of
dlls.

The following interactive session reproduces the problem:

| C:\Program Files\OpenOffice.org
2.0\program\python-core-2.3.4\bin>python

# OOo includes a complete python distribution. Note the directory name
says 2.3.4 ...

| Python 2.3.5 (#62, Feb 8 2005, 16:23:02) [MSC v.1200 32 bit (Intel)]
on win32

.... but the program identifies itself as 2.3.5

| Type "help", "copyright", "credits" or "license" for more
information.
| >>import sys
| >>sys.path.append(r'C:\Program Files\OpenOffice.org 2.0\program')

# The above directory contains all the dlls plus a handful of python
files

| >>import pyuno # from pyuno.dll; there's no other pyuno.*
| >>_g_ctx = pyuno.getComponentContext()

# crash

Has anyone managed to get further than this on Windows (XP Pro, SP 2)?

Cheers,
John

Oct 1 '06 #6
John Machin enlightened us with:
Hi, Sybren. I tried folloing your recipe on Windows with OOo 2.0 ...

Minor problem: the executable is called soffice, not ooffice.

Major problem: it crashed right at the start, somewhere in the maze
of dlls.
That's not nice.
Has anyone managed to get further than this on Windows (XP Pro, SP
2)?
Not me - I'm not using Windows. If anyone knows more about this,
please post here or post a comment at
http://www.stuvel.eu/archive/31/arti...org-and-python
so that I can improve the article.

Sybren
--
Sybren Stüvel
Stüvel IT - http://www.stuvel.eu/
Oct 1 '06 #7
For me the problem is that OO2.0 is compiled against P2.3.

Is there any OO compiled with P2.4x for Windows somewhere ?

Sybren Stuvel wrote:
Aside from what has already been said, it might be nice for you to
read my article about OOo and Python at
http://www.stuvel.eu/ooo-python ;-)
Oct 2 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by beliavsky | last post: by
32 posts views Thread by Mike Cox | last post: by
6 posts views Thread by Wolfgang Keller | last post: by
7 posts views Thread by Katja Sss | last post: by
40 posts views Thread by tleeuwenburg | last post: by
12 posts views Thread by Tony Belding | last post: by
7 posts views Thread by PaoloB | last post: by
9 posts views Thread by Marco Bizzarri | last post: by
1 post views Thread by Lawrence D'Oliveiro | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.