year is out of range - Error
Created originally on Bitbucket by maxifjaved (Muhammad Asif Javed)
While loading an excel file it is throwing year out of range error. I don't have idea from which cell it is throwing. As my excel file is very large and have alot of data.
#!python
excelWorkbook = openpyxl.load_workbook(xlsxUri) File "/usr/local/lib/python2.7/dist-packages/openpyxl/reader/excel.py", line 249, in load_workbook ws_parser.parse() File "/usr/local/lib/python2.7/dist-packages/openpyxl/reader/worksheet.py", line 130, in parse dispatcher[tag_name](element) File "/usr/local/lib/python2.7/dist-packages/openpyxl/reader/worksheet.py", line 292, in parse_row self.parse_cell(cell) File "/usr/local/lib/python2.7/dist-packages/openpyxl/reader/worksheet.py", line 226, in parse_cell value = from_excel(value, self.epoch) File "/usr/local/lib/python2.7/dist-packages/openpyxl/utils/datetime.py", line 97, in from_excel return datetime.datetime(*parts[:3]) + diff ValueError: year is out of range