Enum SheetType
透過集合功能整理內容
你可以依據偏好儲存及分類內容。
試算表類型
試算表中可存在的不同工作表類型。
如要呼叫列舉,請呼叫其父項類別、名稱和屬性。例如
SpreadsheetApp.SheetType.GRID
。
除非另有註明,否則本頁面中的內容是採用創用 CC 姓名標示 4.0 授權,程式碼範例則為阿帕契 2.0 授權。詳情請參閱《Google Developers 網站政策》。Java 是 Oracle 和/或其關聯企業的註冊商標。
上次更新時間:2025-07-26 (世界標準時間)。
[null,null,["上次更新時間:2025-07-26 (世界標準時間)。"],[[["\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). |"]]