Hi group, Is it possible to read a LibreOffice .ods file in Xojo? Is there a free plugin for this?
Not sure, but you can save a flat XML out from Libre Office, which is easy to understand. And you could parse this with XML Reader.
best, Thomas
It’s not possible for me, I had even thought of saving a copy as a .csv and reading it (which I already do), but the files I need to read, even if they are simple tables, are in .ods format.
this open source code converts ods to csv.
it is written in java but should not be too complex to convert to xjo code
It looks like if LibreOffice is installed on the machine where you’re doing the processing of these files, it supports converting files via the command line.
Note - don’t use the --headless flag if LibreOffice is currently running:
Hope that helps,
Anthony
1 Like