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

read data wrong, which should be a datetime type, but find a number #4

Open
tianxiayu007 opened this issue Feb 20, 2020 · 2 comments
Open

Comments

@tianxiayu007
Copy link

hi, there is something wrong with pyexcel-xlsxr when reading cell contains datetime,
but why? help please
深度截图_选择区域_20200220232342
when read this file as follows:

from pyexcel_xlsxr import get_data
test = get_data('test.xlsx')
print(test)

it print OrderedDict([('sheet1', [['datetime'], [43879]])]), it shuld be wrong!!
Looking forward to your reply

@ogu2
Copy link

ogu2 commented Mar 26, 2020

I ran into this as well. What was your work-around?

I wish they had an option to just give you the raw cell value

@chfw
Copy link
Member

chfw commented Mar 26, 2020

float to date conversion for date cell is missing. Need to find a time to look into it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants