xsl-list
[Top] [All Lists]

RE: [xsl] Rusty at XSLT, need help ("Oil can!, Oil can!")

2010-04-26 17:14:17

Apart from the problems that have been pointed out, the other problem is
that in the XML output from Excel, empty cells are often omitted, their
presence signalled only by the existence of an attribute on the next Cell
element that indicates what column number it is in. This makes processing
the XML quite challenging. When I used to do this regularly, I would
generally preprocess the XML with a generic stylesheet that added column
numbers as attributes to every cell, and then use these attribute values to
retrieve the cell, rather than using positional indexing.

Regards,

Michael Kay
http://www.saxonica.com/
http://twitter.com/michaelhkay 
 

-----Original Message-----
From: cknell(_at_)onebox(_dot_)com [mailto:cknell(_at_)onebox(_dot_)com] 
Sent: 26 April 2010 22:06
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] Rusty at XSLT, need help ("Oil can!, Oil can!")

I used to haunt this list when I was writing XSLT every day, 
but it's been a few years now, and I feel like the Tin 
Woodsman when caught in the rain. I am rusty and I need an 
application of the oil can.

I am trying to extract the text from particular elements in 
an Excel workbook which has been saved to XML format. The 
structure, in short, is this:

<Workbook>
  <DocumentProperties/>
  <ExcelWorkbook/>
   <Worksheet>
      <Names/>
        <Table>
           <Column/>
           <Row>
              <Cell/>
              <Cell/>
              <Cell>
                 <Data>Randolph</Data>
                 <NamedCell/>
              </Cell>
           </Row>
        </Table>
         <WorksheetOptions/>
   </Worksheet>
</Workbook>

There is at least one <Worksheet> Element.

So here I am thinking, "This should be easy. Start with 
selecting the text of the first cell in the first row on the 
first worksheet."

So I use this XSLT:

<?xml version="1.0"?>

<xsl:stylesheet version="2.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
              xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
              
              <xsl:template match="/">
                      <xsl:value-of 
select="Workbook/Worksheet[1]/Table/Row[3]/Data" />
              </xsl:template>
</xsl:stylesheet>

thinking that the output will be "Randolph" because I can see 
 that in the source document . But no, the only output I get 
is the XML document declaration!

Please someone have pity on a fallen-away XSLT programmer 
trying to be in the good graces of the W3C.

What am I doing wrong?

Thanks.
--
Charles Knell
cknell(_at_)onebox(_dot_)com - email

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--