Page 1 of 1

Automating OpenOffice from external application

PostPosted: Thu Feb 11, 2016 9:03 am
by collectordave
I am very new to the forum. 1 hour now. Sorry if the post is in the wrong pllace

I have been programming using VB for the last few years and have now switched to PureBasic as I wish to write for the MAC.

With VB i was able to automate the office suite to produce word and excell documents from my application. Simply adding text and images to a document. I would like to do the same with open office using PureBasic if possible.

Is there a guide to automating OpenOffice that I could use to make a start on this?

Any help would be really appreciated.

Re: Newbie!! Automating Open Office from external applicati

PostPosted: Thu Feb 11, 2016 9:34 am
by Zizi64
I never heard about the PureBasic. But you can control and automating the Apache OpenOffice and LibreOffice, if you study, understand, and use the API functions of the office suite.

http://www.pitonyak.org/oo.php



___________________________________
Open Office 3.1 on windows 7

OpenOffice.org is a very-very old version of this office suite. Please upgrade your software to the latest AOO or LO version(s), and/or update your signature in this forum.

Re: Newbie!! Automating Open Office from external applicati

PostPosted: Thu Feb 11, 2016 10:06 am
by Villeroy
You can start the office suite in listening mode and use Python to connect with and work with the listening office instance. The office suite comes with a fully functional Python runtime.
It is not a newbie problem anyway. At least you should have a deeper understanding of the office suite you try to manipulate.

Re: Newbie!! Automating Open Office from external applicati

PostPosted: Thu Feb 11, 2016 10:35 am
by collectordave
Thanks for the replies.

I will first upgrade to latest version then study the APIs.

Thanks again.

Re: Automating OpenOffice from external application

PostPosted: Tue Apr 05, 2016 6:13 am
by collectordave
Upgraded to latest version. Definately want to write OO files from PureBasic.

Looked at the options and I think it is easier for me to manipulate the .odt and .ods files directly.

Allready have procedures for UnZipping and some small modyfications. Have written my first procedure to write a calc sheet with data from a database.

Just need to understand xml a little better.

Thanks for the pointers

Regards

CD