class Google::Apis::SheetsV4::SheetsService

def get_spreadsheet(spreadsheet_id, exclude_tables_in_banded_ranges: nil, include_grid_data: nil, ranges: 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::Spreadsheet) -

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) --
  • ranges (Array, String) --
  • include_grid_data (Boolean) --
  • exclude_tables_in_banded_ranges (Boolean) --
  • spreadsheet_id (String) --
def get_spreadsheet(spreadsheet_id, exclude_tables_in_banded_ranges: nil, include_grid_data: nil, ranges: nil, fields: nil, quota_user: nil, options: nil, &block)
  command = make_simple_command(:get, 'v4/spreadsheets/{spreadsheetId}', options)
  command.response_representation = Google::Apis::SheetsV4::Spreadsheet::Representation
  command.response_class = Google::Apis::SheetsV4::Spreadsheet
  command.params['spreadsheetId'] = spreadsheet_id unless spreadsheet_id.nil?
  command.query['excludeTablesInBandedRanges'] = exclude_tables_in_banded_ranges unless exclude_tables_in_banded_ranges.nil?
  command.query['includeGridData'] = include_grid_data unless include_grid_data.nil?
  command.query['ranges'] = ranges unless ranges.nil?
  command.query['fields'] = fields unless fields.nil?
  command.query['quotaUser'] = quota_user unless quota_user.nil?
  execute_or_queue_command(command, &block)
end