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