[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] correction on Xslt example was RE: Excel XML tranforma
Oops, in the example I sent earlier <xsl:variable name="outpos"><xsl:choose><xsl:when test="@ss:Index"><xsl:value-of select="@ss:Index"/></xsl:when><xsl:otherwise><xsl:value-of select="$pos"/></xsl:otherwise></xsl:choose></xsl:variable> under xsl:template match="Cell" should have been the following: <xsl:variable name="outpos"><xsl:choose><xsl:when test="@ss:Index"><xsl:value-of select="@ss:Index"/></xsl:when><xsl:otherwise><xsl:value-of select="$pos + 1"/></xsl:otherwise></xsl:choose></xsl:variable> so I am sick. There. :) -----Original Message----- From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Thomas V. Nielsen Sent: Tuesday, November 05, 2002 4:11 PM To: 'xsl-list@xxxxxxxxxxxxxxxxxxxxxx' Subject: RE: Excel XML tranformation > here's an example where an empty cell comes in between full cells [SNIP] What I could see from that example is, that the empty cell number 7 is "missing" I know it *is* there because of the Index, like described below > Ss:Index is used to keep track of table structure. Try > ss:Cell[@ss:Index = '6']/Data But this only works if the cell actually have the Index set, that is not always. One way or another I could end up, with an Excel spreadsheet, where I neither can get a match for ss:Cell[6]/ss:Data or ss:Cell[@ss:Index = '6']/Data, even though the data is there. > >From the documentation: "Specifies the column index of this > cell within > the containing row. If this tag is not specified, the first > instance of > a Cell element within a row has an assumed Index="1". Each additional > Cell element has an assumed Index that is one higher. " This I already have figured out without reading it from the documentation ;) My originally request was to do what you describe below > This use of ss:Index, while irritating, also means that one > could make a > generic table handler which either placed cells in, or left them out, > dependant on parameters, etc. passed to the application. Actually, if anyone has an example of such a generic table handler I would very much like to see it. <Thomas/> XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
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
|