How to retrieve Date from xslx file
Posted: Wed Jul 22, 2015 9:18 am
Hi All,
I'm trying to parse XSLS file where the B15 cell is DATE and the value is 2015/03/23.
The /xl/worksheets/sheet1.xml file represents it as:
How to convert "40624" value to "2015/03/23"?
Thank you in advance
Alex
I'm trying to parse XSLS file where the B15 cell is DATE and the value is 2015/03/23.
The /xl/worksheets/sheet1.xml file represents it as:
- Code: Select all
<ns2:row r="15" spans="1:5">
<ns2:c r="B15" s="31">
<ns2:v>40624</ns2:v>
</ns2:c>
</ns2:row>
How to convert "40624" value to "2015/03/23"?
Thank you in advance
Alex