猿问

更简洁地编写 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]


哆啦的时光机
浏览 140回答 1
1回答

互换的青春

关于什么var sheet = SpreadsheetApp.getActive().getSheets()[0];
随时随地看视频慕课网APP

相关分类

JavaScript
我要回答