We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Generate spreadsheet from vb6 [closed]

asked 2013-04-12 15:29:33 +0200

MichaelW gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-07 23:52:29.808533



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.

froz gravatar imagefroz ( 2013-04-12 18:21:13 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-09-09 10:43:23 +0200

Paijo gravatar image

updated 2013-09-09 10:49:07 +0200

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: http://www.kalitech.fr/clients/doc/VB_APIOOo_en.html

And for further reading and knowledge, you can dig from these sites: Open Documentfor Developer: http://www.opendocumentformat.org/developers/ OASIS site: https://www.oasis-open.org/committees/tc_home.php?wg_abbrev=office A simple CSV to ODS project on sourceforge: http://sourceforge.net/projects/csv2odf/

edit flag offensive delete link more

Question Tools


Asked: 2013-04-12 15:29:33 +0200

Seen: 1,743 times

Last updated: Sep 09 '13