Subject:Data in Excel not appearing properly after using format-number in xls Author:Rahul Vaid Date:27 Jan 2006 12:51 AM
Initially the data that was appearing in my Excel sheet was shown properly.
This data was exported in servlet using :
And at this time my XLS was having the columns as
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.
Subject: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:value-of select="concat($q, ......., $q)"/>
but then you've turned your number into a string, and it's not a
So, the short answer is, "don't put commas in numbers for CSV output."