IMigrantRange Interface Members
The following tables list the members exposed by IMigrantRange.
Public Properties
| Name | Description | |
|---|---|---|
 | Address | Gets the Range reference in macro language. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| AddressGlobal | Gets the Range reference along with its sheet name in format "'Sheet1'!$A$1". Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| AddressLocal | Gets the Range reference in language of the user. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| AddressR1C1 | Gets the Range reference along with sheet name using R1C1-style notation. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| AddressR1C1Local | Gets the Range reference using R1C1-style notation. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| Application | Gets the application object. (Inherited from Syncfusion.XlsIO.IParentApplication) |
| Boolean | Gets or sets boolean value in the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| Borders | Gets a IBorders collection that represents the borders of a style in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| BuiltInStyle | Gets or sets built in style in the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| CalculatedValue | Gets the calculated value of a formula in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| Cells | Gets a IRange object that represents the cells in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| CellStyle | Gets a IStyle object that represents the style of the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| CellStyleName | Gets name of the IStyle object that represents style of the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| Column | Gets the column index of the first column in the Range which is a one based index. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| ColumnGroupLevel | Gets column group level of the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| Columns | Gets an array of IRange objects that represent the columns in the Range. Read only. (Inherited from Syncfusion.XlsIO.IRange) |
| ColumnWidth | Gets or sets the width of all columns in the specified range, measured in points. (Inherited from Syncfusion.XlsIO.IRange) |
| Comment | Gets a ICommentShape object that represents the comment associated with the range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| ConditionalFormats | Gets the collection of conditional formats in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| Count | Gets the number of cells in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| DataValidation | Gets a IDataValidation object that represents the data validation associated with the cell. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| DateTime | Gets or sets DateTime value in the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| DisplayText | Gets cell value with its number format. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| End | Gets a IRange object that represents the cell at the end of the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| EntireColumn | Gets a IRange object that represents the entire column (or columns) in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| EntireRow | Gets a IRange object that represents the entire row (or rows) in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| Error | Gets or sets error value in the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| Formula | Gets or sets the formula in A1-style notation and in macro language for the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| 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. (Inherited from Syncfusion.XlsIO.IRange) |
| FormulaArrayR1C1 | Gets or sets the formula array for the Range, using R1C1-style notation. (Inherited from Syncfusion.XlsIO.IRange) |
| FormulaBoolValue | Gets or sets the calculated value of the formula as a boolean. (Inherited from Syncfusion.XlsIO.IRange) |
| FormulaDateTime | Gets or sets formula DateTime value in the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| FormulaErrorValue | Gets or sets the error value of the formula as a string. (Inherited from Syncfusion.XlsIO.IRange) |
| FormulaHidden | Gets or sets a Boolean value indicating whether the formula will be hidden when the worksheet is protected. (Inherited from Syncfusion.XlsIO.IRange) |
| FormulaNumberValue | Gets or sets number value evaluated by formula. (Inherited from Syncfusion.XlsIO.IRange) |
| FormulaR1C1 | Gets or sets the formula for the Range, using R1C1-style notation. (Inherited from Syncfusion.XlsIO.IRange) |
| FormulaStringValue | Gets or sets string value evaluated by formula. (Inherited from Syncfusion.XlsIO.IRange) |
| HasBoolean | Gets a Boolean value indicating whether Range contains bool value. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasDataValidation | Gets a Boolean value indicating whether Range has data validation. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasDateTime | Gets a Boolean value indicating whether Range contains DateTime value. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasExternalFormula | Gets a Boolean value indicating whether Range has external formula. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasFormula | Gets a Boolean value indicating whether Range contains formula. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasFormulaArray | Gets a Boolean value indicating whether Range contains array-entered formula. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasFormulaBoolValue | Gets a Boolean value indicating whether Range has formula bool value. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasFormulaDateTime | Gets a Boolean value indicating whether Range has formula value formatted as DateTime. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasFormulaErrorValue | Gets a Boolean value indicating whether Range has formula error value. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasFormulaNumberValue | Gets a Boolean value indicating whether Range has formula number value. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasFormulaStringValue | Gets a Boolean value indicating whether Range has formula string value. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasNumber | Gets a Boolean value indicating whether Range contains number. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasRichText | Gets a Boolean value indicating whether cell contains formatted rich text string. (Inherited from Syncfusion.XlsIO.IRange) |
| HasString | Gets a Boolean value indicating whether Range contains string. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HasStyle | Gets a Boolean value indicating whether Range has default style. False means default style. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| HorizontalAlignment | Gets or sets the horizontal alignment for the specified object. (Inherited from Syncfusion.XlsIO.IRange) |
| HtmlString | Gets or sets HTML string. (Inherited from Syncfusion.XlsIO.IRange) |
| Hyperlinks | Gets hyperlinks in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| IgnoreErrorOptions | Gets or sets ignore error options for formula auditing. If not single cell gets concatenated flags. (Inherited from Syncfusion.XlsIO.IRange) |
| IndentLevel | Gets or sets the indent level for cell or Range. (Inherited from Syncfusion.XlsIO.IRange) |
| IsBlank | Gets a Boolean value indicating whether the Range is blank. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| IsBoolean | Gets a Boolean value indicating whether cell type is boolean. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| IsError | Gets a Boolean value indicating whether Range contains error value. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| IsGroupedByColumn | Gets a Boolean value indicating whether Range is grouped by column. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| IsGroupedByRow | Gets a Boolean value indicating whether Range is grouped by row. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| IsInitialized | Gets a Boolean value indicating whether cell is initialized. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| IsMerged | Gets a Boolean value indicating whether Range is a part of merged Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| IsStringsPreserved | Gets a Boolean value indicating whether all values in the Range are preserved as strings. (Inherited from Syncfusion.XlsIO.IRange) |
| Item | Gets or sets cell range by row and column index. Row and column indexes are one-based. (Inherited from Syncfusion.XlsIO.IRange) |
| LastColumn | Gets the column index of the last column in the Range which is a one based index. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| LastRow | Gets the row index of the last row in the Range which is a one based index. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| MergeArea | Gets a IRange object that represents the merged Range to which the cell or Range belongs. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| Number | Gets or sets number value that is contained by Range. (Inherited from Syncfusion.XlsIO.IRange) |
| NumberFormat | Gets or sets format of cell which is similar to Style.NumberFormat property. (Inherited from Syncfusion.XlsIO.IRange) |
| Parent | Gets the parent object. (Inherited from Syncfusion.XlsIO.IParentApplication) |
| RichText | Gets string with rich text formatting in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| Row | Gets the row index of the first row in the Range which is a one based index. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| RowGroupLevel | Gets row group level. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| RowHeight | Gets or sets the height of all the rows in the range, measured in points. (Inherited from Syncfusion.XlsIO.IRange) |
| Rows | Gets an array of IRange objects that represent the rows in the Range. Read only. (Inherited from Syncfusion.XlsIO.IRange) |
| Text | Gets or sets string value of the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| TimeSpan | Gets or sets time value of the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| Value | Gets or sets the value of the Range. Does not support FormulaArray value. (Inherited from Syncfusion.XlsIO.IRange) |
| Value2 | Gets or sets the cell value. (Inherited from Syncfusion.XlsIO.IRange) |
| VerticalAlignment | Gets or sets the vertical alignment of the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| Worksheet | Gets the IWorksheet object in which belongs to the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange) |
| WrapText | Gets or sets wrap text of the Range. (Inherited from Syncfusion.XlsIO.IRange) |
Public Methods
| Name | Description | |
|---|---|---|
 | Activate | Activates the cell. (Inherited from Syncfusion.XlsIO.IRange) |
| AddComment | Adds a comment. (Inherited from Syncfusion.XlsIO.IRange) |
| AutofitColumns | Changes the width of the columns in the range to achieve the best fit. (Inherited from Syncfusion.XlsIO.IRange) |
| AutofitRows | Changes the height of the rows in the range to achieve the best fit. (Inherited from Syncfusion.XlsIO.IRange) |
| BorderAround | Applies border around the Range. The default line style is ExcelLineStyle.Thin. (Inherited from Syncfusion.XlsIO.IRange) |
| BorderInside | Applies border inside the Range. The default line style is ExcelLineStyle.Thin. (Inherited from Syncfusion.XlsIO.IRange) |
| BorderNone | Applies no border in the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| Clear | Clears content in the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| CollapseGroup | Collapses the group by rows/columns. (Inherited from Syncfusion.XlsIO.IRange) |
| CopyTo | Copies the Range to the specified Range (without updating formulas). (Inherited from Syncfusion.XlsIO.IRange) |
| ExpandGroup | Expands the group by rows/columns. (Inherited from Syncfusion.XlsIO.IRange) |
| FindAll | Returns the cells with a specified string value and ExcelFindType. (Inherited from Syncfusion.XlsIO.IRange) |
| FindFirst | Returns the first occurrence cell with the specified string value and ExcelFindType. (Inherited from Syncfusion.XlsIO.IRange) |
| FreezePanes | Keep rows and columns visible in the Range while the rest of the worksheet scrolls. (Inherited from Syncfusion.XlsIO.IRange) |
| GetDependents | Gets the dependent cells which refer to other cells. (Inherited from Syncfusion.XlsIO.IRange) |
| GetEnumerator | (Inherited from System.Collections.Generic.IEnumerable<IRange>) |
| GetPrecedents | Gets the precedent cells which are referred by a formula in another cell. (Inherited from Syncfusion.XlsIO.IRange) |
| Group | Groups the Range by row/column. (Inherited from Syncfusion.XlsIO.IRange) |
| IntersectWith | Returns intersection of the Range with specified Range. (Inherited from Syncfusion.XlsIO.IRange) |
| Merge | Combines the contents of the selected cells in a new larger cell. (Inherited from Syncfusion.XlsIO.IRange) |
| MergeWith | Merges the range with specified range and returns merged range. (Inherited from Syncfusion.XlsIO.IRange) |
| MoveTo | Moves cells to the specified Range (without updating formulas). (Inherited from Syncfusion.XlsIO.IRange) |
| Offset | Returns a IRange object that represents a range that�s offset from the specified range. (Inherited from Syncfusion.XlsIO.IRange) |
| ResetRowColumn | Resets row and column values. |
| Resize | Resizes the specified range a IRange object that represents the resized range. (Inherited from Syncfusion.XlsIO.IRange) |
| SetValue | Overloaded. Assigns integer value to the Merged region. |
| SubTotal | Creates subtotals for the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| Ungroup | Ungroups the Range. (Inherited from Syncfusion.XlsIO.IRange) |
| UnMerge | Separates merged cells into individual cells. (Inherited from Syncfusion.XlsIO.IRange) |
See Also