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

Float (currency) is returned as DateTime value by getdata #218

Open
kafisatz opened this issue Nov 8, 2022 · 2 comments
Open

Float (currency) is returned as DateTime value by getdata #218

kafisatz opened this issue Nov 8, 2022 · 2 comments
Labels
bug Something isn't working

Comments

@kafisatz
Copy link

kafisatz commented Nov 8, 2022

Float (currency) is returned as DateTime value by getdata

see attached file

using XLSX 

fi = raw"C:\temp\currency.xlsx"

xf = XLSX.readxlsx(fi);
sheetname = XLSX.sheetnames(xf)[1]
sheet = xf[sheetname]
cells = XLSX.getcellrange(sheet,"A1:A1")
cells[1]
dump(cells[1])
cells[1].value
#result should be 14806.25 a Float64

dta = XLSX.getdata(sheet,cells[1])
@show dta 
dump(dta)
#but result is a DateTime
#dta = DateTime("1940-07-14T06:00:00")
    ```
[currency.xlsx](https://github.com/felipenoris/XLSX.jl/files/9962438/currency.xlsx)
@felipenoris felipenoris added the bug Something isn't working label Nov 8, 2022
@felipenoris
Copy link
Owner

@kafisatz thanks for this bug report! Can you upload the file here?

@kafisatz
Copy link
Author

kafisatz commented Nov 9, 2022

The file is already
here

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants