[xsl] Gnumeric spreadsheet and XSLT stylesheet

Cart

XML Editor - Download a Free Trial >

See What's New >

Buy Now >

[Home] [By Thread] [By Date] [Recent Entries]

Subject: Gnumeric spreadsheet and XSLT stylesheet - oh my
From: Gary Frederick <gary.frederick@xxxxxxxxx>
Date: Tue, 07 Aug 2001 08:08:22 -0500

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

Current Thread
Gnumeric spreadsheet and XSLT stylesheet - oh my Gary Frederick - Tue, 7 Aug 2001 09:09:11 -0400 (EDT) <=

<- Previous	Index	Next ->
RE: compare two values, Jan Weiss	Thread	Whitespace in XSL not appeari, Eliyahu Hershfeld
RE: compare two values, Oleg Tkachenko	Date	Re: using rules (lines) in fo, Robert J. Lebowitz
	Month

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >