Stay organized with collectionsSave and categorize content based on your preferences.
ValueType
An enumeration of value types returned byRange.getValue()andRange.getValues()from the Range class of the Spreadsheet service. The enumeration values
listed below are in addition toNumber,Boolean,Date, orString.
To call an enum, you call its parent class, name, and property. For example,SpreadsheetApp.ValueType.IMAGE.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["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. |"]]
