How to retrieve Date from xslx file

[Oleksandr]

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:

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

[Oleksandr]

I found an explanation of it http://webapp.docx4java.org/OnlineDemo/ecma376/SpreadsheetML/file_5.html

Is there a Util like: DocxDateUtil.convertToDate(40624)?

[fachhoch]

Use

Code: Select all

HSSFDateUtil.getJavaDate(Double.valueOf(dateCell.getV()))

[Oleksandr]

Thank you so much.

[Oleksandr]

How to distinguish Date and Number?
Both data types are represented equally.

Thank you.