Subject: [xsl] Rusty at XSLT, need help ("Oil can!, Oil can!") From: cknell@xxxxxxxxxx Date: Mon, 26 Apr 2010 17:05:56 -0400 |
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@xxxxxxxxxx - email
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Flattening, grouping & orderi, Fjoerie | Thread | Re: [xsl] Rusty at XSLT, need help , Andrew Welch |
RE: [xsl] Total Missing documents f, Shashank Jain | Date | Re: [xsl] Rusty at XSLT, need help , Andrew Welch |
Month |