Subject: Re: [xsl] Excel XML tranformation From: "Joeri Belis" <joeri.belis@xxxxxxxxxxxx> Date: Tue, 5 Nov 2002 10:20:34 +0100 |
Thomas, What we do , to get the correct cell, is use named cells. This gives following XML structure: <Row> <Cell ss:StyleID="s58"> <Data ss:Type="Number">9</Data> <NamedCell ss:Name="eannr"/> </Cell> <Cell ss:StyleID="s59"> <Data ss:Type="Number">9</Data> <NamedCell ss:Name="artikelnr"/> </Cell> </Row> You can easly reference the cell by name. Joeri ----- Original Message ----- From: "Thomas V. Nielsen" <thomas@xxxxxxxxxxxxx> To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx> Sent: Tuesday, November 05, 2002 9:58 AM Subject: RE: [xsl] Excel XML tranformation > > >My problem is that does not save the "empty" cell, but refer to the next > > >available cell by using a index, like; > > > When you say like then I assume you mean you are showing a > > simulation of > > Excel's xml output, because the output I routinely get from > > Excel is far > > more detailed than this, also empty cells are saved. > > Hmmm, is there an option to do this? > I just use the "Save As" within Excel 2002 > > > it would probably be better if you provided the exact xml > > coming out of > > excel. The example you gave didn't show the five empty cells. What you > > said earlier indicated that there weren't any empty cells, > > which should > > it be. > > I'll try to rephrase that. The following snippet is the actual xml saved > from Excel, but I have only included one row. > > <Row> > <Cell> > <Data ss:Type="Number">37530</Data> > </Cell> > <Cell> > <Data ss:Type="Number">50006</Data> > </Cell> > <Cell> > <Data ss:Type="String">IRWIN I-100, 6 mm</Data> > </Cell> > <Cell> > <Data ss:Type="Number">24721013699</Data> > </Cell> > <Cell ss:Index="6"> > <Data ss:Type="String">IR-i100.jpg</Data> > </Cell> > <Cell ss:Index="8"> > <Data ss:Type="String">IRcover.jpg</Data> > </Cell> > <Cell> > <Data ss:Type="String">Irwin-b.eps</Data> > </Cell> > <Cell> > <Data ss:Type="String">iri-100a.eps</Data> > </Cell> > </Row> > > What I am missing is the empty cells in spreadsheet. I can have them > exported, by filling out the "blanks" with an "'", but the are not exported > by default. Not all the cells are filled out, but in the transformation I > refer to the cells individually (that's all I could figure out so far). > > So when I do a match in the row for the image, like > <xsl:value-of select="ss:Cell[6]\Data"/> > This would actually give me "IRcover.jpg" instead of "IR-i100.jpg" which I > was expecting. > > <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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] Excel XML tranformation, Thomas V. Nielsen | Thread | RE: [xsl] Excel XML tranformation, bryan |
[xsl] JavaScript problem again!, Johannes . Becker | Date | RE: [xsl] Word Highlighting, Jarno . Elovirta |
Month |