Enum ValueType
Stay organized with collections
Save and categorize content based on your preferences.
ValueType
An enumeration of value types returned by Range.getValue() and Range.getValues() from the Range class of the Spreadsheet service. The enumeration values
listed below are in addition to Number, Boolean, Date, or String.
To call an enum, you call its parent class, name, and property. For example,
SpreadsheetApp.ValueType.IMAGE.
Properties
| Property | Type | Description |
IMAGE | Enum | The value type when the cell contains an image. |
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\u003eValueType\u003c/code\u003e is an enumeration used to identify the type of data returned by \u003ccode\u003egetValue()\u003c/code\u003e and \u003ccode\u003egetValues()\u003c/code\u003e methods of the \u003ccode\u003eRange\u003c/code\u003e class in Google Apps Script.\u003c/p\u003e\n"],["\u003cp\u003eBesides common types like \u003ccode\u003eNumber\u003c/code\u003e, \u003ccode\u003eBoolean\u003c/code\u003e, \u003ccode\u003eDate\u003c/code\u003e, or \u003ccode\u003eString\u003c/code\u003e, it includes specific types like \u003ccode\u003eIMAGE\u003c/code\u003e to indicate an image in a cell.\u003c/p\u003e\n"],["\u003cp\u003eTo refer to a specific value type, use the syntax: \u003ccode\u003eSpreadsheetApp.ValueType.PROPERTY\u003c/code\u003e, for example, \u003ccode\u003eSpreadsheetApp.ValueType.IMAGE\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# Enum ValueType\n\nValueType\n\nAn enumeration of value types returned by [Range.getValue()](/apps-script/reference/spreadsheet/range#getValue()) and [Range.getValues()](/apps-script/reference/spreadsheet/range#getValues()) from the Range class of the Spreadsheet service. The enumeration values\nlisted below are in addition to `Number`, `Boolean`, `Date`, or `String`.\n\nTo call an enum, you call its parent class, name, and property. For example, `\nSpreadsheetApp.ValueType.IMAGE`. \n\n### Properties\n\n| Property | Type | Description |\n|----------|--------|-------------------------------------------------|\n| `IMAGE` | `Enum` | The value type when the cell contains an image. |"]]
