[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

[xsl] convert excel date to valid date format

Subject: [xsl] convert excel date to valid date format
From: henry human <henry_human@xxxxxxxx>
Date: Fri, 3 Jan 2014 13:51:32 +0000 (GMT)

This XML is created by export of an EXCEL spreadsheet.
(For the export of
EXCEL data to XML I used the below the same XML structure such as the the XML
file below as a schema too to use the mapping functionality of EXCEL as it is
described by Microsoft tutorials)

In the field received in the original
EXCEL file the value for both record elements was January 01.01.2014 but after
export it was automatically converted to 41640.0

In Java I could convert the
value with help of java.util.Calendar to the original value. 
Is it there a
way converting the format in XSLT too?

<?xml version="1.0"
encoding="UTF-8" standalone="yes"?>


Current Thread