PureBasic Forums - English

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.

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

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

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 !!!

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

And it says the file was deleted.

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.

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