Ressources

• https://developers.google.com/sheets

  • https://developers.google.com/sheets/api/guides/concepts

  • https://developers.google.com/sheets/api/reference/rest

Function

function myFunctionName() {

  ...

}

Objects

SpreadsheetApp 

object.property

object.method

Methods

.getActicveSpreadsheet()

.createFilter

.clear

.activate

.getValue()

Ranges

.getSheetByName()

.getRange()

.getDataRange()

.getActiveRange()

Formats

.setFontWeight

.setFontColor

.setBackground

.setFontFamily

.setHorizontalAlignment

.setBorder

UI

.getUi()

.createMenu()

.addItem()

.addToUi

Snippets

.getRange('A2:F1000')

.activate();

.getActiveRangeList()

.clear({contentsOnly: true, skipFilteredRows: true});

.getSheetByName('control'), true);