openpyxl how to switch default sheet

Question

My xlsx file has 5 sheets, I can change fourth sheet content, after change, I save to a new file.

But when I open the new file, I need manual to select the fourth sheet.

How can I change the default sheet to fourth sheet?

Thanks!

---

update

It`s work! Thank you very much. But still a little question,

first and fourth sheet both select

I want this only fourth sheet select

Answer 1

Simply set wb.active to the index of the sheet, eg. wb.active = 3 for the fourth sheet.

Answer 2

I've had the same problem as Kobe with multiple sheets selected when manually opening the file after only setting wb.active and saving.

For me the workaround was explicitly setting the tabSelected property of every sheet in the workbook in addition to setting the active worksheet. Here is a minimal example:

import openpyxl

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

workbook.active = 2 # making the third sheet active

for sheet in workbook:
    if sheet.title == 'your_sheet_name':
        sheet.sheet_view.tabSelected = True
    else:
        sheet.sheet_view.tabSelected = False

workbook.save('your_file.xlsx')

With this only one sheet is selected after you manually open the file.