Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 Android Security Essentials Live Lessons this week in the Android 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
 
Similar Threads
How to get XSL table with alternating rows highlighted
Code Allignment In Xml Spy Editor
Building tables in XSL
creating links in XSL
xml xls not seeing anything