Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

AttributeError: module 'openpyxl' has no attribute 'load_workbook'

I'm a beginner in Python. After installing openpyxl 2.6.2 module using below command in pycharm terminal pip install openpyxl. =============CODE========================

import openpyxl

from openpyxl import load_workbook

Even user import openpyxl

wb = load_workbook('transactions.xlsx')

sheet = wb['Sheet1']

cell = sheet['a1']

cell = sheet.cell(1, 1)

print(cell.value)

====================END======================= ERROR i'm facing from openpyxl import loadworkbook File "C:\Users\robin.rana\PycharmProjects\HelloWorld\openpyxl.py", line 1, in <module> from openpyxl import loadworkbook ImportError: cannot import name 'load_workbook' from 'openpyxl' (C:\Users\robin.rana\PycharmProjects\HelloWorld\openpyxl.py)

AttributeError: module 'openpyxl' has no attribute 'load_workbook'

I'm a beginner in Python. After installing openpyxl 2.6.2 module using below command in pycharm terminal terminal

pip install openpyxl. =============CODE========================

import openpyxl

=============CODE======================== from openpyxl import load_workbook

Even user import openpyxl

loadworkbook wb = load_workbook('transactions.xlsx')loadworkbook('transactions.xlsx')

sheet = wb['Sheet1']

cell = sheet['a1']

cell = sheet.cell(1, 1)

print(cell.value)

====================END======================= ERROR i'm facing from openpyxl import loadworkbook File "C:\Users\robin.rana\PycharmProjects\HelloWorld\openpyxl.py", line 1, in <module> from openpyxl import loadworkbook ImportError: cannot import name 'load_workbook' from 'openpyxl' (C:\Users\robin.rana\PycharmProjects\HelloWorld\openpyxl.py)

AttributeError: module 'openpyxl' has no attribute 'load_workbook'

I'm a beginner in Python. After installing openpyxl 2.6.2 module using below command in pycharm terminal

pip install openpyxl. openpyxl.

=============CODE======================== from openpyxl import loadworkbook wb = loadworkbook('transactions.xlsx')

====================END======================= ERROR i'm facing from openpyxl import loadworkbook File "C:\Users\robin.rana\PycharmProjects\HelloWorld\openpyxl.py", line 1, in <module> from openpyxl import loadworkbook ImportError: cannot import name 'load_workbook' from 'openpyxl' (C:\Users\robin.rana\PycharmProjects\HelloWorld\openpyxl.py)

AttributeError: module 'openpyxl' has no attribute 'load_workbook'

I'm a beginner in Python. After installing openpyxl 2.6.2 module using below command in pycharm terminal

pip install openpyxl.

=============CODE======================== from openpyxl import loadworkbook wb = loadworkbook('transactions.xlsx')=============CODE========================

====================END======================= from openpyxl import load_workbook

wb = load_workbook('transactions.xlsx')

====================END=======================

ERROR i'm facing

from openpyxl import loadworkbook
  load_workbook

File "C:\Users\robin.rana\PycharmProjects\HelloWorld\openpyxl.py", line 1, in <module> <module>

from openpyxl import loadworkbook
load_workbook

ImportError: cannot import name 'load_workbook' from 'openpyxl'

(C:\Users\robin.rana\PycharmProjects\HelloWorld\openpyxl.py)