autoFill

Automatically fills the values of the cells in the specified range based on the values of the cells in this range.

autoFilter

Overloaded.  

clear

Clears the content of the cells in this range.

fillData

Fills the data in this range according to the current data and the specified options.

getBottom

Gets the bottom side of the range.

getConditionalFormats

Gets a list with format objects that can be used to customize the appearance of the cells in the range based on various conditions.

getLeft

Gets the left side of the range.

getRight

Gets the right side of the range.

getStyle

Gets an IStyle object that can be used to customize the appearance of all cells in the range.

getTop

Gets the top side of the range.

getValidation

Gets an IValidation object that can be used to specify validation rules for the data in the cell range.

insert

Inserts new cells in the current range of cells. The existing cells are pushed down or right based on the value of direction.

iterator

Returns an enumerator object that can be used to iterate through the cells in the range.

merge

Merges the cells in this range into a single cell.

moveTo

Overloaded. Moves the data from the current range to another range.

remove

Remove the cells in the current range of cells.

reset

Clears the contents of the cells in the range, as well as their associated styles, hyperlinks, annotations, conditional formatting and data validations.

sort

Sorts the data in this range according to the specified options.

sum

Returns the sum of Numeric cell values.

toString

unmerge

Unmerges all merged cells intersecting with this range.