Service Object: Cell #5
Description
This item describes the service object properties for the Cell service object.
| Property Name | Property DisplayName | Type | Description |
|---|---|---|---|
| spreadsheetId | Spreadsheet Id | Text | The google drive ID of the spreadsheet file. |
| CellId | Cell Name | Text | The cell name, in the format "Sheet1!A1". Only one cell can be provided. |
| EffectiveValueBool | Boolean Value | YesNo | The true/false value of the field if it is a boolean cell. |
| EffectiveValueString | Text Value | Text | The text value of the field if it is a text cell. |
| EffectiveValueNumber | Number Value | Number | The number value of the field if it is a number cell. |
| EffectiveValueFormula | Formula Value | Memo | The Formula of the field if it is a formula cell. |
| EffectiveValueDateTime | DateTime Value | DateTime | The date and time of the field if it is a datetime cell. |
| EffectiveValueDate | Date Value | Date | The Date of the field if it is a date cell. |
| EffectiveValueTime | Time Value | Time | The Time of the field if it is a time cell. |
| FormattedValue | Formatted Value | Text | The text representation of the cell |
| IsEmpty | Is Empty | YesNo | Indicates if the cell is empty, or could not be found. |