Page 1 of 1
Automating OpenOffice from external application
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: 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