Re: newbie question

[Jody Goldberg <jody gnome org>]

On Thu, Mar 27, 2003 at 09:54:57AM +0100, flora fencl rzb at wrote:
> hi,
>
> my source is a xml file. via xsl i want to generate xls.
> as in my subject mentioned, i am a total newbie.
> the only thing i found on the web was this documentation:
>
> http://www.superlinksoftware.com/gnumeric-xml.pdf
>
> there is no second release of this manual.
> i found loads of docs how to create xls with java and what xml - generated
> with excel - looks like.

Hmm, I don't know of an xsl transform that will do that directly.
There are two options available that should work.

1) Use gnumeric directly to load the xml and export xls
   There is currently no command line only utility to do this, but
   the work to add that is fairly trivial.  I'll probably tack it on
   shortly.

2) The java based hssf and poifs projects will take xml in gnumeric
   format and export it to xls.
 
> i tried some tasks of the documentation i found on the web.
> but some ( simple) thing just don' t want to work, or better: i do
> something wrong, but i don't have a clue what this is.

>             <gmr:Cells>
>                <gmr:Styles>
This is incorrect.  You want
        <gmr:Styles>
            ...
        </gmr:Styles>
        <gmr:Cells>
            ...
        </gmr:Cells>

The Styles element is a child of Sheet, not Cells.

The best documentation of the format is the raw source code.  It
will give you more insight into where things are flexible and where
not.
    gnumeric/src/xml-io.c is the DOM version and

    gnumeric/plugins/xml_sax/xml-sax-read.c is the faster but
    somewhat abridged SAX version.

Hope that helps,
    Jody