Apache OpenOffice Community Forum

Hi,
I was wondering if i can use open office with a program in python.
I want to be able to do many of the functionality form creating a spreadsheet to updating different components to operating on them. How can i do this? Does open office have an SDK for this? THANK YOU!

Hi and welcome to the forum!

See Need thorough documentation of OOo BASIC objects, etc. Several links in the various topics.

For the SDK: http://www.openoffice.org/download/sdk/index.html
Python can be used with OOo.

Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.

Be aware that you have to use the Python that comes integrated with OpenOffice or do the integration yourself as explained here. The link points to an old page that refers to Python 2.2, rather than the 2.6 that is current in OpenOffice, but I hope it is otherwise correct.

You can use OpenOffice with Python, but as the Hagar Delest hints, the documentation isn't great at the moment. Because I've found it so frustrating, I've started writing some more complete documentation, which you can find at http://www.documenthacker.com / http://documenthacker.wordpress.com. It's only for Writer at the moment, but the biggest frustrations are simply getting going with OpenOffice / LibreOffice, once you get going it becomes a lot easier to work out how to do different tasks. The Python interfaces is actually pretty neat (a lot nicer than Java, which I expected to be the best given OO's history), it just hasn't been that well documented traditionally.