[Gambas-user] Connect to and control LibreOffice

[Gianluigi]

Great!
Here's a good reason to learn xml :-)

I when I had to import (but you can also export I believe) data from Excel
or Calc I used csv.

Regards
Gianluigi

2017-08-22 12:52 GMT+02:00 Rolf-Werner Eilert <rwe-sse at ...3629...>:

> Am 22.08.2017 12:41, schrieb Benoît Minisini via Gambas-user:
>
>> Le 22/08/2017 à 05:47, Doug Hutcheson a écrit :
>>
>>> On the page http://gambaswiki.org/wiki/doc/intro?nh is this
>>> information:
>>>
>>> Gambas is build on top of many free softwares, and could not exist
>>> without them.
>>> So I would like to thank every people involved in the following
>>> projects:
>>>   * Linux
>>>   * KDE
>>>   * GCC and all of the GNU tools, of course.
>>>   * The Qt toolkit.
>>>   * The GIMP and its toolkit GTK+.
>>>   * Libre Office.
>>>   * The MySQL, PostgreSQL and SQLite database management systems.
>>>   * And any other libraries used by Gambas.
>>>
>>> The reference to LibreOffice is interesting. Does it mean there are
>>> built-in 'hooks' into LibreOffice? I suppose that would be too much to
>>> hope for, but perhaps there is a 'bridge' between LO and Gambas? I need
>>> to update several LO spreadsheets in tandem with creating and
>>> maintaining a new PostgreSQL database storing the same data but in
>>> properly normalised tables.I cannot change the structure of the
>>> existing spreadsheets, so just uncompressing them and running search-
>>> and-replace processes is not quite good enough.
>>>
>>> Any pointers to help in this would be welcome, even if only to say I am
>>> wasting my time.    "8-)
>>> Kind regards,
>>> Doug
>>>
>>
>> No, it just means that I used LibreOffice to write some presentation
>> files. :-)
>>
>> When I want to create a LibreOffice file, I do the following:
>>
>> - I create a "template" LibreOffice file that has the look of the final
>> file, and where the data I want to put is replaced by string patterns.
>>
>> - I unzip the LibreOffice file.
>>
>> - I modify the content.xml file by replacing the string patterns with
>> the final data.
>>
>> - I zip the result, and I get my final LibreOffice file.
>>
>> Regards,
>>
>>
> Clever :) I will print this and pin it to the wall... Might even be a way
> to cope with Scribus.
>
> Regards
>
> Rolf
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>