Class: Google::Apis::SheetsV4::Table

Inherits:
Object
  • Object
show all
Includes:
Core::Hashable, Core::JsonObjectSupport
Defined in:
lib/google/apis/sheets_v4/classes.rb,
lib/google/apis/sheets_v4/representations.rb,
lib/google/apis/sheets_v4/representations.rb

Overview

A table.

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(**args) ⇒ Table

Returns a new instance of Table.



9915
9916
9917
# File 'lib/google/apis/sheets_v4/classes.rb', line 9915

def initialize(**args)
   update!(**args)
end

Instance Attribute Details

#column_propertiesArray<Google::Apis::SheetsV4::TableColumnProperties>

The table column properties. Corresponds to the JSON property columnProperties



9881
9882
9883
# File 'lib/google/apis/sheets_v4/classes.rb', line 9881

def column_properties
  @column_properties
end

#nameString

The table name. This is unique to all tables in the same spreadsheet. Corresponds to the JSON property name

Returns:

  • (String)


9886
9887
9888
# File 'lib/google/apis/sheets_v4/classes.rb', line 9886

def name
  @name
end

#rangeGoogle::Apis::SheetsV4::GridRange

A range on a sheet. All indexes are zero-based. Indexes are half open, i.e. the start index is inclusive and the end index is exclusive -- [start_index, end_index). Missing indexes indicate the range is unbounded on that side. For example, if "Sheet1" is sheet ID 123456, then: Sheet1!A1:A1 == sheet_id: 123456, start_row_index: 0, end_row_index: 1, start_column_index: 0, end_column_index: 1 Sheet1!A3:B4 == sheet_id: 123456, start_row_index: 2, end_row_index: 4, start_column_index: 0, end_column_index: 2 Sheet1!A:B == sheet_id: 123456, start_column_index: 0, end_column_index: 2 Sheet1!A5:B == sheet_id: 123456, start_row_index: 4, start_column_index: 0, end_column_index: 2 Sheet1 == sheet_id: 123456 The start index must always be less than or equal to the end index. If the start index equals the end index, then the range is empty. Empty ranges are typically not meaningful and are usually rendered in the UI as #REF!. Corresponds to the JSON property range



9903
9904
9905
# File 'lib/google/apis/sheets_v4/classes.rb', line 9903

def range
  @range
end

#rows_propertiesGoogle::Apis::SheetsV4::TableRowsProperties

The table row properties. Corresponds to the JSON property rowsProperties



9908
9909
9910
# File 'lib/google/apis/sheets_v4/classes.rb', line 9908

def rows_properties
  @rows_properties
end

#table_idString

The id of the table. Corresponds to the JSON property tableId

Returns:

  • (String)


9913
9914
9915
# File 'lib/google/apis/sheets_v4/classes.rb', line 9913

def table_id
  @table_id
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



9920
9921
9922
9923
9924
9925
9926
# File 'lib/google/apis/sheets_v4/classes.rb', line 9920

def update!(**args)
  @column_properties = args[:column_properties] if args.key?(:column_properties)
  @name = args[:name] if args.key?(:name)
  @range = args[:range] if args.key?(:range)
  @rows_properties = args[:rows_properties] if args.key?(:rows_properties)
  @table_id = args[:table_id] if args.key?(:table_id)
end