Ask Your Question
1

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

Comments

2

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
0

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

Stats

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

Seen: 1,346 times

Last updated: Sep 09 '13