Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

cell value is a timestamp 1651716000, but method GetRows return a string, content is "1651715999.9999998" #1367

Closed
darjun opened this issue Oct 11, 2022 · 2 comments
Labels
duplicate This issue or pull request already exists

Comments

@darjun
Copy link

darjun commented Oct 11, 2022

Description

the cell value is a timestamp 1651716000, but when I use GetRows to read it, it returns a string, in which the content is "1651715999.9999998", something like a float number. My cell format is general.

Steps to reproduce the issue:
1.use the excel at https://github.com/darjun/temp/blob/main/parameter2_info.xlsx
2.read the excel with GetRows

btw, I try to specify option "rawCellValue", but it doesn't work.

@xuri xuri added the duplicate This issue or pull request already exists label Oct 11, 2022
@xuri
Copy link
Member

xuri commented Oct 11, 2022

Thanks for your feedback. Which version of Excelize are you using? This issue was duplicated with #727, #1030, and #1328. This issue has been fixed, and I have tested it with your attachment and it works well. Please upgrade to the latest version or use the master branch code.

@darjun
Copy link
Author

darjun commented Oct 11, 2022

version: 2.6.0 not work
version: 2.6.1 works
thx

@darjun darjun closed this as completed Oct 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
duplicate This issue or pull request already exists
Projects
None yet
Development

No branches or pull requests

2 participants