Anyway to change the sheet order?

问题:

Is there anyway to change to order of specified sheet which already existed? I see there's API called sheet.getIndex(), but there's no set's. The only way now seems call insertSheet().

insertSheet(optName, optSheetIndex, optAdvancedArgs)

You can specify the index with optSheetIndex. Any idea?

回答1:

You can achieve this with setActiveSheet() and moveActiveSheet().