I have a vb6 application which I would like to generate an ods spreadsheet. Currently it generates an Excel 2003 xml format file which Excel happily reads but seems to be rejected by LibreOffice. Is there an API I can access to generate an ods spreadsheet?
I don’t have a solution, but you need to provide more info: what is your operating system and version. What is your LibreOffice version? Can you create a print-screen of error message? Can you provide sample file that someone else here on forum can open and test it.
It still quite rare to find a “how-to” web page that explains about exporting object to Open Document Format (e.g. ODS, ODT, ODF). I never heard about the API about exporting to ODS. But there is the tool perhaps you can use to create an ODS file.
Perhaps this example will help you: Programming OpenOffice.org with Visual Basic
And for further reading and knowledge, you can dig from these sites:
Open Documentfor Developer: http://www.opendocumentformat.org/developers/
OASIS site: OASIS Open Document Format for Office Applications (OpenDocument) TC | OASIS
A simple CSV to ODS project on sourceforge: http://sourceforge.net/projects/csv2odf/