Automating OpenOffice from external application

Java, C++, C#, Delphi, ??? - Using the UNO bridges

Automating OpenOffice from external application

Postby collectordave » Thu Feb 11, 2016 9:03 am

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.
Open Office 3.1 on windows 7
collectordave
 
Posts: 3
Joined: Thu Feb 11, 2016 8:50 am

Re: Newbie!! Automating Open Office from external applicati

Postby Zizi64 » Thu Feb 11, 2016 9:34 am

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.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.5 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.1 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7778
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Newbie!! Automating Open Office from external applicati

Postby Villeroy » Thu Feb 11, 2016 10:06 am

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26417
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Newbie!! Automating Open Office from external applicati

Postby collectordave » Thu Feb 11, 2016 10:35 am

Thanks for the replies.

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

Thanks again.
Open Office 3.1 on windows 7
collectordave
 
Posts: 3
Joined: Thu Feb 11, 2016 8:50 am

Re: Automating OpenOffice from external application

Postby collectordave » Tue Apr 05, 2016 6:13 am

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
Open Office 3.1 on windows 7
collectordave
 
Posts: 3
Joined: Thu Feb 11, 2016 8:50 am


Return to External Programs

Who is online

Users browsing this forum: No registered users and 1 guest