Get cell value in custom date format

[CezarGarrido]

Hello, I'm using excel in a project with Windows, in the excel file there is a cell with a custom format following the following date pattern: 6/11/2020 17:39:36 PM.

When I search for the value of this cell using excelize, it returns a number for example 43993. I would like to know if there is any way to capture this cell value. I may be making a mistake.

go version go1.13.4 windows / amd64
github.com/360EntSecGroup-Skylar/excelize/v2 v2.2.0

[xuri]

Thanks for your issue. GetCellValue just supports get cell value with Excel's built-in formats number format currently. If it couldn't apply a number format of the cell value, it will return the raw value of the cell. Also reference #50 and #73.

[dmint007]

Thanks for your issue. GetCellValue just supports get cell value with Excel's built-in formats number format currently. If it couldn't apply a number format of the cell value, it will return the raw value of the cell. Also reference #50 and #73.

Then how can we fetch the date in the given cell?
I have a hard written date of 09/09/19 which GetCellValue() keeps returning as "43717.0"

v := excelize.parseTime(22, cellValue) is unexported.

[artiz]

Fixed in #703