ImportError: cannot import name 'Workbook'

[benneb...@gmail.com]

I'm sure this is only a small thing, but at the moment I'm not able to solve this issue.

I'm trying to use the openpyxl package in order to manipulate some excel sheets.
When I type following into the python shell, everything works :

>>> from openpyxl import Workbook
>>> wb = Workbook()
>>> ws = wb.active

But as soon as I try to create a script with following input, it doesn't work :

from openpyxl import Workbook
wb = Workbook()
ws = wb.active

I always get following message :

Traceback (most recent call last):
  File "C:\Users\bla\AppData\Local\Programs\Python\Python36\Scripts\openpyxl.py", line 1, in <module>
    from openpyxl import Workbook
  File "C:\Users\bla\AppData\Local\Programs\Python\Python36\Scripts\openpyxl.py", line 1, in <module>
    from openpyxl import Workbook
ImportError: cannot import name 'Workbook'

I'am using Python 3.6.2 on a Windows 10 OS, installed the openpyxl package as recommended with 'pip install openpyxl'.

I hope someone can help me soon.

Thanks in advance.

[aimer...@gmail.com]

I encountered the same question in Ubuntu OS.

Hope anyone can help us.

Thanks.

在 2017年7月23日星期日 UTC+8下午8:21:34，benneb...@gmail.com写道：

[tasfiq....@gmail.com]

Facing same problem here. Don't know how to solve the problem.

[aimer...@gmail.com]

Maybe you can use the module in this way:

from openpyxl import load_workbook

try:
    self.wb = load_workbook(xlsx)
except Exception as e:
    logger.error(repr(e))
    raise Exception("Exception takes place when load_workbook {} {}".format(xlsx, repr(e)))

self.sheetnames = self.wb.sheetnames
self.now_sheet = self.wb.active

If anymore help, just raise it.

Aimery

在 2020年1月11日星期六 UTC+8下午2:09:17，tasfiq....@gmail.com写道：

[Pedro Dardengo Mesquita]

This may be due to the name you have put in your file, I'm not sure which one you chose, but if you chose openpyxl.py thats a poor choice.
This may seem obvious... but don't name your file openpyxl.py
Otherwise the it will try to load the file not the module...

Name it, openpyxl_tutorial.py, now the import function should work just fine.

[jolie jin]

Thank you

[Alexander Khamaganov]

You best of the best!!!)

четверг, 4 февраля 2021 г. в 03:35:36 UTC+2, Pedro Dardengo Mesquita:

[Parvateesam Naidu]

You saved my time..

but if you chose openpyxl.py thats a poor choice.
This may seem obvious... but don't name your file openpyxl.py
Otherwise the it will try to load the file not the module...

exactly this is the problem I went into..thanks for your inputs