load_workbook in read_only mode throws AttributeError
New in version 3.1.1:
code: load_workbook(in_mem_file, read_only=True, data_only=True, keep_vba=False)
result: File "C:\Tools\Continuum\anaconda\envs\python_3_9\lib\site-packages\openpyxl\reader\excel.py", line 346, in load_workbook reader.read() File "C:\Tools\Continuum\anaconda\envs\python_3_9\lib\site-packages\openpyxl\reader\excel.py", line 303, in read self.parser.assign_names() File "C:\Tools\Continuum\anaconda\envs\python_3_9\lib\site-packages\openpyxl\reader\workbook.py", line 109, in assign_names sheet.defined_names[name] = defn AttributeError: 'ReadOnlyWorksheet' object has no attribute 'defined_names'
Edited by je-ru