'ReadOnlyWorksheet' object has no attribute 'defined_names'

Question

Whenever I try to read Excel using

part=pd.read_excel(path,sheet_name = mto_sheet)

I get this exception:

<class 'Exception'> 'ReadOnlyWorksheet' object has no attribute 'defined_names'

This is if I use Visual Studio Code and Python 3.11. However, I don't have this problem when using Anaconda. Any reason for that?

score 46 · Accepted Answer · answered Feb 16 '23 at 11:11

46

The error seems to be caused by the latest version of openpyxl. You can fix it by downgrading to a lower version

pip install --force-reinstall -v "openpyxl==3.1.0"

answered Feb 16 '23 at 11:11

InsertCheesyLine

thank you, it worked! hope they fix that error in ver 3.1.1 – Panda Feb 16 '23 at 13:58
Worked like a charm for me, too. – Barrel Roll Mar 02 '23 at 00:49
6

Congratulations on outperforming ChatGPT – Chase Denecke Mar 07 '23 at 02:04
Upstream issue: https://foss.heptapod.net/openpyxl/openpyxl/-/issues/1963 – Yourstruly Mar 09 '23 at 11:17
3

Alternatively, updating to `3.1.2` would be enough. – Leaderboard Mar 17 '23 at 09:53
@Leaderboard 3.1.2 is not yet available on conda. Would force-installing it with pip create issues in a conda environment? – Pythonista anonymous Apr 25 '23 at 14:05
@Pythonistaanonymous it should be fine to install using pip inside a conda environment. – InsertCheesyLine Apr 26 '23 at 04:14

score 3 · Answer 2 · answered Jun 02 '23 at 10:34

3

Seems like the issue is fixed in openpyxl 3.1.2

pip install --upgrade openpyxl

answered Jun 02 '23 at 10:34

Håvard

Yep, once I upgraded openpyxl, this error message went away. – KBurchfiel Jun 13 '23 at 15:22
I'm on 3.1.2 and am still experiencing the same issue. – Willem Jul 14 '23 at 11:21

liquide · Answer 3 · 2023-04-14T10:15:41.403

2

Possible workaround: create new excel file, with default worksheet name ("Sheet1" etc.) and copy and paste data here.

(tested on Python 3.10.9 + openpyxl==3.1.1)

edited Apr 14 '23 at 10:15

answered Apr 13 '23 at 19:14

liquide

3 Answers3