This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Gnumeric spreadsheet and XSLT stylesheet - oh my
- To: xsl-list at lists dot mulberrytech dot com
- Subject: [xsl] Gnumeric spreadsheet and XSLT stylesheet - oh my
- From: Gary Frederick <gary dot frederick at jsoft dot com>
- Date: Tue, 07 Aug 2001 08:08:22 -0500
- Organization: Jefferson Software
- Reply-To: xsl-list at lists dot mulberrytech dot com
I recently tried to write a simple XSLT stylesheet for some data that
was in a Gnumeric spreadsheet.
I failed ... sigh
and used some Java code to read the XML and output what I needed.
Has anyone worked with Gnumeric and XSLT?
If so, could you give me a clue on how to generate columns of rows?
Gary
Some info.
http://www.gnome.org/projects/gnumeric/
Gnumeric saves spreadsheets in a zipped XML file. The cells have
attributes that have the row and column numbers.
this is a snippit with the cells for row 80, col 0..5
<gmr:Workbook xmlns:gmr="http://www.gnome.org/gnumeric/v6">
<gmr:Sheets>
<gmr:Sheet>
<gmr:Cells>
...
<gmr:Cell Col="0" Row="80" ValueType="60">
<gmr:Content>Gobbler</gmr:Content>
</gmr:Cell>
<gmr:Cell Col="1" Row="80" ValueType="60">
<gmr:Content>Batton</gmr:Content>
</gmr:Cell>
<gmr:Cell Col="2" Row="80" ValueType="60">
<gmr:Content>Peanut Pond</gmr:Content>
</gmr:Cell>
<gmr:Cell Col="3" Row="80" ValueType="60">
<gmr:Content>Morning</gmr:Content>
</gmr:Cell>
<gmr:Cell Col="4" Row="80" ValueType="30">
<gmr:Content>86</gmr:Content>
</gmr:Cell>
<gmr:Cell Col="5" Row="80" ValueType="30">
<gmr:Content>11</gmr:Content>
</gmr:Cell>
...
I wanted columns in rows, like would be useful for a html table. I could
not think of an easy way to get that with the info in the attributes
with XSLT. I'm still not thinking in XSLT :-)
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list