Method: Write data to a sheet #7
Description
This should provide the ability for the value of a single cell to be returned.
Method Details
| Property | Value |
|---|---|
| Service Object Name | Cell (See #5) |
| Service Object Method Name | Write Cell Value |
| Service Object Method Description | Write a single value from a single given Cell. |
| Execution type | Update |
| Input | SpreadSheetId, Cell, EffectiveValueBool, EffectiveValueString, EffectiveValueNumber, EffectiveValueFormula, EffectiveValueDateTime, EffectiveValueDate, EffectiveValueTime, IsEmpty |
| Required Inputs | Sheet Id, Cell, IsEmtpy |
| Output | FormattedValue, IsEmpty |
Validation / Error handling
- If the SpreadSheetId does not exist, then provide the error message: "Spreadsheet '{SpreadSheetId}' does not exist."
- The IsEmtpy is used to indicate if a cell should be cleared or not. If true is provided, the cell will be cleared.
- If IsEmpty is false, then the cell needs to be set and at LEAST one of the EffectiveValue properties needs to be set. If IsEmpty is False and NO effectiveValue is provided, the following error must be shown: "Need a value if the cell is not empty."
- Only one EffectiveValue property can be filled in. If multiple are filled the following error should be shown "Multiple values supplied. Please provide only one value."
- When setting the value, the type of the cell must also be set based on which property is set.