class Google::Apis::SheetsV4::SheetsService

def update_spreadsheet_value(spreadsheet_id, range, value_range_object = nil, include_values_in_response: nil, response_date_time_render_option: nil, response_value_render_option: nil, value_input_option: nil, fields: nil, quota_user: nil, options: nil, &block)

Raises:
  • (Google::Apis::AuthorizationError) - Authorization is required
  • (Google::Apis::ClientError) - The request is invalid and should not be retried without modification
  • (Google::Apis::ServerError) - An error occurred on the server and the request can be retried

Returns:
  • (Google::Apis::SheetsV4::UpdateValuesResponse) -

Other tags:
    Yieldparam: err - error object if request failed
    Yieldparam: result - parsed result object

Other tags:
    Yield: - Result & error if block supplied

Parameters:
  • options (Google::Apis::RequestOptions) --
  • quota_user (String) --
  • fields (String) --
  • value_input_option (String) --
  • response_value_render_option (String) --
  • response_date_time_render_option (String) --
  • include_values_in_response (Boolean) --
  • value_range_object (Google::Apis::SheetsV4::ValueRange) --
  • range (String) --
  • spreadsheet_id (String) --
def update_spreadsheet_value(spreadsheet_id, range, value_range_object = nil, include_values_in_response: nil, response_date_time_render_option: nil, response_value_render_option: nil, value_input_option: nil, fields: nil, quota_user: nil, options: nil, &block)
  command = make_simple_command(:put, 'v4/spreadsheets/{spreadsheetId}/values/{range}', options)
  command.request_representation = Google::Apis::SheetsV4::ValueRange::Representation
  command.request_object = value_range_object
  command.response_representation = Google::Apis::SheetsV4::UpdateValuesResponse::Representation
  command.response_class = Google::Apis::SheetsV4::UpdateValuesResponse
  command.params['spreadsheetId'] = spreadsheet_id unless spreadsheet_id.nil?
  command.params['range'] = range unless range.nil?
  command.query['includeValuesInResponse'] = include_values_in_response unless include_values_in_response.nil?
  command.query['responseDateTimeRenderOption'] = response_date_time_render_option unless response_date_time_render_option.nil?
  command.query['responseValueRenderOption'] = response_value_render_option unless response_value_render_option.nil?
  command.query['valueInputOption'] = value_input_option unless value_input_option.nil?
  command.query['fields'] = fields unless fields.nil?
  command.query['quotaUser'] = quota_user unless quota_user.nil?
  execute_or_queue_command(command, &block)
end