xsl-list
[Top] [All Lists]

[xsl] convert excel date to valid date format

2014-01-03 07:54:38
Hi
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"?>
<data-set xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<record>
<from>test(_at_)info-test(_dot_)com</from>
<subject>subject1</subject>
<received>41640.0</received>
</record>
<record>
<from>test(_at_)info-test(_dot_)com</from>
<subject>subject2</subject>
<received>41640.0</received>
</record>
</data-set>

BR
henry

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--


<Prev in Thread] Current Thread [Next in Thread>