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

Re: [xsl] problem converting xml to excel

---

---

I am still having the same problem. Can someone please help.

Thanks,
Anna.

On Thursday 11 March 2004 05:06 pm, Anna Bikkina wrote:
> Hi,
>
> I am trying to convert a xml file into excel using xsl. The data in the xml
> comes from a database table. When there are empty columns in any row in the
> xml in excel it is getting filled with the first value entered into
> excel(the one in row 0 col0). I am not able to understand how that value is
> propagating to other rows and columns.
>
>
> My xml file looks like this
> 	<result>
> 		<row><col>col1</col><col>col2</col><col/></row>
> 		<row><col>col1row2</col><col>col2ro2</col><col>col3row2</col></row>
> 	</result>
> If you see carefully the third column in row1 is empty. This is causing a
> problem . Instead of leaving the excel cell empty the cell is being filled
> with the first value I enter into excel. If I do not fill in row0 col0 what
> ever value I fill in first gets in there. Can someone please tell me where
> I am making a mistake.
>
>
> Below is a snippet from my xsl
>
>
>   <xsl:template match="result">
>   	 <xsl:for-each select="column">
>  		     <gmr:Cell Row="4" ValueType="60">
> 		      <xsl:variable name="colnumber"><xsl:number from="result"
> count="column"/></xsl:variable>
> 		      <xsl:attribute name="Col">
> 		         <xsl:value-of select="$colnumber"/>
> 		      </xsl:attribute>
> 		       <gmr:Content>
> 				    <gmr:Styles>
> 				        <gmr:StyleRegion startCol="0" startRow="4" endCol="30"
> endRow="4"> <gmr:Style HAlign="1" VAlign="2" WrapText="0" Orient="1"
> Shade="0" Indent="0" Fore="F800:0:0" Back="0:8000:0"
> PatternColor="C000:C000:C000" Format="General">
> 				          <gmr:Font Unit="9" Bold="1" Italic="0" Underline="0"
> 				StrikeThrough="0">Helvetica</gmr:Font>
> 				        </gmr:Style>
> 				        </gmr:StyleRegion>
> 				      </gmr:Styles>
> 						<xsl:apply-templates select="." mode="value"/>
> 			</gmr:Content>
> 		     </gmr:Cell>
>       </xsl:for-each>
>     <xsl:for-each select="row">
>       <xsl:apply-templates select=".">
>         <xsl:with-param name="rownumber" select="position()+4"/>
>       </xsl:apply-templates>
>     </xsl:for-each>
>   </xsl:template>
>
>   <xsl:template match="row">
>     <xsl:param name="rownumber" select="3"/>
>     <xsl:for-each select="*">
>       <xsl:apply-templates select=".">
>         <xsl:with-param name="rownumber" select="$rownumber"/>
>         <xsl:with-param name="colnumber" select="position()"/>
>       </xsl:apply-templates>
>     </xsl:for-each>
>   </xsl:template>
>
> 	<xsl:template match="col">
> 	   <!-- avoids Result Tree Fragments -->
> 	   <xsl:param name="rownumber" select="0"/>
> 	   <xsl:param name="colnumber" select="0"/>
> 	   <gmr:Cell ValueType="60" Col="{$colnumber}" Row="{$rownumber}">
> 	     <xsl:apply-templates mode="value" select="."/>
> 	   </gmr:Cell>
> 	</xsl:template>
>
>
> Thanks,
> Anna.
>
>
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


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

---