-
Notifications
You must be signed in to change notification settings - Fork 82
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
Read currency format #100
Comments
I'm also running into this formatting issue. @abmm Did you happen to find a solution to it? |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi there!,
I have some problems reading columns that have been formatted as currency because values returned look like
erl
dates.For example in this file currency.xlsx columns have Canadian dollar format but what I get for
0.00 CAD
is{0, 0, 0}
, and45,052.00 CAD
is{2023, 5, 6}
and I dont know the reason. Is it possible to get theplain text
value? I see in the documentation that available formats are strings, numbers and dates so I don't know how other formats are parsed.The text was updated successfully, but these errors were encountered: