Comment read a date in Excel format in Python?
Comment read a date in Excel format in Python?
How can I convert an Excel date (in a number format) to a proper date in Python?
Re: Comment read a date in Excel format in Python?
You can use [xlrd](http://pypi.python.org/pypi/xlrd).
From its [documentation](https://xlrd.readthedocs.io/en/latest/index.html), you can read that dates are always stored as numbers; however, you can use [`xldate_as_tuple`](https://xlrd.readthedocs.io/en/latest/api.html#xlrd.xldate.xldate_as_tuple) to convert it to a python date.
Note: the version on the PyPI seems more up-to-date than the one available on xlrd's website.
From its [documentation](https://xlrd.readthedocs.io/en/latest/index.html), you can read that dates are always stored as numbers; however, you can use [`xldate_as_tuple`](https://xlrd.readthedocs.io/en/latest/api.html#xlrd.xldate.xldate_as_tuple) to convert it to a python date.
Note: the version on the PyPI seems more up-to-date than the one available on xlrd's website.