Re: wishlist: file export feature

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

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. :)



(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:

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


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> |

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]