excol
Options
All
  • Public
  • Public/Protected
  • All
Menu

SpreadsheetApp class.

Hierarchy

  • SpreadsheetApp

Index

Constructors

constructor

Properties

_numColumns

_numColumns: number

_numRows

_numRows: number

DataValidationCriteria

DataValidationCriteria: DataValidationCriteria = DataValidationCriteria

Methods

create

  • create(name: string, rows?: number, columns?: number): Spreadsheet

flush

  • flush(): void

getActive

getActiveRange

  • getActiveRange(): Range

getActiveSheet

  • getActiveSheet(): Sheet

getActiveSpreadsheet

getUi

  • getUi(): Ui
  • Returns an instance of the spreadsheet's user-interface environment that allows the script to add features like menus, dialogs, and sidebars.

    Returns Ui

init

  • init(__namedParameters: object): void
  • Initialize Sheet.

    Parameters

    • __namedParameters: object
      • cellValue: undefined | CellValue
      • numColumns: number

        Column dimension size

      • numRows: number

        Row dimension size

    Returns void

newDataValidation

setActiveRange

  • setActiveRange(range: any): Range

setActiveSheet

  • setActiveSheet(sheet: any): Sheet

setActiveSpreadsheet

  • setActiveSpreadsheet(newActiveSpreadsheet: any): void

Legend

  • Module
  • Object literal
  • Variable
  • Function
  • Function with type parameter
  • Index signature
  • Type alias
  • Enumeration
  • Enumeration member
  • Property
  • Method
  • Interface
  • Interface with type parameter
  • Constructor
  • Property
  • Method
  • Index signature
  • Class
  • Class with type parameter
  • Constructor
  • Property
  • Method
  • Accessor
  • Index signature
  • Inherited constructor
  • Inherited property
  • Inherited method
  • Inherited accessor
  • Protected property
  • Protected method
  • Protected accessor
  • Private property
  • Private method
  • Private accessor
  • Static property
  • Static method

Generated using TypeDoc