Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 254
timchen Avatar asked Jan 26 '13 04:01

timchen


People also ask

How do you quickly rearrange tabs in Excel?

Method 1 - Change Order of Tabs Left-click and hold the mouse button until you see a little black arrow appear next to the tab and your mouse pointer should have a small "page" icon under it (this icon didn't come through on the screenshot below). Then, simply drag the sheet tab to whichever position you want.

Can you change the order of sheets in Google Sheets?

Sort an entire sheet On your computer, open a spreadsheet in Google Sheets. At the top, right-click the letter of the column you want to sort by. Click Sort sheet A to Z or Sort sheet Z to A.


1 Answers

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

like image 86
AdamL Avatar answered Oct 29 '22 19:10

AdamL