XlsRangesCollection Properties

Gets / sets boolean value that is contained by this range.

Returns aBorders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format).

Gets/sets built in style.

Gets or sets the number of elements that the System.Collections.CollectionBase can contain.

Returns a Range object that represents the cells in the specified range. For big number of ranges can be very slow operation. Read-only.

Returns a Range object that represents the cells in the specified range. For big number of ranges can be very slow operation. Read-only.

Number of cells in the range. Read-only.

Returns name of the Style object that represents the style of the specified range. Read/write String.

Returns the number of the first column in the first area in the specified range. Read-only.

Column group level. Read-only. -1 - Not all columns in the range have same group level. 0 - No grouping, 1 - 7 - Group level.

For a Range object, returns an array of Range objects that represent the columns in the specified range.

Returns or sets the width of all columns in the specified range. Read/write Double.

Comment assigned to the range. Read-only.

Collection of conditional formats.

Gets the number of elements contained in the System.Collections.CollectionBase instance.

Data validation for the range.

Gets / sets DateTime contained by this cell. Read-write DateTime.

Returns a Range object that represents the cell at the end of the region that contains the source range.

Returns a Range object that represents the entire column (or columns) that contains the specified range. Read-only.

Returns a Range object that represents the entire row (or rows) that contains the specified range. Read-only.

Gets the evaluated value. Currently, this property always returns null.

Gets / sets error value that is contained by this range.

Returns or sets the object's formula in A1-style notation and in the language of the macro. Read/write Variant.

Represents array-entered formula. Visit http://www.cpearson.com/excel/array.htm for more information.

Returns or sets the array-entered formula in R1C1-style notation and in the language of the macro. Read/write Variant.

Returns the calculated value of the formula as a boolean.

Get / set formula DateTime value contained by this cell. DateTime.MinValue if not all cells of the range have same DateTime value.

Returns the calculated value of the formula as a string.

Returns the calculated value of the formula as a Number.

Returns or sets the object's formula in R1C1-style notation and in the language of the macro. Read/write Variant.

Indicates whether range contains bool value. Read-only.

Indicates whether specified range object has data validation. If Range is not single cell, then returns true only if all cells have data validation. Read-only.

Indicates whether range contains DateTime value. Read-only.

Indicates whether range contains error value.

Indicates is current range has external formula. Read-only.

True if all cells in the range contain formulas; False if at least one of the cells in the range doesn't contain a formula. Read-only Boolean.

Indicates whether range contains array-entered formula. Read-only.

Indicates if current range has formula bool value. Read only.

Indicates if current range has formula value formatted as DateTime. Read-only.

Indicates if current range has formula error value. Read only.

Determines whether the object has a formula that evaluates to a numeric value.

Determines whether the object has a formula string value.

Indicates whether this range is part of merged range. Read-only.

Indicates whether the range contains number. Read-only.

Indicates whether cell contains formatted rich text string.

Indicates whether the range contains String. Read-only.

Indicates whether range has default style. False means default style. Read-only.

Returns or sets the horizontal alignment for the specified object. Read/write HorizontalAlignType.

Gets and sets the html string which contains data and some formattings in this cell.

Returns hyperlinks for this ranges collection.

Represents ignore error options. If not single cell returs concatenateed flags.

Returns or sets the indent level for the cell or range. Can be an integer from 0 to 15. Read/write Integer.

Gets the list of elements in the instance.

Indicates whether the range is blank. Read-only.

True if the formula will be hidden when the worksheet is protected. False if at least part of formula in the range is not hidden.

Indicates whether this range is grouped by column. Read-only.

Indicates whether this range is grouped by row. Read-only.

Indicates whether cell is initialized. Read-only.

Gets a value indicating whether the collection is read-only.

Indicates whether all values in the range are preserved as strings.

True if Microsoft Excel wraps the text in the object. Read/write Boolean.

Returns item by index from the collection.

Get cell range.

Gets / sets cell by row and index.

Gets cell range. Read-only.

Get cell range.

Returns last column of the range. Read-only.

Returns last row of the range. Read-only.

Gets the list of elements in the instance.

Returns a Range object that represents the merged range containing the specified cell. If the specified cell not part of a merged range, this property returns NULL. Read-only.

Format of current cell. Analog of Style.NumberFormat property.

Returns cell value after number format application. Read-only.

Gets / sets double value of the range.

Read-oonly. The parent object for the specified object.

Returns the range reference in the language of the macro. Read-only String.

Returns the range reference for the specified range in the language of the user. Read-only String.

Returns the range reference in the language of the macro. Read-only String.

Gets address global in the format required by Excel 2007.

Returns the range reference in the language of the macro using R1C1-style reference. Read-only String.

Returns the range reference for the specified range in the language of the user using R1C1 style reference . Read-only String.

String with rich text formatting. Read-only.

Returns the number of the first row of the first area in the range. Read-only Long.

Row group level. Read-only. -1 - Not all rows in the range have same group level. 0 - No grouping, 1 - 7 - Group level.

Returns the height of all the rows in the range specified, measured in points. Returns Double.MinValue if the rows in the specified range aren't all the same height. Read / write Double.

For a Range object, returns an array of Range objects that represent the rows in the specified range.

Returns a Style object that represents the style of the specified range. Read/write IStyle.

Gets / sets string value of the range.

Gets / sets time value of the range.

Returns or sets the value of the specified range. Read/write Variant.

Returns or sets the cell value. Read/write Variant. The only difference between this property and the Value property is that the Value2 property doesn't use the Currency and Date data types.

Returns or sets the vertical alignment of the specified object. Read/write VerticalAlignType.

Returns a Worksheet object that represents the worksheet containing the specified range. Read-only.

Gets name of the parent worksheet.