Class RangeInfo
RangeInfo represents a rectangle array of cells that may contain formulas, strings, or numbers that may be referenced by other formulas.
Inheritance
Namespace: Syncfusion.XlsIO.Calculate
Assembly: Syncfusion.XlsIO.Portable.dll
Syntax
public class RangeInfo : ObjectConstructors
RangeInfo(Int32, Int32, Int32, Int32)
Constructs a RangeInfo instance with the given top, left, bottom and right values.
Declaration
public RangeInfo(int top, int left, int bottom, int right)Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | top | Top row index of this range. |
| System.Int32 | left | Left column index of this range. |
| System.Int32 | bottom | Bottom row index of this range. |
| System.Int32 | right | Right column index of this range. |
Remarks
The range values must be one-based indexes.
Properties
Bottom
A property that gets/sets the bottom row index of this range.
Declaration
public int Bottom { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
Left
A property that gets/sets the left column index of this range.
Declaration
public int Left { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
Right
A property that gets/sets the right row index of this range.
Declaration
public int Right { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
Top
A property that gets/sets the top row index of this range.
Declaration
public int Top { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
Methods
Cells(Int32, Int32, Int32, Int32)
A method to retrieve a range based on the numeric arguments passed in.
Declaration
public static RangeInfo Cells(int top, int left, int bottom, int right)Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | top | Top row index of this range. |
| System.Int32 | left | Left column index of this range. |
| System.Int32 | bottom | Bottom row index of this range. |
| System.Int32 | right | Right column index of this range. |
Returns
| Type | Description |
|---|---|
| RangeInfo | A RangeInfo object. |
Remarks
The range values must be one-based indexes.
GetAlphaLabel(Int32)
GetAlphaLabel is a method that retrieves a string value for the column whose numerical index is passed in.
Declaration
public static string GetAlphaLabel(int col)Parameters
| Type | Name | Description |
|---|---|---|
| System.Int32 | col | Number index such as 1, 5, 27. |
Returns
| Type | Description |
|---|---|
| System.String | Corresponding alphabets label like A, E, AA. |