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.

Sign up for GitHub

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

Jump to bottom

Why cell.String() method returned datetime string contains double backslash? #791

Open
dablelv opened this issue Nov 27, 2023 · 2 comments
Open

Why cell.String() method returned datetime string contains double backslash? #791

dablelv opened this issue Nov 27, 2023 · 2 comments

Comments

@dablelv
Copy link

dablelv commented Nov 27, 2023 •
edited

In the excel file, the cell content is a datetime string in format "yyyy-mm-dd hh:mm:ss".

But use cell.String() method to get the content of cell, the returned value is yyyy\\-mm\\-dd\\ hh:mm:ss, such as 2023\\-11\\-27\\ 04:29:44.

The log printing content is:
企业微信截图_17010781771

The excel file content is:

企业微信截图_17010777389729

Why does this happen?

whitesn.xlsx
@github-actions GitHub Actions
Copy link

Stale issue message

@github-actions GitHub Actions
Copy link

github-actions bot commented Apr 2, 2024

Stale issue message

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@tealeg @dablelv