Gnumeric spreadsheet and XSLT stylesheet - oh my

Play the video

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

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >