gsheet_update_ss_values: Execute Google Sheets Method 'spreadsheets.values.update'

Description Usage Arguments Value

Description

[v4 API Doc](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/update)

Usage

1
2
3
4
5
6
gsheet_update_ss_values(spreadsheet_id, value_range,
  value_input_option = "USER_ENTERED",
  include_values_in_response = FALSE,
  response_value_render_option = "FORMATTED_VALUE",
  response_date_time_render_option = "SERIAL_NUMBER",
  simplify_vector = FALSE)

Arguments

spreadsheet_id

atomic character vector length 1; The ID of the spreadsheet to update.

value_range

ValueRange object; to be passed to value request body

value_input_option

atomic character length 1; How the input data should be interpreted.

include_values_in_response

atomic logical length 1; 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 than the range actually written, the response will include all values in the requested range (excluding trailing empty rows and columns).

response_value_render_option

atomic character length 1; Determines how values in the response should be rendered. The default render option is ValueRenderOption.FORMATTED_VALUE.

response_date_time_render_option

atomic character length 1; 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 [DateTimeRenderOption.SERIAL_NUMBER].

simplify_vector

passed to jsonlite::fromJSON, defaults to FALSE

Value

update_values_response object (list)


bradgwest/googleSheetsR documentation built on May 16, 2019, 3:07 p.m.