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

Inheritance

object

GridRange

Implements

IDirectResponseSchema

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Google.Apis.Sheets.v4.Data

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public class GridRange : IDirectResponseSchema

Properties

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
string

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
int?

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
int?

SheetId

The sheet this range is on.

Declaration

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

Property Value

Type	Description
int?

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
int?

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
int?

Implements

IDirectResponseSchema