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

Date origin wrong if non-date in column #48

Open
GoogleCodeExporter opened this issue Jul 19, 2015 · 0 comments
Open

Date origin wrong if non-date in column #48

GoogleCodeExporter opened this issue Jul 19, 2015 · 0 comments

Comments

@GoogleCodeExporter
Copy link

As posted as a StackOverflow question, with sample file and code:

http://stackoverflow.com/questions/25158969/read-xlsx-reading-dates-wrong-if-non
-date-in-column

Basically, if there's a non-date in a column then read.xlsx will convert dates 
from using the excel 1899 epoch, rather than 1970 and so be 70 years in the 
future. Skip reading the non-date item and it all converts correctly.


Original issue reported on code.google.com by b.rowlin...@gmail.com on 6 Aug 2014 at 3:49

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

No branches or pull requests

1 participant