runawayNinja
June 24th, 2009, 09:40 AM
Hi,
I am creating a .csv file from an xml element.
My XML and XSL work fine, and it creates the file correctly. But when i open the CSV file within excel each line is two rows.
Data data Data
BLANK ROW
Next Data Data Data
in my .xsl file i am applying a for each with
<xsl:value-of select="Email_Address"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="Other record"/>
<xsl:text>
</xsl:text>
Maybe i am using the incorrect newline charactor but any attempt i try results in the same problem.
Any thoughts would be appreciated.
I am creating a .csv file from an xml element.
My XML and XSL work fine, and it creates the file correctly. But when i open the CSV file within excel each line is two rows.
Data data Data
BLANK ROW
Next Data Data Data
in my .xsl file i am applying a for each with
<xsl:value-of select="Email_Address"/>
<xsl:text>,</xsl:text>
<xsl:value-of select="Other record"/>
<xsl:text>
</xsl:text>
Maybe i am using the incorrect newline charactor but any attempt i try results in the same problem.
Any thoughts would be appreciated.