Mantenha tudo organizado com as coleções
Salve e categorize o conteúdo com base nas suas preferências.
Tipo de valor
Uma enumeração de tipos de valor retornados por Range.getValue() e Range.getValues() da classe Range do serviço Planilha. Os valores de enumeração
listados abaixo são adicionais a Number, Boolean, Date ou String.
Para chamar um tipo enumerado, chame a classe mãe, o nome e a propriedade dele. Por exemplo,
SpreadsheetApp.ValueType.IMAGE.
Propriedades
Propriedade
Tipo
Descrição
IMAGE
Enum
O tipo de valor quando a célula contém uma imagem.
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Não contém as informações de que eu preciso","missingTheInformationINeed","thumb-down"],["Muito complicado / etapas demais","tooComplicatedTooManySteps","thumb-down"],["Desatualizado","outOfDate","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Problema com as amostras / o código","samplesCodeIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 2025-07-26 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. |"]]
