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(_at_)lists(_dot_)mulberrytech(_dot_)com
[mailto:owner-xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com] On Behalf Of
Thomas V.
Nielsen
Sent: Tuesday, November 05, 2002 4:11 PM
To: 'xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com'
Subject: RE: [xsl] 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[(_at_)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[(_at_)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