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) |
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@xxxxxxxxxxxxx</from> <subject>subject1</subject> <received>41640.0</received> </record> <record> <from>test@xxxxxxxxxxxxx</from> <subject>subject2</subject> <received>41640.0</received> </record> </data-set> BR henry
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] '"as" SequenceType' vs 'T, Tony Graham | Thread | Re: [xsl] convert excel date to val, Wolfgang Laun |
Re: [xsl] '"as" SequenceType' vs 'T, Tony Graham | Date | Re: [xsl] convert excel date to val, Wolfgang Laun |
Month |