Syncfusion.XlsIO.Base
Properties  Methods 

Syncfusion.XlsIO Namespace : IMigrantRange Interface

IMigrantRange Interface Members

The following tables list the members exposed by IMigrantRange.

Public Properties
 NameDescription
 Property Gets the Range reference in macro language. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the Range reference along with its sheet name in format "'Sheet1'!$A$1". Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the Range reference in language of the user. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the Range reference along with sheet name using R1C1-style notation. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the Range reference using R1C1-style notation. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the application object. (Inherited from Syncfusion.XlsIO.IParentApplication)
 Property Gets or sets boolean value in the Range. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets a IBorders collection that represents the borders of a style in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets built in style in the Range. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the calculated value of a formula in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets a IRange object that represents the cells in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets a IStyle object that represents the style of the Range. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets name of the IStyle object that represents style of the Range. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the column index of the first column in the Range which is a one based index. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets column group level of the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets an array of IRange objects that represent the columns in the Range. Read only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets the width of all columns in the specified range, measured in points. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets a ICommentShape object that represents the comment associated with the range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the collection of conditional formats in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the number of cells in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets a IDataValidation object that represents the data validation associated with the cell. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets DateTime value in the Range. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets cell value with its number format. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets a IRange object that represents the cell at the end of the Range. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets a IRange object that represents the entire column (or columns) in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets a IRange object that represents the entire row (or rows) in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets error value in the Range. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets the formula in A1-style notation and in macro language for the Range. (Inherited from Syncfusion.XlsIO.IRange)
 Property 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)
 Property Gets or sets the formula array for the Range, using R1C1-style notation. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets the calculated value of the formula as a boolean. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets formula DateTime value in the Range. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets the error value of the formula as a string. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets a Boolean value indicating whether the formula will be hidden when the worksheet is protected. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets number value evaluated by formula. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets the formula for the Range, using R1C1-style notation. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets string value evaluated by formula. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range contains bool value. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range has data validation. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range contains DateTime value. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range has external formula. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range contains formula. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range contains array-entered formula. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range has formula bool value. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range has formula value formatted as DateTime. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range has formula error value. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range has formula number value. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range has formula string value. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range contains number. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether cell contains formatted rich text string. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range contains string. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range has default style. False means default style. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets the horizontal alignment for the specified object. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets HTML string. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets hyperlinks in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets ignore error options for formula auditing. If not single cell gets concatenated flags. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets the indent level for cell or Range. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether the Range is blank. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether cell type is boolean. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range contains error value. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range is grouped by column. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range is grouped by row. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether cell is initialized. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether Range is a part of merged Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets a Boolean value indicating whether all values in the Range are preserved as strings. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets cell range by row and column index. Row and column indexes are one-based. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the column index of the last column in the Range which is a one based index. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the row index of the last row in the Range which is a one based index. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets a IRange object that represents the merged Range to which the cell or Range belongs. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets number value that is contained by Range. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets format of cell which is similar to Style.NumberFormat property. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the parent object. (Inherited from Syncfusion.XlsIO.IParentApplication)
 Property Gets string with rich text formatting in the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets the row index of the first row in the Range which is a one based index. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets row group level. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets the height of all the rows in the range, measured in points. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets an array of IRange objects that represent the rows in the Range. Read only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets string value of the Range. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets time value of the Range. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets the value of the Range. Does not support FormulaArray value. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets the cell value. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets the vertical alignment of the Range. (Inherited from Syncfusion.XlsIO.IRange)
 PropertyGets the IWorksheet object in which belongs to the Range. Read-only. (Inherited from Syncfusion.XlsIO.IRange)
 Property Gets or sets wrap text of the Range. (Inherited from Syncfusion.XlsIO.IRange)
Top
Public Methods
 NameDescription
 Method Activates the cell. (Inherited from Syncfusion.XlsIO.IRange)
 Method Adds a comment. (Inherited from Syncfusion.XlsIO.IRange)
 Method Changes the width of the columns in the range to achieve the best fit. (Inherited from Syncfusion.XlsIO.IRange)
 Method Changes the height of the rows in the range to achieve the best fit. (Inherited from Syncfusion.XlsIO.IRange)
 MethodApplies border around the Range. The default line style is ExcelLineStyle.Thin. (Inherited from Syncfusion.XlsIO.IRange)
 MethodApplies border inside the Range. The default line style is ExcelLineStyle.Thin. (Inherited from Syncfusion.XlsIO.IRange)
 Method Applies no border in the Range. (Inherited from Syncfusion.XlsIO.IRange)
 Method Clears content in the Range. (Inherited from Syncfusion.XlsIO.IRange)
 Method Collapses the group by rows/columns. (Inherited from Syncfusion.XlsIO.IRange)
 Method Copies the Range to the specified Range (without updating formulas). (Inherited from Syncfusion.XlsIO.IRange)
 Method Expands the group by rows/columns. (Inherited from Syncfusion.XlsIO.IRange)
 MethodReturns the cells with a specified string value and ExcelFindType. (Inherited from Syncfusion.XlsIO.IRange)
 MethodReturns the first occurrence cell with the specified string value and ExcelFindType. (Inherited from Syncfusion.XlsIO.IRange)
 Method Keep rows and columns visible in the Range while the rest of the worksheet scrolls. (Inherited from Syncfusion.XlsIO.IRange)
 Method Gets the dependent cells which refer to other cells. (Inherited from Syncfusion.XlsIO.IRange)
 Method (Inherited from System.Collections.Generic.IEnumerable<IRange>)
 Method Gets the precedent cells which are referred by a formula in another cell. (Inherited from Syncfusion.XlsIO.IRange)
 Method Groups the Range by row/column. (Inherited from Syncfusion.XlsIO.IRange)
 Method Returns intersection of the Range with specified Range. (Inherited from Syncfusion.XlsIO.IRange)
 Method Combines the contents of the selected cells in a new larger cell. (Inherited from Syncfusion.XlsIO.IRange)
 Method Merges the range with specified range and returns merged range. (Inherited from Syncfusion.XlsIO.IRange)
 Method Moves cells to the specified Range (without updating formulas). (Inherited from Syncfusion.XlsIO.IRange)
 MethodReturns a IRange object that represents a range that�s offset from the specified range. (Inherited from Syncfusion.XlsIO.IRange)
 Method Resets row and column values.  
 MethodResizes the specified range a IRange object that represents the resized range. (Inherited from Syncfusion.XlsIO.IRange)
 MethodOverloaded.  Assigns integer value to the Merged region.  
 Method Creates subtotals for the Range. (Inherited from Syncfusion.XlsIO.IRange)
 Method Ungroups the Range. (Inherited from Syncfusion.XlsIO.IRange)
 Method Separates merged cells into individual cells. (Inherited from Syncfusion.XlsIO.IRange)
Top
See Also