The Python-UNO bridge can be used to call up pieces of Python code from within OpenOffice. The source code of a "hello world" example can be found at
http://wiki.services.openoffice.org/wiki/PyUNO_bridge, showing you how to start OpenOffice looking for a connection on a TCP/IP port, and then how to run a Python program to pass data - in this case the text "hello world" - into it.
There are also some recent articles (Feb 2009) on Linux Journal - start at
http://www.linuxjournal.com/content/python-pyuno-hello-world-addon-openoffice which includes an example, and links to other articles which cover the conversion of spreadsheets to csv files (
http://www.linuxjournal.com/node/1007797 )
If all this is more than you need, there's nothing to stop you importing / exporting data to / from OpenOffice in a file format like CSV .. using files that happen to have been written / read by / from Python.
(written 2009-04-09, updated 2009-04-10)
Associated topics are indexed under
Y212 - Python - Code testing, patterns, profiles and optimisation. [3478] Testing your Python classes with the unittest package - how to - (2011-10-14)
[3464] Passing optional and named parameters to python methods - (2011-10-04)
[3442] A demonstration of how many Python facilities work together - (2011-09-16)
[3441] Pressing ^C in a Python program. Also Progress Bar. - (2011-09-15)
[2616] Defining a static method - Java, Python and Ruby - (2010-02-01)
[1555] Advanced Python, Perl, PHP and Tcl training courses / classes - (2008-02-25)
[1148] Python decorators - wrapping a method call in extra code - (2007-04-15)
[1146] __new__ v __init__ - python constructor alternatives? - (2007-04-14)
[1140] Python GTK - Widget, Packing, Event and Feedback example - (2007-04-09)
[235] Preparation for a day's work - (2005-03-04)
Y150 - Python Development Tools and Environments [3151] Disassembling Python and Java - previously compiled code - (2011-01-29)
[2452] Making executable binaries in Python (or Perl) - (2009-10-12)
[2370] C++, Python, and other training - do we use an IDE - (2009-08-21)
[745] Python modules. The distribution, The Cheese Shop and the Vaults of Parnassus. - (2006-06-05)
[316] Development Environments - (2005-05-19)
Some other Articles
Call in the professionals!Weeding out old phone numbersWe have lost a regular business guestBuilding down expectationsUsing Python with OpenOfficeCommission CreepOut in the Vale of PewseyJava on the Web Server - course for delegates with some prior Java experienceMake your business a DESTINATION businessSpring Sprung