[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

Re: [xsl] Problem writing xsl to convert xml to excel

---

---

Can someone please answer my question below I am stuck.


On Thursday 04 March 2004 03:41 pm, Anna Bikkina wrote:
> Hi,
>
> I have a xml file that has to converted to excel. I am trying to use a xsl
> s stylesheet and cocoon to do this job for me.
>
> Below is my xml. I am able to display the column's correctly in excel but
> when it comes to data . I am not able to have <Time> data in column1,
> <Action> data in column. I am not able to increment the column value from 0
> to 5. The problem is the number of columns I will have is not known prior .
> So I have to use the count() function to get this done. The way it is
> printing row data right now is in column 5 it prints the value of <user1>
> thats it.  Please check the xsl below and let me know where I am making a
> mistake.
>
>
>   <xsl:template match="result">
>      <xsl:for-each select="column">
>  		     <gmr:Cell Row="0" ValueType="60">
> 		      <xsl:variable name="colnumber"><xsl:number level="any"
> from="result" count="column"/></xsl:variable>
> 		      <xsl:attribute name="Col">
> 		         <xsl:value-of select="$colnumber"/>
> 		      </xsl:attribute>
> 		       <gmr:Content>
> 				<xsl:apply-templates select="." mode="value"/>
> 			</gmr:Content>
> 		     </gmr:Cell>
>       </xsl:for-each>
>
>       <xsl:for-each select="row">
>       	 <xsl:variable name="rownumber"><xsl:number level="any"
> from="result" count="row"/></xsl:variable>
>       	 <xsl:variable name="cnumber"><xsl:number level="any" from="result"
> count="column"/></xsl:variable>
>          <xsl:for-each select="*">
>
> 	 		 <gmr:Cell ValueType="60">
> 			      <xsl:attribute name="Row">
> 			         <xsl:value-of select="$rownumber"/>
> 			      </xsl:attribute>
> 			      <xsl:attribute name="Col">
> 			      	 <xsl:value-of select="$cnumber"/>		<!-- cnumber is not working
> properly. How can I get this working-->
> 			      </xsl:attribute>
> 			      <gmr:Content>
> 					     <xsl:apply-templates select="." mode="value"/>
> 				  </gmr:Content>
> 			 </gmr:Cell>
> 		  </xsl:for-each>
>       </xsl:for-each>
>
>   </xsl:template>
>
>
> My XML FILE
>
>
> <?xml version="1.0"?>
> <page>
> <title>Hello</title>
> <content>
> <result>
> 							<column>Time</column>
> 							<column>Action</column>
> 							<column>Price</column>
> 							<column>User</column>
> 							<column>User1</br></column>
> 					 		<row>
> 					 		 <Time>1</Time>
> 					 		 <Action>120000</Action>
> 					 		 <Price>13</Price>
> 					 		 <Name>12000</Name>
> 					 		 <Name1>120000</Name1>
> 					 		</row>
>
> </result>
>  </content>
> </page>
>
>
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


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

---