Re: wishlist: file export feature

[Alex Barnes <alex barnes sympatico ca>]

On Wed, 2001-12-19 at 11:52, Dan Drake wrote:
> Looking through the archives, I believe this was mentioned sometime last
> year. I'd like to be able to convert a gnumeric spreadsheet to html (or
> other formats) without loading the gnumeric GUI. This would make
> conversion from the xml-based format to html scriptable, which is what I
> would like. Ideally, I would be able to do something like this:
>
> $ gnumeric --convert myfile.gnumeric --toformat=html --outputfile=myfile.html

You can actually do this from the command line by using zcat and some
xslt tool:

$ zcat myfile.gnumeric | some_xslt_tool >myfile.html

All you'd need to do is parse the data under <gmr:Cells> using the xslt
tool and transform it into your html format.

Can anybody recommend a good xslt tool to use for something like this?

> and it would automagically convert the file, just like doing a "Save
> As...html". 
>
> Has there been any thought given to this problem? If you guys could do
> this, I'd swear undying allegiance to gnumeric and never use StarOffice
> again. :)
>
> Thanks!
>
> Dan
>
>
> (I'm interested in this, btw, because I'm a teaching assistant at a
> university, and students often want to know what their scores have been.
> With this, I could convert my gradebook to html, use a perl script to

If you are comfortable with perl, this might be what you need:
http://search.cpan.org/doc/MSERGEANT/XML-LibXSLT-1.31/LibXSLT.pm

I haven't actually tried this myself, so it may be a little more
complicated, but please let me know how it works out.

 -Alex

> remove all of the students except one, and then email the student his or
> her scores.)
>
> -- 
> | 4699  BDCB  B1A5  28B6  7F8A  F8DF  EB6A  BC2A  B0A1  99BF (GPG)
> | Dan Drake <drake lemongecko org> | http://lemongecko.org/drake/