'NoneType' object has no attribute 'iter_cols'
Created originally on Bitbucket by aorczyk (Adam Orczyk)
Hi, I'm using the newest version of openpyxl (2.5.3). I've tried to open xlsx file (created using Microsoft Office Excel 365) and got following error. Opening files created under older Excel works.
#!python
/home/aorczyk/test/env/lib/python3.6/site-packages/openpyxl/packaging/workbook.py:92: UserWarning: File contains an invalid specification for test_silo_utf8_v3. This will be removed
warn(msg)
Silo file error: wrong file structure.
Traceback (most recent call last):
File "test", line 303, in <module>
siloFile = load_silo_file(processor_args.silo_file, processor_args.silo_file_dialect)
File "test", line 86, in load_silo_file
for col in ws.iter_cols():
AttributeError: 'NoneType' object has no attribute 'iter_cols'
#!python
wb = load_workbook(filename = myfile.name)
ws = wb.active
silos = []
for col in ws.iter_cols():
silo = []
for cell in col:
if cell.value
Regards, Adam
Attachments: xlsx_365_test_4.xlsxxlsx_myWin_3.xlsx