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