更简洁地编写 Google Apps 脚本声明



以下Apps Script代码是否可以用更少的代码行以更简洁的方式表达?

// Return the currently active spreadsheet
var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet()
// Get a script property store
var scriptProperties = PropertiesService.getScriptProperties()
// Get the ID of the currently active spreadsheet and set it as a property
scriptProperties.setProperty("id", activeSpreadsheet.getId())
// Open a spreadsheet using its ID
var spreadsheet = SpreadsheetApp.openById(scriptProperties.getProperty("id"))
// Return the first sheet in a spreadsheet
var sheet = spreadsheet.getSheets()[0]

怎么样

var sheet = SpreadsheetApp.getActive().getSheets()[0];

最新更新