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