search

jsonkenl / xlsxir

Xlsx parser for the Elixir language.
MIT License
215 stars 85 forks source link

Read currency format #100

Open abmm opened 4 years ago

abmm commented 4 years ago

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}, and 45,052.00 CAD is {2023, 5, 6} and I dont know the reason. Is it possible to get the plain 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.

CJKinni commented 3 years ago

I'm also running into this formatting issue. @abmm Did you happen to find a solution to it?