A: 

Using Jython is a great idea for this I think. But why could you not use two scripts, one with pyuno/2.3 and one with pymssql/2.5 (or whatever db adapter you are using)?.

The intermediate format could be anything like a pickle, or json, or XML.

Edit: I should add that I have used pyuno quite extensively, and I feel your pain.

Ali A  2008-11-05 11:09:58
Great idea! but as it is company policy to write Java! Sneaking python is a little dodgy, what I say is: I run it on the JVM, what else could it be!? *smirk* then swear cause the job isnt going as smooth as it should, for me to convince others that python really is something to look at seriously
Setori  2008-11-05 15:21:06
So all you happy hacker python jython people! I was hopeing for an answer! Wonder if the open office guys will beat you!?
Setori  2008-11-05 15:22:21
Seriously, pyuno has the number "666" imprinted on it.
Ali A  2008-11-05 20:27:15
Even more seriously, isn't the oo.org Java integration much better than the python integration? It should be, a load of functionality of oo itself is in Java.
Ali A  2008-11-05 20:28:13
yeah, that is why i chose to hop over to jython, giving me access to those libs! ... this is the sad pile of dog regurgitation i have come up with.
Setori  2008-11-06 04:32:59
+1  A: 

And so it goes, according to this guy, you need some oil.... and it works like a charm

http://www.oooforum.org/forum/viewtopic.phtml?p=304263#304263

include this lib C:\OpenOffice_24\program\classes\unoil.jar

Setori  2008-11-06 04:38:37
open office guys beat you all.
Setori  2008-11-06 04:41:31
Thank god at least someone uses and understands that pile of "dog regurgitation".
Ali A  2008-11-06 08:45:32

related questions

Programmatically talking to a Serial Port in OS X or Linux
Best ways to teach a beginner to program?
Calling a Function From a String With the Function's Name in Python
An executable Python app
Text Editor For Linux (Besides Vi)?
What Hosting Service is best for Django applications?
File size differences after copying a file to a server vía FTP
Python: what is the difference between (1,2,3) and [1,2,3], and when should I use each?
Python: What OS am I running on?
How do I make a menu in python that does not require the user to press (enter) to make a selection?
How do you express binary literals in Python?
What is the most efficient graph data structure in Python?
Adding a Method to an Existing Object
How to learn Python: Good Example Code?
How do I use Python's itertools.groupby()?
Python and MySQL
Class views in Django
Is there an IDE that provides code completion for Python
Using 'in' to match an attribute of Python objects in an array
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
Continuous Integration System for a Python Codebase
Get a preview jpeg of a pdf on windows?
How can I find the full path to a font from its display name on a Mac?
XML Processing in Python