Class: Google::Apis::SheetsV4::UpdateBordersRequest
- Inherits:
-
Object
- Object
- Google::Apis::SheetsV4::UpdateBordersRequest
- Includes:
- Core::Hashable, Core::JsonObjectSupport
- Defined in:
- generated/google/apis/sheets_v4/classes.rb,
generated/google/apis/sheets_v4/representations.rb,
generated/google/apis/sheets_v4/representations.rb
Overview
Updates the borders of a range. If a field is not set in the request, that means the border remains as-is. For example, with two subsequent UpdateBordersRequest:
- range: A1:A5
top: RED, bottom: WHITE
- range: A1:A5
left: BLUE
That would result in A1:A5 having a borders oftop: RED, bottom: WHITE, left: BLUE
. If you want to clear a border, explicitly set the style to NONE.
Instance Attribute Summary collapse
-
#bottom ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
-
#inner_horizontal ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
-
#inner_vertical ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
-
#left ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
-
#range ⇒ Google::Apis::SheetsV4::GridRange
A range on a sheet.
-
#right ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
-
#top ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
Instance Method Summary collapse
-
#initialize(**args) ⇒ UpdateBordersRequest
constructor
A new instance of UpdateBordersRequest.
-
#update!(**args) ⇒ Object
Update properties of this object.
Methods included from Core::JsonObjectSupport
Methods included from Core::Hashable
Constructor Details
#initialize(**args) ⇒ UpdateBordersRequest
Returns a new instance of UpdateBordersRequest
9418 9419 9420 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 9418 def initialize(**args) update!(**args) end |
Instance Attribute Details
#bottom ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
Corresponds to the JSON property bottom
9365 9366 9367 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 9365 def bottom @bottom end |
#inner_horizontal ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
Corresponds to the JSON property innerHorizontal
9370 9371 9372 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 9370 def inner_horizontal @inner_horizontal end |
#inner_vertical ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
Corresponds to the JSON property innerVertical
9375 9376 9377 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 9375 def inner_vertical @inner_vertical end |
#left ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
Corresponds to the JSON property left
9380 9381 9382 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 9380 def left @left end |
#range ⇒ Google::Apis::SheetsV4::GridRange
A range on a sheet.
All indexes are zero-based.
Indexes are half open, e.g 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 0, then:
Sheet1!A1:A1 == sheet_id: 0,
start_row_index: 0, end_row_index: 1,
start_column_index: 0, end_column_index: 1
Sheet1!A3:B4 == sheet_id: 0,
start_row_index: 2, end_row_index: 4,
start_column_index: 0, end_column_index: 2
Sheet1!A:B == sheet_id: 0,
start_column_index: 0, end_column_index: 2
Sheet1!A5:B == sheet_id: 0,
start_row_index: 4,
start_column_index: 0, end_column_index: 2
Sheet1 == sheet_id:0
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
9406 9407 9408 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 9406 def range @range end |
#right ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
Corresponds to the JSON property right
9411 9412 9413 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 9411 def right @right end |
#top ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
Corresponds to the JSON property top
9416 9417 9418 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 9416 def top @top end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
9423 9424 9425 9426 9427 9428 9429 9430 9431 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 9423 def update!(**args) @bottom = args[:bottom] if args.key?(:bottom) @inner_horizontal = args[:inner_horizontal] if args.key?(:inner_horizontal) @inner_vertical = args[:inner_vertical] if args.key?(:inner_vertical) @left = args[:left] if args.key?(:left) @range = args[:range] if args.key?(:range) @right = args[:right] if args.key?(:right) @top = args[:top] if args.key?(:top) end |