gsheets.updatevaluesprops
Home > @runlightyear/gsheets > UpdateValuesProps
UpdateValuesProps interface
Signature:interface UpdateValuesProps
Required Properties
| Property | Modifiers | Type | Description |
|---|---|---|---|
| range | string | The A1 notation of the values to update. | |
| spreadsheetId | string | The ID of the spreadsheet to update. | |
| valueInputOption | ValueInputOption | How the input data should be interpreted. | |
| valueRange | ValueRange | The values to update |
Optional Properties
| Property | Modifiers | Type | Description |
|---|---|---|---|
| includeValuesInResponse? | boolean | Determines if the update response should include the values of the cells that were updated. By default, responses do not include the updated values. If the range to write was larger than the range actually written, the response includes all values in the requested range (excluding trailing empty rows and columns). | |
| responseDateTimeRenderOption? | DateTimeRenderOption | Determines how dates, times, and durations in the response should be rendered. This is ignored if responseValueRenderOption is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. | |
| responseValueRenderOption? | ValueRenderOption | Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE. |