Implement move tab under sheet #new

[fabceolin]

Hi,

We are working with a sheet with a lot of tabs. New tabs are created without a pattern and manage this manually is time-consuming. We would like the possibility to move tabs, like here:
https://stackoverflow.com/questions/16401749/how-to-move-sheet-within-google-spreadsheeet-using-apps-script)

Thanks

[robin900]

@fabceolin That would be a nice feature; in the Sheets API, it is accomplished by modifying the integer index property of each worksheet (what you are calling a "tab") that belongs to a single spreadsheet.

If this feature were added, would you like it to be implemented so that you can pass a list of the Worksheet (tab) objects ordered the way you want them ordered, and then gspread does the necessary operations? Or do you want to update each Worksheet (tab) object's index property individually?

# 1) Order the Worksheets the way you'd like, set that order in a single call.
worksheets = my_sheet.worksheets()
worksheets = worksheets.sorted(lambda w: w['title'])
my_sheet.reorder_worksheets(worksheets)

# 2) update index for each worksheet.
worksheets = my_sheet.worksheets()
worksheets = worksheets.sorted(lambda w: w['title'])
for index, wksht in enumerate(worksheets):
    wksht.update_index(index)

Approach #1 makes only one API call; approach #2 allows fine grained control of the index property. We could implement one or both approaches in one pull request.

[fabceolin]

The approach 2 solve my problem. I only need to force the new created worksheet to appear at the end.