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 OverflowError
.
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 :)