Move sheets position

[miguel vfx]

Hello, I would like to know if it's possible to sort, move or re arrange the position of worksheets? Thank you.

[Thomas Nygårds]

I guess it can be done by reordering the elements in

wb._sheets

like so:
from openpyxl import Workbook
wb=Workbook()
# wb.create_sheet("Sheet")  # Sheet already exists
wb.create_sheet("Sheet2")
wb.create_sheet("Sheet3")
wb.create_sheet("SheetA")
wb.create_sheet("ASheet")
wb.save('book_original.xlsx')
myorder=[3,2,0,1,4] 
wb._sheets =[wb._sheets[i] for i in myorder]
wb.save('book_myorder.xlsx')
wb._sheets.sort(key=lambda ws: ws.title)
wb.save('book_alphabetical.xlsx')

Regards
Thomas

[ruship...@gmail.com]

Yes Thomas thanks for the share i worked for me.

And you are correct it works like this.

Thanks Thomas... :)