Class ReferredArea
Contents
[
Hide
]ReferredArea class
Represents a referred area by the formula.
public class ReferredArea
Properties
| Name | Description |
|---|---|
| EndColumn { get; } | The end column of the area. |
| EndRow { get; } | The end row of the area. |
| ExternalFileName { get; } | Get the external file name if this is an external reference. |
| IsArea { get; } | Indicates whether this is an area. |
| IsEntireColumn { get; } | Indicates whether this area contains all rows(entire column). |
| IsEntireRow { get; } | Indicates whether this area contains all columns(entire row). |
| IsExternalLink { get; } | Indicates whether this is an external link. |
| SheetName { get; } | Indicates which sheet this reference is in. |
| SheetNames { get; } | Names of all the worksheets this instance references to. |
| StartColumn { get; } | The start column of the area. |
| StartRow { get; } | The start row of the area. |
Methods
| Name | Description |
|---|---|
| GetValue(int, int) | Gets cell value with given offset from the top-left of this area. |
| GetValue(int, int, bool) | Gets cell value with given offset from the top-left of this area. |
| GetValues() | Gets cell values in this area. |
| GetValues(bool) | Gets cell values in this area. |
| override ToString() | Returns the reference address of this area. Generally it is the address of the reference which may be used in formula, such as “Sheet1!A1:C3”. |
See Also
- namespace Aspose.Cells
- assembly Aspose.Cells
