Thanks, this appears to be just what I'm looking for!
>>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!
>
>You might want to batch convert your .ods files before vfp looks at them:
>
>PyODConverter:
>
http://www.oooninja.com/2008/02/batch-command-line-file-conversion-with.html>
>PyODConverter supports all of the formats that you can import or export manually in OpenOffice.org. They include:
>
> * odt OpenDocument (ODF) Text
> * sxw OpenOffice.org version 1 Text
> * doc Microsoft Word 97/2000/XP
> * rtf Rich Text Format
> * txt Plain text
> * wpd WordPerfect
> * html Web page
> * ods OpenDocument (ODF) Spreadsheet
> * sxc OpenOffice.org version 1 Spreadsheet
> * xls Microsoft Excel 97/2000/XP
> * odp OpenDocument (ODF) Presentation
> * sxi OpenOffice.org version 1 Presentation
> * ppt Microsoft PowerPoint 97/2000/XP
> * swf Adobe Flash
>
>or jodconverter:
http://www.artofsolving.com/opensource/jodconverter
Steve Howie, owner
DaSH Technology
Denver, CO