Crash on simple file
Created originally on Bitbucket by Anonymous
Excel 2007 file with content
8001990029363
8001990029387
8001990028694
8001990028663
8001990028649
8001990028854
8001990048081
8001990029370
8001990029394
8001990048180
8001990027710
Code:
from openpyxl.reader.excel import load_workbook
book = load_workbook('error.xlsx', use_iterators=True)
sheet = book.get_active_sheet()
for row in sheet.iter_rows():
print [cell.internal_value for cell in row]
Crash with error:
Traceback (most recent call last):
File "test.py", line 6, in <module>
for row in sheet.iter_rows():
File "C:\Python\lib\site-packages\openpyxl\reader\iter_worksheet.py", line 236, in get_squared_range
cell = cell._replace(internal_value=shared_date.from_julian(float(cell.internal_value)))
File "C:\Python\lib\site-packages\openpyxl\shared\date_time.py", line 162, in from_julian
return EPOCH + datetime.timedelta(days=utc_days)
OverflowError: Python int too large to convert to C long