🔸GAS ⟩ commands

Sheet

• add sheet

  • ss.insertSheet(name)

  • ss.insertSheet(name, index)

  • ss.getNumSheets()

• delete sheet

  • ss.deleteSheet(sheet)

  • ss.getSheetByName(name)

  • ss.getSheets()

  • sheet.getName()

• move sheet

  • ss.moveActiveSheet(pos)

Range

• get range

  • sheet.getRange(row, column)

  • 👉 compare: range.getCell(row, column)

• cell value(s)

  • range.getValue() - value of the top-left cell in the range.

  • range.getValues() - 2D array of values.

• formula

  • range.setFormula()

  • range.setFormulaR1C1()

• format

  • range.setNumberFormat()

  • range.setNumberFormats()

  • number & date formats

• conditional format

  • sheet.getConditionalFormatRules()

  • sheet.setConditionalFormatRules()

  • SpreadsheetApp.newConditionalFormatRule()

  • builder.whenNumberLessThan()

  • builder.setBackground()

  • builder.setRanges()

📘 手冊

• SpreadsheetApp - 設定條件格式
• SpreadSheet
• Sheet
• Range
• Logger - Logger.log()
• Triggers - event handlers: onOpen(), onEdit() ...