File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Excel Treating String as Date" Watch "Excel Treating String as Date" New topic

Excel Treating String as Date

Harsh Mahey

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="."/>
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:
subject: Excel Treating String as Date
It's not a secret anymore!