Class 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!.

Inheritance

System.Object

GridRange

Implements

Google.Apis.Requests.IDirectResponseSchema

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Google.Apis.Sheets.v4.Data

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public class GridRange : IDirectResponseSchema

Properties

EndColumnIndex

The end column (exclusive) of the range, or not set if unbounded.

Declaration

[JsonProperty("endColumnIndex")]
public virtual int? EndColumnIndex { get; set; }

Property Value

Type	Description
System.Nullable<System.Int32>

EndRowIndex

The end row (exclusive) of the range, or not set if unbounded.

Declaration

[JsonProperty("endRowIndex")]
public virtual int? EndRowIndex { get; set; }

Property Value

Type	Description
System.Nullable<System.Int32>

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
System.String

SheetId

The sheet this range is on.

Declaration

[JsonProperty("sheetId")]
public virtual int? SheetId { get; set; }

Property Value

Type	Description
System.Nullable<System.Int32>

StartColumnIndex

The start column (inclusive) of the range, or not set if unbounded.

Declaration

[JsonProperty("startColumnIndex")]
public virtual int? StartColumnIndex { get; set; }

Property Value

Type	Description
System.Nullable<System.Int32>

StartRowIndex

The start row (inclusive) of the range, or not set if unbounded.

Declaration

[JsonProperty("startRowIndex")]
public virtual int? StartRowIndex { get; set; }

Property Value

Type	Description
System.Nullable<System.Int32>

Implements

Google.Apis.Requests.IDirectResponseSchema