🔸GAS ⟩ commands
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)
get range
👉 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()
conditional format
sheet.getConditionalFormatRules()
sheet.setConditionalFormatRules()
SpreadsheetApp.newConditionalFormatRule()
builder.whenNumberLessThan()
builder.setBackground()
builder.setRanges()
SpreadsheetApp - 設定條件格式
Last updated
Was this helpful?