Erlang Mailing Lists

Author Message

<  Erlang questions mailing list  ~  OpenDocument Format (ODF)

vance
Posted: Fri Aug 28, 2009 6:25 pm Reply with quote
User Joined: 27 Apr 2005 Posts: 129 Location: Toronto, Ontario, Canada
Is anybody working on generating OpenDocument Format (ODF) in Erlang?

One of my old tricks is to export data in the SYmbolic LinK (SYLK)
file format as a ready built spreadsheet. The SYLK format is an
undocumented early file format from Microsoft which is still supported
by Microsoft Excel. It is an ASCII format which isn't too hard to
understand and easy to produce from Erlang. Using this I can easily
generate reports with spreadsheet formatting and rudimentary formulas
(i.e. column totals).

I'd like an updated solution which would be better supported and allow
greater functionality. It seems that moving to ODF might be the best
way forward.

I haven't tried to grok the ODF syntax for spreadsheets yet, maybe
it's not that much harder than SYLK. I though maybe someone else
might be ahead of me on this though. How about a language binding
to the OpenOffice UNO?

--
-Vance

http://en.wikipedia.org/wiki/OpenDocument
http://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)
http://udk.openoffice.org/

________________________________________________________________
erlang-questions mailing list. See http://www.erlang.org/faq.html
erlang-questions (at) erlang.org

Post received from mailinglist
View user's profile Send private message Send e-mail
Guest
Posted: Fri Aug 28, 2009 6:48 pm Reply with quote
Guest
2009/8/28 Vance Shipley <vances@motivity.ca>:
> Is anybody working on generating OpenDocument Format (ODF) in Erlang?
>
> One of my old tricks is to export data in the SYmbolic LinK (SYLK)
> file format as a ready built spreadsheet.  The SYLK format is an
> undocumented early file format from Microsoft which is still supported
> by Microsoft Excel.  It is an ASCII format which isn't too hard to
> understand and easy to produce from Erlang.  Using this I can easily
> generate reports with spreadsheet formatting and rudimentary formulas
> (i.e. column totals).

I've done some work, converting from ODF into other formats.
Unsure about a lesser Office format, since some ODF suites
can import M$ office documents directly.


>
> I'd like an updated solution which would be better supported and allow
> greater functionality.  It seems that moving to ODF might be the best
> way forward.

ODF is definately easier to generate than M$ office XML

>
> I haven't tried to grok the ODF syntax for spreadsheets yet, maybe
> it's not that much harder than SYLK.  I though maybe someone else
> might be ahead of me on this though.  How about a language binding
> to the OpenOffice UNO?

UNO? Not heard of that one.
You're basically generating a few xml files then zipping them up.



HTH

--
Dave Pawson
XSLT XSL-FO FAQ.
Docbook FAQ.
http://www.dpawson.co.uk

________________________________________________________________
erlang-questions mailing list. See http://www.erlang.org/faq.html
erlang-questions (at) erlang.org

Post received from mailinglist

Display posts from previous:  

All times are GMT
Page 1 of 1
This forum is locked: you cannot post, reply to, or edit topics.

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum