Subject: RE: Excel XML tranformation
From: "Thomas V. Nielsen" <thomas@xxxxxxxxxxxxx>
Date: Tue, 5 Nov 2002 16:11:16 +0100
|
> 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
| Current Thread |
- RE: Excel XML tranformation, (continued)
- bryan - Mon, 4 Nov 2002 04:57:42 -0500 (EST)
- Thomas V. Nielsen - Tue, 5 Nov 2002 03:55:34 -0500 (EST)
- Joeri Belis - Tue, 5 Nov 2002 04:23:10 -0500 (EST)
- bryan - Tue, 5 Nov 2002 07:07:55 -0500 (EST)
- Thomas V. Nielsen - Tue, 5 Nov 2002 10:07:44 -0500 (EST) <=
- bryan - Tue, 5 Nov 2002 12:02:35 -0500 (EST)
- bryan - Tue, 5 Nov 2002 12:08:39 -0500 (EST)
|
|