This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]

Gnumeric spreadsheet and XSLT stylesheet - oh my


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


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]