SpreadsheetApp

Value Members

1. final def !=(arg0: Any): Boolean

   

   Definition Classes

   AnyRef → Any

2. final def ##(): Int

   

   Definition Classes

   AnyRef → Any

3. final def ==(arg0: Any): Boolean

   

   Definition Classes

   AnyRef → Any

4. final def asInstanceOf[T0]: T0

   

   Definition Classes

   Any

5. def clone(): AnyRef

   

   Attributes

   protected[java.lang]

   Definition Classes

   AnyRef

   Annotations

   @throws( ... )

6. def create(name: String, rows: Int, columns: Int): Spreadsheet

   

   Creates a new spreadsheet with the given name and the specified number of rows and columns.

7. def create(name: String): Spreadsheet

   

   Creates a new spreadsheet with the given name.

8. final def eq(arg0: AnyRef): Boolean

   

   Definition Classes

   AnyRef

9. def equals(arg0: Any): Boolean

   

   Definition Classes

   AnyRef → Any

10. def finalize(): Unit

    

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

    @throws( classOf[java.lang.Throwable] )

11. def flush(): Unit

    

    Applies all pending Spreadsheet changes.

    Applies all pending Spreadsheet changes. Spreadsheet operations are sometimes bundled together to improve performance, such as when doing multiple calls to Range.getValue(). However, sometimes you may want to make sure that all pending changes are made right away, for instance to show users data as a script is executing.

12. def getActive(): Spreadsheet

    

    Returns the currently active spreadsheet, or null if there is none.

    Returns the currently active spreadsheet, or null if there is none. Functions that are run in the context of a spreadsheet can get a reference to the corresponding Spreadsheet object by calling this function.

13. def getActiveRange(): Range

    

    Returns the range of cells that is currently considered active.

    Returns the range of cells that is currently considered active. This generally means the range that a user has selected in the active sheet, but in a custom function it refers to the cell being actively recalculated.

14. def getActiveSheet(): Sheet

    

    Gets the active sheet in a spreadsheet.

    Gets the active sheet in a spreadsheet. The active sheet in a spreadsheet is the sheet that is being displayed in the spreadsheet UI.

15. def getActiveSpreadsheet(): Spreadsheet

    

    Returns the currently active spreadsheet, or null if there is none.

    Returns the currently active spreadsheet, or null if there is none. Functions that are run in the context of a spreadsheet can get a reference to the corresponding Spreadsheet object by calling this function.

16. final def getClass(): Class[_]

    

    Definition Classes

    AnyRef → Any

17. def 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 an instance of the spreadsheet's user-interface environment that allows the script to add features like menus, dialogs, and sidebars. A script can only interact with the UI for the current instance of an open spreadsheet, and only if the script is bound to the spreadsheet. For more information, see the guides to menus and dialogs and sidebars.

18. def hasOwnProperty(v: String): Boolean

    

    Definition Classes

    Object

19. def hashCode(): Int

    

    Definition Classes

    AnyRef → Any

20. final def isInstanceOf[T0]: Boolean

    

    Definition Classes

    Any

21. def isPrototypeOf(v: Object): Boolean

    

    Definition Classes

    Object

22. final def ne(arg0: AnyRef): Boolean

    

    Definition Classes

    AnyRef

23. def newDataValidation(): DataValidationBuilder

    

    Creates a builder for a data-validation rule.

24. final def notify(): Unit

    

    Definition Classes

    AnyRef

25. final def notifyAll(): Unit

    

    Definition Classes

    AnyRef

26. def open(file: File): Spreadsheet

    

    Opens the spreadsheet that corresponds to the given File object.

27. def openById(id: String): Spreadsheet

    

    Opens the spreadsheet with the given ID.

    Opens the spreadsheet with the given ID. A spreadsheet ID can be extracted from its URL. For example, the spreadsheet ID in the URL https://docs.google.com/spreadsheets/d/abc1234567/edit#gid=0 is "abc1234567".

28. def openByUrl(url: String): Spreadsheet

    

    Opens the spreadsheet with the given url.

29. def propertyIsEnumerable(v: String): Boolean

    

    Definition Classes

    Object

30. def setActiveRange(range: Range): Range

    

    Sets the active range for the application.

    Sets the active range for the application. The spreadsheet UI will display the sheet that contains the chosen range and will select the cells defined in the chosen range.

31. def setActiveSheet(sheet: Sheet): Sheet

    

    Sets the active sheet in a spreadsheet.

    Sets the active sheet in a spreadsheet. The spreadsheet UI will display the chosen sheet unless the sheet belongs to a different spreadsheet.

32. def setActiveSpreadsheet(newActiveSpreadsheet: Spreadsheet): Unit

    

    Sets the active spreadsheet.

33. final def synchronized[T0](arg0: ⇒ T0): T0

    

    Definition Classes

    AnyRef

34. def toLocaleString(): String

    

    Definition Classes

    Object

35. def toString(): String

    

    Definition Classes

    AnyRef → Any

36. def valueOf(): Any

    

    Definition Classes

    Object

37. final def wait(): Unit

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

38. final def wait(arg0: Long, arg1: Int): Unit

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

39. final def wait(arg0: Long): Unit

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )