Class GridRange
Inheritance
Inherited Members
Namespace: StansAssets.GoogleDoc
Assembly: cs.temp.dll.dll
Syntax
public class GridRange
Constructors
GridRange()
Declaration
public GridRange()
GridRange(Int32, Int32, Int32)
A range on a sheet. All indexes are zero-based. Start and end index is inclusive.
Declaration
public GridRange(int start, int end, int direction = 0)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | start | start of range |
System.Int32 | end | end of range |
System.Int32 | direction | the direction is 0 - rows, otherwise 1 - columns; default is 0 |
GridRange(Int32, Int32, Int32, Int32)
A range on a sheet. All indexes are zero-based. Start and end index is inclusive.
Declaration
public GridRange(int startRowIndex, int startColumnIndex, int endRowIndex, int endColumnIndex)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | startRowIndex | number of first row |
System.Int32 | startColumnIndex | number of first column |
System.Int32 | endRowIndex | number of last row |
System.Int32 | endColumnIndex | number of column column |
GridRange(String)
A range on a sheet. All indexes are zero-based. Start and end index is inclusive. Attention: When transferring information, the site api ignores empty cells (but the lines remain unchanged, even if all its cells are empty). Therefore, the reference to the cell name will differ from the name on the site (for the cell name to match the name on the site, the table must be filled with data without blank cells)
Example-
- A1:B2
- A:B
- 1:2
Declaration
public GridRange(string name)
Parameters
Type | Name | Description |
---|---|---|
System.String | name | The name of the range |
Properties
EndColumnIndex
The end column of the range, property are zero-based or null if unbounded.
Declaration
public int? EndColumnIndex { get; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Int32> |
EndRowIndex
The end row of the range, property are zero-based or null if unbounded.
Declaration
public int? EndRowIndex { get; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Int32> |
Name
Name of the range. For example A1:B2, A:B, 1:2, etc.
Declaration
public string Name { get; }
Property Value
Type | Description |
---|---|
System.String |
StartColumnIndex
The start column of the range, property are zero-based or null if unbounded.
Declaration
public int? StartColumnIndex { get; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Int32> |
StartRowIndex
The start row of the range, property are zero-based or null if unbounded.
Declaration
public int? StartRowIndex { get; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Int32> |