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 as below, or enter http://melksh.am/nnnn for individual articles
Y212 - Python - Code testing, patterns, profiles and optimisation. [235] Preparation for a day's work - (2005-03-04)
[1140] Python GTK - Widget, Packing, Event and Feedback example - (2007-04-09)
[1146] __new__ v __init__ - python constructor alternatives? - (2007-04-14)
[1148] Python decorators - wrapping a method call in extra code - (2007-04-15)
[1555] Advanced Python, Perl, PHP and Tcl training courses / classes - (2008-02-25)
[2616] Defining a static method - Java, Python and Ruby - (2010-02-01)
[3441] Pressing ^C in a Python program. Also Progress Bar. - (2011-09-15)
[3442] A demonstration of how many Python facilities work together - (2011-09-16)
[3464] Passing optional and named parameters to python methods - (2011-10-04)
[3478] Testing your Python classes with the unittest package - how to - (2011-10-14)
[3658] Using Make for a distribution - (2012-03-17)
[4090] Test Driven Development in Python - Customer Comes First - (2013-05-16)
[4326] Learning to program - comments, documentation and test code - (2014-11-22)
[4344] Python base and inherited classes, test harness and unit testing - new examples - (2014-12-07)
[4446] Combining tests into suites, and suites into bigger suites - Python and unittest - (2015-03-01)
[4470] Testing in Python 3 - unittest, doctest and __name__ == __main__ too. - (2015-04-21)
[4538] Flask and unittest - hello web app test world - (2015-10-15)
[4540] Unittest of a Flask application including forms - (2015-10-15)
[4542] The principle of mocking - and the Python Mock package - (2015-10-17)
[4617] Pytest - starting example - (2016-01-07)
[4618] Pytest - second example beyond hello world - (2016-01-08)
[4716] Profiling your Python program - (2016-11-01)
Y150 - Python Development Tools and Environments [316] Development Environments - (2005-05-19)
[745] Python modules. The distribution, The Cheese Shop and the Vaults of Parnassus. - (2006-06-05)
[2370] C++, Python, and other training - do we use an IDE - (2009-08-21)
[2452] Making executable binaries in Python (or Perl) - (2009-10-12)
[3151] Disassembling Python and Java - previously compiled code - (2011-01-29)
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