wood burning stoves*
The moose likes XML and Related Technologies and the fly likes Excel Treating String as Date Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Excel Treating String as Date" Watch "Excel Treating String as Date" New topic
Author

Excel Treating String as Date

Harsh Mahey
Greenhorn

Joined: Nov 07, 2002
Posts: 5
I have an XML which has a Data like <data>12-24</data> .When i bring this data in Excel using XSL and JSP ,the Excel shows it as 24 Dec.
I am using the following in xsl
<td style='color:black; font-family:Arial; font-size:8pt;' height="17">
<xsl:value-of select="."/>
</td>
I tried <data>'12-24</data> but then in Excel it comes like '12-24 and when i select the cell and press enter it gets converted to 12-24.
Any suggessions?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Excel Treating String as Date