Method: Read data from a cell

[cyclops1982]

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	Get Cell Value
Service Object Method Description	Read a value from a single given Cell.
Execution type	Read
Input	SpreadsheetId, Cell
Required Inputs	SpreadsheetId, Cell
Output	EffectiveValueBool, EffectiveValueString, EffectiveValueNumber, EffectiveValueFormula, EffectiveValueDateTime, EffectiveValueDate, EffectiveValueTime, FormattedValue, IsEmpty

Validation / Error handling

1. If the sheet does not exist, then provide the error message: "Spreadsheet '{SpreadsheetId}' does not exist."
2. Depending on the cell type, we would return the correct property filled in. The other properties would remain empty. A cell in a sheet has a type, and this would be mapped to one of the output properties. This allows us to have strongly typed outputs. The FormattedValue will always return the string representation of the cell, unless it is empty.
3. The IsEmtpy is used to indicate if a cell is empty. If IsEmtpy is true, then all other properties should be ignored.

[cyclops1982]

Quick note:
For a cell, we want:

• UserEnteredValue - as string
• EffectiveValueNumber
• EffectiveValueBool
• EffectiveValueString
• EffectiveValueFormula
• EffectiveValueDateTime * nice to have
• EffectiveValueTime * nice to have
• EffectiveValueDate * nice to have
• FormattedValue - as string

Read Cell
Write Cell
Read Column