Enum SheetType
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
工作表类型
电子表格中可以存在的不同类型的页面。
如需调用枚举,您可以调用其父类、名称和属性。例如
SpreadsheetApp.SheetType.GRID
。
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC):2025-07-26。
[null,null,["最后更新时间 (UTC):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). |"]]