I have noticed the library throws an overflow exception while trying to convert a cell which is a currency type to a date type.
I have temporarily solved the issue by catching the exception. I will fork send pull request though I am not sure if this is a real issue or a problem with data itself. I have attached the file
The sheet: "one sheet" has a column called Total amt in which many cells are some how determined as date types.
A typical log looks like:
Traceback (most recent call last): File "/home/ranjith/VENV/local/lib/python2.7/site-packages/openpyxl-1.5.8-py2.7.egg/openpyxl/reader/iter_worksheet.py", line 243, in get_squared_range cell = cell._replace(internal_value=shared_date.from_julian(float(cell.internal_value))) File "/home/ranjith/VENV/local/lib/python2.7/site-packages/openpyxl-1.5.8-py2.7.egg/openpyxl/shared/date_time.py", line 162, in from_julian return EPOCH + datetime.timedelta(days=utc_days) OverflowError: date value out of range