google-apps-script - 如何使用应用程序脚本在Google Spreadsheet中移动工作表

This question already has an answer here:

Anyway to change the sheet order?

(1个答案)


2年前关闭。




我想使用应用程序脚本在电子表格中移动工作表。
怎么做？

最好的生活!

最佳答案

你看过the documentation吗？

它也显示了一个示例:

 // This example assumes there are two sheets in the current
 // active spreadsheet: one named "first", and another named "second",
 // and that the current active sheet (first) is in position 1
 var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
 var sheet = spreadsheet.getSheetByName("first");

 // This should output 'Current index of sheet: 1'
 Logger.log("Current index of sheet: %s", sheet.getIndex());

 spreadsheet.moveActiveSheet(2);

 // This should output 'New index of sheet: 2'
 Logger.log("New index of sheet: %s", sheet.getIndex());

关于google-apps-script - 如何使用应用程序脚本在Google Spreadsheet中移动工作表，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/16401749/