How to get the first sheet of an excel workbook using openpyxl?

Question

I'm able to get the desired sheet by using wb["sheet_name"] method but I want to get the first, or let's say the nth sheet, regardless of the name.

wb = load_workbook(filename = xlsx_dir)   # xlsx_dir is the workbook path

ws = wb["Details"]   # Details is the sheet name

Hello, that does not work for me...it pops up an error and says ws= wb[0] expects a string. — Sibasish Barik, Sep 02 '21 at 12:43

score 28 · Accepted Answer · edited Sep 08 '21 at 11:33

28

You need to use the worksheets property of the workbook object

ws = wb.worksheets[0]

edited Sep 08 '21 at 11:33

eyllanesc

answered Sep 08 '21 at 11:25

wstk

score -5 · Answer 2 · answered Sep 08 '21 at 11:41

-5

you need to use worksheet function sheet_by_name

sheet =  wb.sheet_by_name("Details")

answered Sep 08 '21 at 11:41

Dk2210

2 Answers2