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.
10865 10866 10867 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 10865 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
10812 10813 10814 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 10812 def bottom @bottom end |
#inner_horizontal ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
Corresponds to the JSON property innerHorizontal
10817 10818 10819 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 10817 def inner_horizontal @inner_horizontal end |
#inner_vertical ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
Corresponds to the JSON property innerVertical
10822 10823 10824 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 10822 def inner_vertical @inner_vertical end |
#left ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
Corresponds to the JSON property left
10827 10828 10829 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 10827 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
10853 10854 10855 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 10853 def range @range end |
#right ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
Corresponds to the JSON property right
10858 10859 10860 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 10858 def right @right end |
#top ⇒ Google::Apis::SheetsV4::Border
A border along a cell.
Corresponds to the JSON property top
10863 10864 10865 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 10863 def top @top end |
Instance Method Details
#update!(**args) ⇒ Object
Update properties of this object
10870 10871 10872 10873 10874 10875 10876 10877 10878 |
# File 'generated/google/apis/sheets_v4/classes.rb', line 10870 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 |