Google Apps Script

GAS
- (def)
- Use cases
- 2種類の開発方式
- Shortcuts
Built-in Classes (GAS用組み込みオブジェクト)
- (def)
- SpreadsheetApp
  - (def)
  - SpreadsheetApp.getActiveSpreadsheet()
  - SpreadsheetApp.openById()
  - SpreadsheetApp.openByURL()
  - SpreadsheetApp.getUi()
  - Spreadsheet
    - (def)
    - spreadsheetVar.getSheetByName() (Preferred)
    - spreadsheetVar.getActiveSheet()
    - spreadsheetVar.rename()
  - Sheet
    - (def)
    - sheetVar.getDataRange()
    - sheetVar.getRange()
    - sheetVar.getName()
    - sheetVar.setName()
    - sheetVar.copyTo()
    - sheetVar.getMaxColumns()
    - sheetVar.deleteColumns()
  - Range
    - (def)
    - rangeVar.getValues()
    - rangeVar.setValues()
    - rangeVar.copyTo()
    - rangeVar.getRichTextValues()
    - rangeVar.setRichTextValues()
    - rangeVar.clearContent()
  - Ui
    - (def)
    - uiVar.alert()
    - uiVar.prompt()
    - uiVar.showModalDialog()
    - uiVar.ButtonSet (Enum)
    - uiVar.Button (Enum)
    - PromptResponse
      - (def)
      - responseVar.getResponseText()
      - responseVar.getSelectedButton()
- DriveApp
  - (def)
  - DriveApp.getFileById()
  - DriveApp.getFolderById()
  - File
    - (def)
    - fileVar.makeCopy()
    - fileVar.getId()
- DocumentApp
  - (def)
  - DocumentApp.openById()
  - Document
    - (def)
    - docVar.getBody()
    - docVar.setName()
  - Text
    - (def)
    - bodyVar.replaceText()
HTML related classes
- HtmlService
API’s
- google.script.run
- google.script.host
Enums
- ButtonSet
Glossary
- Spreadsheet
- Sheet
- 組み込みオブジェクト
- Active sheet
翻訳