openpyxl unable to open the xlsx
Created originally on Bitbucket by gclu0212
hello all,
i just encountered problem with open the excel with openpyxl on the line " load_workbook()"
the openpyxl version is the latest "openpyxl 2.5.0a1"
it seems the ceel with the style [red], would cause the problem.
here is the error msg:
Traceback (most recent call last): File "E:\Development\python\src\xls.py", line 184, in read_excel() File "E:\Development\python\src\xls.py", line 57, in read_excel inwb = load_workbook(inpath,read_only=False,data_only=True) File "C:\Python27\lib\site-packages\openpyxl-2.5.0a1-py2.7.egg\openpyxl\reader\excel.py", line 247, in load_workbook ws_parser.parse() File "C:\Python27\lib\site-packages\openpyxl-2.5.0a1-py2.7.egg\openpyxl\reader\worksheet.py", line 127, in parse dispatchertag_name File "C:\Python27\lib\site-packages\openpyxl-2.5.0a1-py2.7.egg\openpyxl\reader\worksheet.py", line 287, in parse_row self.parse_cell(cell) File "C:\Python27\lib\site-packages\openpyxl-2.5.0a1-py2.7.egg\openpyxl\reader\worksheet.py", line 223, in parse_cell value = from_excel(value) File "C:\Python27\lib\site-packages\openpyxl-2.5.0a1-py2.7.egg\openpyxl\utils\datetime.py", line 97, in from_excel return datetime.datetime(*parts[:3]) + diff OverflowError: Python int too large to convert to C long
Attachments: 1.xlsx