Range

addHyperlink(address, textToDisplay, screenTip) → Hyperlink

Adds a hyperlink to a specified cell or a range of cells.

Returns

Hyperlink Hyperlink object.

applyStyle(style, flag)

Applies formats for a whole range. Each cell in this range will contains a Style object. So this is a memory-consuming method. Please use it carefully.

autoFill(target)

Automaticall fill the target range.

autoFill(target, autoFillType)

Automaticall fill the target range.

copy(range, options)

Copying the range with paste special options.

copy(range)

Copies data (including formulas), formatting, drawing objects etc. from a source range.

copyData(range)

Copies cell data (including formulas) from a source range.

copyStyle(range)

Copies style settings from a source range.

copyValue(range)

Copies cell value from a source range.

get(rowOffset, columnOffset) → Cell

Gets Cell object in this range.

Returns

Cell Cell object.

getAddress()

Gets address of the range.

getCellOrNull(rowOffset, columnOffset) → Cell

Gets Cell object or null in this range.

Returns

Cell Cell object.

getColumnCount()

Gets the count of columns in the range.

getColumnWidth()

Sets or gets the column width of this range

getCurrentRegion()

Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns.

getEntireColumn()

Gets a Range object that represents the entire column (or columns) that contains the specified range.

getEntireRow()

Gets a Range object that represents the entire row (or rows) that contains the specified range.

getFirstColumn()

Gets the index of the first column of the range.

getFirstRow()

Gets the index of the first row of the range.

getHeight()

Gets the width of a range in points.

getHyperlinks()

Gets all hyperlink in the range.

getLeft()

Gets the distance, in points, from the left edge of column A to the left edge of the range.

getName()

Gets or sets the name of the range. Named range is supported. For example, range.Name = "Sheet1!MyRange";

getOffset(rowOffset, columnOffset) → Range

Gets Range range by offset.

Returns

Range 

getRefersTo()

Gets the range's refers to.

getRowCount()

Gets the count of rows in the range.

getRowHeight()

Sets or gets the height of rows in this range

getTop()

Gets the distance, in points, from the top edge of row 1 to the top edge of the range.

getValue()

Gets and sets the value of the range. If the range contains multiple cells, the returned/applied object should be Object[][].

getWidth()

Gets the width of a range in points.

getWorksheet()

Gets the Worksheetobject which contains this range.

intersect(range) → Range

Returns a Range object that represents the rectangular intersection of two ranges. If the two ranges are not intersected, returns null.

Returns

Range Returns a Range object

isBlank() → boolean

Indicates whether the range contains values.

Returns

boolean 

isIntersect(range) → boolean

Indicates whether the range is intersect. If the two ranges area not in the same worksheet ,return false.

Returns

boolean Whether the range is intersect.

iterator()

Gets the enumerator for cells in this Range. When traversing elements by the returned Enumerator, the cells collection should not be modified(such as operations that will cause new Cell/Row be instantiated or existing Cell/Row be deleted). Otherwise the enumerator may not be able to traverse all cells correctly(some elements may be traversed repeatedly or skipped).@return {Iterator} The cells enumerator

merge()

Combines a range of cells into a single cell. Reference the merged cell via the address of the upper-left cell in the range.

moveTo(destRow, destColumn)

Move the current range to the dest range.

putValue(stringValue, isConverted, setStyle)

Puts a value into the range, if appropriate the value will be converted to other data type and cell's number format will be reset.

setColumnWidth()

Sets or gets the column width of this range

setInsideBorders(borderEdge, lineStyle, borderColor)

Set inside borders of the range.

setName()

Gets or sets the name of the range. Named range is supported. For example, range.Name = "Sheet1!MyRange";

setOutlineBorder(borderEdge, borderStyle, borderColor)

Sets outline border around a range of cells.

setOutlineBorder(borderEdge, borderStyle, borderColor)

Sets outline border around a range of cells.

setOutlineBorders(borderStyle, borderColor)

Sets the outline borders around a range of cells with same border style and color.

setOutlineBorders(borderStyle, borderColor)

Sets the outline borders around a range of cells with same border style and color.

setOutlineBorders(borderStyles, borderColors)

Sets out line borders around a range of cells. Both the length of borderStyles and borderStyles must be 4. The order of borderStyles and borderStyles must be top,bottom,left,right

setRowHeight()

Sets or gets the height of rows in this range

setStyle(style, explicitFlag)

Apply the cell style.

setStyle(style)

Sets the style of the range.

setValue()

Gets and sets the value of the range. If the range contains multiple cells, the returned/applied object should be Object[][].

toString() → String

Returns a string represents the current Range object.

Returns

String 

unMerge()

Unmerges merged cells of this range.

union(range) → ArrayList

Returns the union of two ranges. NOTE: This method is now obsolete. Instead, please use Range.UnionRang() method. This method will be removed 12 months later since November 2023. Aspose apologizes for any inconvenience you may have experienced.

Returns

ArrayList The union of two ranges.

unionRang(range) → Array of Range

Returns the union result of two ranges.

Returns

Array of Range The union of two ranges.