aspose file tools*
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
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?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Excel Treating String as Date
 
Similar Threads
Code Allignment In Xml Spy Editor
xml xls not seeing anything
creating links in XSL
Building tables in XSL
How to get XSL table with alternating rows highlighted