Need some help opening excel files in python

Question

Just having a strange issue. I am new in python and while running the below code. Geetting error. I have tried google but unable to run my code. Any advise please

import openpyxl
import os

os.chdir('/Users/omer/Documents/Python_Code/Udemy/Excel_Word_Pdf/')
workbook = openpyxl.load_workbook('example.xlsx')

sheet = workbook.get_sheet_by_name('Sheet1')

workbook.get_sheet_names()

cell = sheet['A1']

And the error i amgetting is

lesson42.py:13: DeprecationWarning: Call to deprecated function get_sheet_by_name (Use wb[sheetname]).
  sheet = workbook.get_sheet_by_name('Sheet1')
lesson42.py:15: DeprecationWarning: Call to deprecated function get_sheet_names (Use wb.sheetnames).
  workbook.get_sheet_names()

Instead of sheet = workbook.get_sheet_by_name('Sheet1') can you try sheet = workbook['Sheet1'] — Sri
– Sri, Commented Apr 11, 2020 at 0:34

Sri · Accepted Answer · 2020-04-11 00:41:23Z

1

I just tested the following. This should work.

import openpyxl
import os

workbook = openpyxl.load_workbook('test.xlsx')

sheet = workbook['Sheet1']

print(workbook.sheetnames)

cell = sheet['A1'].value
print(cell)

answered Apr 11, 2020 at 0:41

Sri

2,3382 gold badges20 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Michael Hsi · Accepted Answer · 2020-04-11 00:38:05Z

0

DeprecationWarning means that you're calling a function that's no longer supported. Go through their documentation to find the new function that's used to get_name, or try using pandas

answered Apr 11, 2020 at 0:38

Michael Hsi

4392 silver badges9 bronze badges

Comments

Teejay Bruno · Accepted Answer · 2020-04-11 00:42:39Z

0

Try viewing sheetnames first: workbook.sheetnames

This will give you a list of available sheets, then you can call them with workbook[#Some Sheet]

answered Apr 11, 2020 at 0:42

Teejay Bruno

2,2091 gold badge7 silver badges13 bronze badges

Collectives™ on Stack Overflow

Need some help opening excel files in python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related