下面的Apps Script代码能否以更简洁的方式表达,用更少的代码行?// Return the currently active spreadsheetvar activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet()// Get a script property storevar scriptProperties = PropertiesService.getScriptProperties()// Get the ID of the currently active spreadsheet and set it as a propertyscriptProperties.setProperty("id", activeSpreadsheet.getId())// Open a spreadsheet using its IDvar spreadsheet = SpreadsheetApp.openById(scriptProperties.getProperty("id"))// Return the first sheet in a spreadsheetvar sheet = spreadsheet.getSheets()[0]
添加回答
举报
0/150
提交
取消