OverflowError: date value out of range
This relates to #1152 (closed), which seems to have only partially addressed the issue.
I have a large excel sheet with one date that is out of the valid range. Currently, I get the opaque error
OverflowError: date value out of range, with no indication of what cell causes the problem. I see there is already code from #1152 (closed) which intends to address this. However, that checks only for
ValueError, not for
Simply changing this line to
except (ValueError, OverflowError): will fix this issue.
The new behavior will be
UserWarning: Cell A34829 is marked as a date but the serial value 6688355 is outside the limits for dates. The cell will be treated as an error. which is much easier to work with :)