# IRange Interface Members

The following tables list the members exposed by IRange.

Public Properties

Name | Description | |
---|---|---|

Address | Gets the Range reference in macro language. Read-only. | |

AddressGlobal | Gets the Range reference along with its sheet name in format "'Sheet1'!$A$1". Read-only. | |

AddressLocal | Gets the Range reference in language of the user. Read-only. | |

AddressR1C1 | Gets the Range reference along with sheet name using R1C1-style notation. Read-only. | |

AddressR1C1Local | Gets the Range reference using R1C1-style notation. Read-only. | |

Application | Gets the application object. (Inherited from Syncfusion.XlsIO.IParentApplication) | |

Boolean | Gets or sets boolean value in the Range. | |

Borders | Gets a IBorders collection that represents the borders of a style in the Range. Read-only. | |

BuiltInStyle | Gets or sets built in style in the Range. | |

CalculatedValue | Gets the calculated value of a formula in the Range. Read-only. | |

Cells | Gets a IRange object that represents the cells in the Range. Read-only. | |

CellStyle | Gets a IStyle object that represents the style of the Range. | |

CellStyleName | Gets name of the IStyle object that represents style of the Range. | |

Column | Gets the column index of the first column in the Range which is a one based index. Read-only. | |

ColumnGroupLevel | Gets column group level of the Range. Read-only. | |

Columns | Gets an array of IRange objects that represent the columns in the Range. Read only. | |

ColumnWidth | Gets or sets the width of all columns in the specified range, measured in points. | |

Comment | Gets a ICommentShape object that represents the comment associated with the range. Read-only. | |

ConditionalFormats | Gets the collection of conditional formats in the Range. Read-only. | |

Count | Gets the number of cells in the Range. Read-only. | |

DataValidation | Gets a IDataValidation object that represents the data validation associated with the cell. Read-only. | |

DateTime | Gets or sets DateTime value in the Range. | |

DisplayText | Gets cell value with its number format. Read-only. | |

End | Gets a IRange object that represents the cell at the end of the Range. | |

EntireColumn | Gets a IRange object that represents the entire column (or columns) in the Range. Read-only. | |

EntireRow | Gets a IRange object that represents the entire row (or rows) in the Range. Read-only. | |

Error | Gets or sets error value in the Range. | |

Formula | Gets or sets the formula in A1-style notation and in macro language for the Range. | |

FormulaArray | Gets or sets sets the array formula of a range which can perform multiple calculations on one or more of the items in an array. | |

FormulaArrayR1C1 | Gets or sets the formula array for the Range, using R1C1-style notation. | |

FormulaBoolValue | Gets or sets the calculated value of the formula as a boolean. | |

FormulaDateTime | Gets or sets formula DateTime value in the Range. | |

FormulaErrorValue | Gets or sets the error value of the formula as a string. | |

FormulaHidden | Gets or sets a Boolean value indicating whether the formula will be hidden when the worksheet is protected. | |

FormulaNumberValue | Gets or sets number value evaluated by formula. | |

FormulaR1C1 | Gets or sets the formula for the Range, using R1C1-style notation. | |

FormulaStringValue | Gets or sets string value evaluated by formula. | |

HasBoolean | Gets a Boolean value indicating whether Range contains bool value. Read-only. | |

HasDataValidation | Gets a Boolean value indicating whether Range has data validation. Read-only. | |

HasDateTime | Gets a Boolean value indicating whether Range contains DateTime value. Read-only. | |

HasExternalFormula | Gets a Boolean value indicating whether Range has external formula. Read-only. | |

HasFormula | Gets a Boolean value indicating whether Range contains formula. Read-only. | |

HasFormulaArray | Gets a Boolean value indicating whether Range contains array-entered formula. Read-only. | |

HasFormulaBoolValue | Gets a Boolean value indicating whether Range has formula bool value. Read-only. | |

HasFormulaDateTime | Gets a Boolean value indicating whether Range has formula value formatted as DateTime. Read-only. | |

HasFormulaErrorValue | Gets a Boolean value indicating whether Range has formula error value. Read-only. | |

HasFormulaNumberValue | Gets a Boolean value indicating whether Range has formula number value. Read-only. | |

HasFormulaStringValue | Gets a Boolean value indicating whether Range has formula string value. Read-only. | |

HasNumber | Gets a Boolean value indicating whether Range contains number. Read-only. | |

HasRichText | Gets a Boolean value indicating whether cell contains formatted rich text string. | |

HasString | Gets a Boolean value indicating whether Range contains string. Read-only. | |

HasStyle | Gets a Boolean value indicating whether Range has default style. False means default style. Read-only. | |

HorizontalAlignment | Gets or sets the horizontal alignment for the specified object. | |

HtmlString | Gets or sets HTML string. | |

Hyperlinks | Gets hyperlinks in the Range. Read-only. | |

IgnoreErrorOptions | Gets or sets ignore error options for formula auditing. If not single cell gets concatenated flags. | |

IndentLevel | Gets or sets the indent level for cell or Range. | |

IsBlank | Gets a Boolean value indicating whether the Range is blank. Read-only. | |

IsBoolean | Gets a Boolean value indicating whether cell type is boolean. Read-only. | |

IsError | Gets a Boolean value indicating whether Range contains error value. Read-only. | |

IsGroupedByColumn | Gets a Boolean value indicating whether Range is grouped by column. Read-only. | |

IsGroupedByRow | Gets a Boolean value indicating whether Range is grouped by row. Read-only. | |

IsInitialized | Gets a Boolean value indicating whether cell is initialized. Read-only. | |

IsMerged | Gets a Boolean value indicating whether Range is a part of merged Range. Read-only. | |

IsStringsPreserved | Gets a Boolean value indicating whether all values in the Range are preserved as strings. | |

Item | Overloaded. Gets or sets cell range by row and column index. Row and column indexes are one-based. | |

LastColumn | Gets the column index of the last column in the Range which is a one based index. Read-only. | |

LastRow | Gets the row index of the last row in the Range which is a one based index. Read-only. | |

MergeArea | Gets a IRange object that represents the merged Range to which the cell or Range belongs. Read-only. | |

Number | Gets or sets number value that is contained by Range. | |

NumberFormat | Gets or sets format of cell which is similar to Style.NumberFormat property. | |

Parent | Gets the parent object. (Inherited from Syncfusion.XlsIO.IParentApplication) | |

RichText | Gets string with rich text formatting in the Range. Read-only. | |

Row | Gets the row index of the first row in the Range which is a one based index. Read-only. | |

RowGroupLevel | Gets row group level. Read-only. | |

RowHeight | Gets or sets the height of all the rows in the range, measured in points. | |

Rows | Gets an array of IRange objects that represent the rows in the Range. Read only. | |

Text | Gets or sets string value of the Range. | |

TimeSpan | Gets or sets time value of the Range. | |

Value | Gets or sets the value of the Range. Does not support FormulaArray value. | |

Value2 | Gets or sets the cell value. | |

VerticalAlignment | Gets or sets the vertical alignment of the Range. | |

Worksheet | Gets the IWorksheet object in which belongs to the Range. Read-only. | |

WrapText | Gets or sets wrap text of the Range. |

Public Methods

Name | Description | |
---|---|---|

Activate | Overloaded. Activates the cell. | |

AddComment | Adds a comment. | |

AutofitColumns | Changes the width of the columns in the range to achieve the best fit. | |

AutofitRows | Changes the height of the rows in the range to achieve the best fit. | |

BorderAround | Overloaded. Applies border around the Range. The default line style is ExcelLineStyle.Thin. | |

BorderInside | Overloaded. Applies border inside the Range. The default line style is ExcelLineStyle.Thin. | |

BorderNone | Applies no border in the Range. | |

Clear | Overloaded. Clears content in the Range. | |

CollapseGroup | Collapses the group by rows/columns. | |

CopyTo | Overloaded. Copies the Range to the specified Range (without updating formulas). | |

ExpandGroup | Overloaded. Expands the group by rows/columns. | |

FindAll | Overloaded. Returns the cells with a specified string value and ExcelFindType. | |

FindFirst | Overloaded. Returns the first occurrence cell with the specified string value and ExcelFindType. | |

FreezePanes | Keep rows and columns visible in the Range while the rest of the worksheet scrolls. | |

GetDependents | Overloaded. Gets the dependent cells which refer to other cells. | |

GetEnumerator | (Inherited from System.Collections.Generic.IEnumerable<IRange>) | |

GetPrecedents | Overloaded. Gets the precedent cells which are referred by a formula in another cell. | |

Group | Overloaded. Groups the Range by row/column. | |

IntersectWith | Returns intersection of the Range with specified Range. | |

Merge | Overloaded. Combines the contents of the selected cells in a new larger cell. | |

MergeWith | Merges the range with specified range and returns merged range. | |

MoveTo | Moves cells to the specified Range (without updating formulas). | |

Offset | Returns a IRange object that represents a range that�s offset from the specified range. | |

Resize | Resizes the specified range a IRange object that represents the resized range. | |

SubTotal | Overloaded. Creates subtotals for the Range. | |

Ungroup | Ungroups the Range. | |

UnMerge | Separates merged cells into individual cells. |

Extension Methods

Name | Description | |
---|---|---|

ConvertExcelRangeToGridRange | Overloaded. Coverts the excel range to the corresponding grid range. | |

ConvertExcelRangeToGridRange | Overloaded. | |

DistinctBy<TSource,TKey> | ||

ForEach | Overloaded. Iterates over an IEnumerable instance to a delegated function | |

ToList<T> | Iterates over a IEnumberable and returns an item from collection. |

See Also