XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Rahul VaidSubject: Data in Excel not appearing properly after using format-number in xls
Author: Rahul Vaid
Date: 27 Jan 2006 12:51 AM
Hi,
Initially the data that was appearing in my Excel sheet was shown properly.
This data was exported in servlet using :
res.setHeader("Content-type","application/xls");
res.setHeader("Content-disposition","inline; filename="abc.csv");
And at this time my XLS was having the columns as

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="text" indent="no"/>
<xsl:template match="/">
CCY Pair,CCY 1,Average Rate,CCY 2,P&amp;L (USD)
<xsl:apply-templates select="/response/tables/positions/row"/>
</xsl:template>
<xsl:template match="row">
<xsl:value-of select="currencyPair" />,<xsl:value-of select="contractAmount" />,<xsl:value-of select="contractRate"/>,<xsl:value-of select="counterAmount"/>,<xsl:value-of select="gainLoss"/>
<xsl:text>&#13;</xsl:text>


But the moment I used format-number ( ie This format-number has inserted a comma inside my data) as a result of which the the data after comma appears in seperate column.But this I suppose is the csv property to treat every data after comma as seperate data.

<xsl:value-of select="substring(currencyPair,1,3)"/>/<xsl:value-of select="substring(currencyPair,5,3)"/>,<xsl:value-of select="format-number(contractAmount,'###,###.##')"/>,<xsl:value-of select="format-number(contractRate,'###,###.######')"/>,<xsl:value-of select="format-number(counterAmount,'###,###.##')"/>,<xsl:value-of select="format-number(gainLoss,'###,###.##')"/>


Please help me out in this.
Thanx in advance.
Rahul

Posttop
Tony LavinioSubject: Data in Excel not appearing properly after using format-number in xls
Author: Tony Lavinio
Date: 27 Jan 2006 08:47 AM
You have two choices.

1. Don't put commas in numbers for CSV output. For CSV output, if
the number has a comma in it, it isn't a number anymore, because of
point #2 below.

2. Put quotes around the number, like this:
<xsl:variable name="q">&quot;</xsl:variable>
<xsl:value-of select="concat($q, ......., $q)"/>
but then you've turned your number into a string, and it's not a
number anymore.

So, the short answer is, "don't put commas in numbers for CSV output."

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.