Libre Office Calc Read & Write

[a_carignan]

I would like to create a software that would allow me to read and write in a LibreOfficeCalc file. I would like a simple and functional example or at least an explanation of how to do it.
Thank you in advance.

[captain_skank]

I think collectordave did some work on this, but can't seem to find the topic at the moment - so you could try serching the forum for his work.

Of the top of my head though, Libreoffice ( & openoffice ) documents are effectively containers which can be opened with 7zip etc and contain xml files ( i think ) which can be quite easily decoded.

Hope this helps.

cheers

[collectordave]

Here is the link to the thread.http://www.purebasic.fr/english/viewtop ... 12&t=65415

Let me know if the link has stopped working.

regards

cd

[Skiller]

Let me know if the link has stopped working

Hi, collectordave. Thx for your great work, but is it possible to give access to an alternative link? Instead of : https://www.dropbox.com/s/2jfh2o3kudu3d ... e.zip?dl=0 . Sorry, but I don't use dropbox.

If not, it's ok but ...

... would be great !!!

[BarryG]

That link's real URL is -> https://www.dropbox.com/s/2jfh2o3kudu3d ... lcFile.zip

And it says the file was deleted.

[NicTheQuick]

Every LibreOffice file is just a ZIP with an OpenDocument structure. The content itself is within an XML file inside of that ZIP.
You can take a look here: http://docs.oasis-open.org/office/v1.2/ ... _826425813
From there on you can find the tag <office:spreadsheet>, then <table:table> and from there the cells and rows. It's quite easy.

[Skiller]

Hi Nic,
Thx for the link. This seems quite a challenge. So, i guess i found a newer Sample from
collectordave here : http://www.mediafire.com/file/dszofwxlo ... e.zip/file
(Sat Oct 31, 2020 6:39 pm) I think, that will help me as a starterkit to use it with PB.
Thanks to collectordave!!! and thanks to you !!

Skiller