Permission denied error when reading an opened Excel file in read-only
When using the load_workbook
method to load an Excel file which is also open in in Excel, a PermissionError
exception is raised even if read_only
is set to True
.
It's a pitty because you always have to close your workbook, while read_only
could allow to keep in open in Excel.