Search code examples
javascriptgoogle-apps-scriptgoogle-sheetsweb-applications

Writing Google Apps Script declarations more succinctly


Can the following Apps Script code be expressed in a more succinct manner, with a fewer lines of code?

// 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]

Solution

  • What about

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