XSLT newbie Q - output text excel xml

WMitchellCPQ · Feb 25, 2004

Hi im fairly new to XSL and im i have no idea how todo the following.

I'm in a for each loop of a range which happen to be data values - OrderItems. I have another range called OrderItemsHeader which basically is the field name. I want to loop throught the item and then create a tag and inside the tag output the orderitem data.

Below im able to loop through the data range ok. My problem is extracting the data from the header range and then with that creating the tags

Code:

&lt;xsl:for-each select=&quot;xl:Row[xl:Cell/xl:NamedCell[@ss:Name='OrderItems']]&quot;&gt;

&quot;&lt;??&gt;- Im not sure how to create the tags based on another range
&lt;xsl:value-of select=&quot;xl:Cell[position()=1]/xl:Data&quot;/&gt;
&lt;/??&gt;

&lt;/xsl:for-each&gt;

Any help or suggestions would be greatly appreciated
W

WMitchellCPQ · Feb 25, 2004

When I try to be more flexible with my tags the xml document i wish to parse fails.

Code:

 &lt;xsl:text&gt;&lt;NewtagName&gt;&lt;/xsl:text&gt;&lt;xsl:value&gt;&lt;xsl:text&gt;&lt;NewtagName/&gt;&lt;/xsl:text&gt;&lt;xsl:value&gt;

WMitchellCPQ · Feb 25, 2004

When I try to be more flexible with my tags the xml document i wish to parse fails.

Code:

 &lt;xsl:text&gt;&lt;NewtagName&gt;&lt;/xsl:text&gt;&lt;xsl:value&gt;&lt;xsl:text&gt;&lt;NewtagName/&gt;&lt;/xsl:text&gt;&lt;xsl:value&gt;

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

XSLT newbie Q - output text excel xml

WMitchellCPQ

Programmer

WMitchellCPQ

Programmer

WMitchellCPQ

Programmer

Similar threads

Part and Inventory Search

Sponsor