Syncfusion.XlsIO.Base
Properties  Methods 

Syncfusion.XlsIO Namespace : IRange Interface

IRange Interface Members

The following tables list the members exposed by IRange.

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