search

qax-os / excelize

Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
https://xuri.me/excelize
BSD 3-Clause "New" or "Revised" License
17.62k stars 1.68k forks source link

GetCellType for date format cell value returns as Unset #1932

Closed Bowrna closed 18 hours ago

Bowrna commented 1 week ago

I have a excel sheet with cell value set as 2:31:30 AM in cell B13.

When I tried to invoke f.GetCellType('sheet 1', 'B13') returns 0. ( which implies the CellTypeUnset). I tried to log the response and got this

Cell B3: Bowrna
Cell B3 Type: String
Cell C12: TRUE
Cell C12 Type: Bool
Cell B13: 2:31:30 am
Cell B13 Type: Unset

Expecting result for GetCellType: CellTypeDate

Go version go version go1.22.4 darwin/arm64

Excelize version github.com/xuri/excelize/v2 v2.8.1

Environment details (OS, Microsoft Excel™ version, physical, etc.): Apple M1 14.5, downloaded xlsx format from google sheets

xuri commented 5 days ago

Thanks for your issue. This duplicated with issues #1041 and #1375.

xuri commented 2 days ago

I've closed this. If you have any questions, please let me know, and reopen this anytime.