[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Excel XML tranformation

Subject: RE: Excel XML tranformation
From: "Thomas V. Nielsen" <thomas@xxxxxxxxxxxxx>
Date: Tue, 5 Nov 2002 09:58:57 +0100
output excel xml
> >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.

		<Data ss:Type="Number">37530</Data>
		<Data ss:Type="Number">50006</Data>
		<Data ss:Type="String">IRWIN I-100, 6 mm</Data>
		<Data ss:Type="Number">24721013699</Data>
	<Cell ss:Index="6">
		<Data ss:Type="String">IR-i100.jpg</Data>
	<Cell ss:Index="8">
		<Data ss:Type="String">IRcover.jpg</Data>
		<Data ss:Type="String">Irwin-b.eps</Data>
		<Data ss:Type="String">iri-100a.eps</Data>

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.


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list

Current Thread


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.