Den 2010-12-28 09:25:54 skrev Jürgen Schmidt <juergen.schm...@oracle.com>:
Hi,
first of all you should subscribe to this mailing list under
http://api.openoffice.org/servlets/ProjectMailingListList with a valid
OOo account.
You can use the OOo API to manipulate a spreadsheet document and insert
any kind of data, create charts, apply formulas etc. Or you can work on
the xml format directly, means you can create a report as template,
unpack the ods and work directly on the content.xml and zip later the
xml streams again to *.ods. The content.xml can be manipulate with
normal xml processing mechanisms like xslt. Or check the odfdom API
(www.odfdom.org), a Java based API to manipulate ODF documents directly
without office.
Juergen
On 12/27/10 7:19 PM, veerapandian wrote:
Dear Dev,
I have developed many reports using excel in VB6. Now we want to
convert it
using open office calc. How could we do it?
Thanks & Regards,
Veerapandian.K
Somehow I thought that the question was something like ”how can I convert
VB6 for Excel to OpenOffice.org Basic for OpenOffice.org Calc?”
I did some searching and found this (probably useless) site:
http://www.business-spreadsheets.com/vba2oo.asp
If your macros are advanced I guess you need to rewrite them for
OpenOffice.org Calc from scratch, unfortunately, but hopefully I am wrong
there…
--
Kind regards
Johnny Rosenberg
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@api.openoffice.org
For additional commands, e-mail: dev-h...@api.openoffice.org
