P
Purdy
I have an asp.net application.
i export to excel, in exporting to excel i use an xslt to define the
columns and look.
on one of the fields i need the word 'qty' but i need it to look like
' qty' with 5 white spaces. i am able to do that in my xslt and
the export to Excel looks fine also.
but then i have another app i feed this excel sheet to, and in that
app (vbscript) i use trim(qtyField) but it doesn't remove the white
spaces out of the excel app.
if i do it manually without the xslt (place the white spaces in the
qty field), the vbscript app trims the white spaces just fine.
i don't know why??
anyone have any ideas? thx.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xsl:stylesheet [<!ENTITY nbsp " ">]>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:template match="/">
<HTML>
<HEAD>
<STYLE>
.HDR { background-color:bisque;font-weight:bold }
</STYLE>
</HEAD>
<BODY>
<TABLE border="1">
<tr>
<TD CLASS="HDR" align="Center" >Qty</TD>
</tr>
<tr>
<TD fONT="Arial" > QTY</TD>
</tr>
<xsl:for-each select="NewDataSet/Table1" >
<tr>
<TD><xsl:value-of select="Qty"/></TD>
</tr>
</xsl:for-each>
</TABLE>
</BODY>
</HTML>
</xsl:template>
</xsl:stylesheet>
i export to excel, in exporting to excel i use an xslt to define the
columns and look.
on one of the fields i need the word 'qty' but i need it to look like
' qty' with 5 white spaces. i am able to do that in my xslt and
the export to Excel looks fine also.
but then i have another app i feed this excel sheet to, and in that
app (vbscript) i use trim(qtyField) but it doesn't remove the white
spaces out of the excel app.
if i do it manually without the xslt (place the white spaces in the
qty field), the vbscript app trims the white spaces just fine.
i don't know why??
anyone have any ideas? thx.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xsl:stylesheet [<!ENTITY nbsp " ">]>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:template match="/">
<HTML>
<HEAD>
<STYLE>
.HDR { background-color:bisque;font-weight:bold }
</STYLE>
</HEAD>
<BODY>
<TABLE border="1">
<tr>
<TD CLASS="HDR" align="Center" >Qty</TD>
</tr>
<tr>
<TD fONT="Arial" > QTY</TD>
</tr>
<xsl:for-each select="NewDataSet/Table1" >
<tr>
<TD><xsl:value-of select="Qty"/></TD>
</tr>
</xsl:for-each>
</TABLE>
</BODY>
</HTML>
</xsl:template>
</xsl:stylesheet>