>I have a website that collects files from clients and translates them into a format for our UNIX server. I was just handed an ods file for the first time today. I can open with Excel 2010, but VFP doesn't seem to have any knowledge of this file type, which makes sense due to it's age.
>
>Is there a third party add-on that will allow me to translate ods to a vfp cursor for processing? I don't think Office is installed and I've never tried automation of open office. Or is it time for a custom .NET dll call from VFP? I would love advice from anyone who's tried this so I don't go down a bunch of dead-ends.
>
>Thanks!
ODx documents are sets of XML files (with some companion files, mostly binaries) packed in a Zip container. Depending on the type of information your clients have on their worksheets, you may try to open them and grab what you need with a XML parser (I believe XMLTOCURSOR() won't cope, but I never tried...).
For instance, this is a cell content of a OD Spreadsheet
<table:table-cell table:style-name="ce1" office:value-type="currency" office:currency="EUR" office:value="420000">
<text:p>420.000,00 €</text:p>
</table:table-cell>
----------------------------------
António Tavares Lopes