Interacting with Office Libre - Calc

[Les_Leon]

Has anyone successfully written a program to interact with Libre Office Calc? Specifically opening a spreadsheet and reading data from it back into ProvideX similar to the way the DDE command works.

Thank you for your help

Les Leon
(425) 785-7708
leslie.leon@comcast.net 

[John Spencer]

Hello Les:

With help from others on this forum I was able to determine how to process a Libre Calc file (.xlsx) and parse out the contents, so it is possible.

The file is actually a zip file - you can read it like a regular PxPlus keyed file. The parsing of the xml is a bit tedious but all of it is there.

Please contact me if you need some sample code. Thank you.

John Spencer
john@jdsi.ca
250 470 7521

[Cedric]

Hey John, I would be curious to see a sample of your code?   I had a similar task lately where I had to read and import data of and Excel file on my linux server in a background cron task.

We ended up using a conversion tool to convert Excel to CSV and then just read the CSV file.

[John Spencer]

Hello Cedric - please provide an e-mail address and I will send you sample code and a sample Excel file to try this with.

Alternatively, you can call or mail me directly.