Enum SheetType
Stay organized with collections
Save and categorize content based on your preferences.
SheetType
The different types of sheets that can exist in a spreadsheet.
To call an enum, you call its parent class, name, and property. For example,
SpreadsheetApp.SheetType.GRID.
Properties
| Property | Type | Description |
GRID | Enum | A sheet containing a grid. This is the default type. |
OBJECT | Enum | A sheet containing a single embedded object such as an EmbeddedChart. |
DATASOURCE | Enum | A sheet containing a DataSource. |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[null,null,["Last updated 2024-12-02 UTC."],[[["\u003cp\u003e\u003ccode\u003eSheetType\u003c/code\u003e defines the different types of sheets within a spreadsheet, including grid, object, and datasource.\u003c/p\u003e\n"],["\u003cp\u003eTo reference a specific sheet type, use the syntax \u003ccode\u003eSpreadsheetApp.SheetType.property\u003c/code\u003e, replacing "property" with the desired type like \u003ccode\u003eGRID\u003c/code\u003e or \u003ccode\u003eOBJECT\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eSheets can contain grids, embedded objects (charts), or serve as datasources.\u003c/p\u003e\n"]]],["SpreadsheetApp's `SheetType` enum defines the possible sheet types within a spreadsheet. These types include `GRID`, representing a standard grid-based sheet; `OBJECT`, a sheet containing an embedded object like a chart; and `DATASOURCE`, a sheet linked to a data source. Enum properties are accessed via `SpreadsheetApp.SheetType.PROPERTY_NAME`. The grid sheet type is set as the default option.\n"],null,["# Enum SheetType\n\nSheetType\n\nThe different types of sheets that can exist in a spreadsheet.\n\nTo call an enum, you call its parent class, name, and property. For example, `\nSpreadsheetApp.SheetType.GRID`. \n\n### Properties\n\n| Property | Type | Description |\n|--------------|--------|----------------------------------------------------------------------------------------------------------------------------|\n| `GRID` | `Enum` | A sheet containing a grid. This is the default type. |\n| `OBJECT` | `Enum` | A sheet containing a single embedded object such as an [EmbeddedChart](/apps-script/reference/spreadsheet/embedded-chart). |\n| `DATASOURCE` | `Enum` | A sheet containing a [DataSource](/apps-script/reference/spreadsheet/data-source). |"]]
