Property Getters/Setters Summary | ||
---|---|---|
function | getAddress() | |
Gets address of the range. | ||
function | getCellCount() | |
Gets all cell count in the range. | ||
function | getColumnCount() | |
Gets the count of columns in the range. | ||
function | getColumnWidth() | |
function | setColumnWidth(value) | |
Sets or gets the column width of this range | ||
function | getEntireColumn() | |
Gets a Range object that represents the entire column (or columns) that contains the specified range. | ||
function | getEntireRow() | |
Gets a Range object that represents the entire row (or rows) that contains the specified range. | ||
function | getFirstColumn() | |
Gets the index of the first column of the range. | ||
function | getFirstRow() | |
Gets the index of the first row of the range. | ||
function | getHyperlinks() | |
Gets all hyperlink in the range. | ||
function | getName() | |
function | setName(value) | |
Gets or sets the name of the range. | ||
function | getRefersTo() | |
Gets the range's refers to. | ||
function | getRowCount() | |
Gets the count of rows in the range. | ||
function | getRowHeight() | |
function | setRowHeight(value) | |
Sets or gets the height of rows in this range | ||
function | getValue() | |
function | setValue(value) | |
Gets and sets the value of the range. | ||
function | getWorksheet() | |
Gets the |
||
function | get(rowOffset, columnOffset) | |
Gets |
Method Summary | ||
---|---|---|
function | applyStyle(style, flag) | |
Applies formats for a whole range. | ||
function | copy(range) | |
Copies data (including formulas), formatting, drawing objects etc. from a source range. | ||
function | copy(range, options) | |
Copying the range with paste special options. | ||
function | copyData(range) | |
Copies cell data (including formulas) from a source range. | ||
function | copyStyle(range) | |
Copies style settings from a source range. | ||
function | copyValue(range) | |
Copies cell value from a source range. | ||
function | getCellOrNull(rowOffset, columnOffset) | |
Gets |
||
function | getOffset(rowOffset, columnOffset) | |
Gets |
||
function | intersect(range) | |
Returns a Range object that represents the rectangular intersection of two ranges. | ||
function | isIntersect(range) | |
Indicates whether the range is intersect. | ||
function | iterator() | |
Gets the enumerator for cells in this Range. | ||
function | merge() | |
Combines a range of cells into a single cell. | ||
function | moveTo(destRow, destColumn) | |
Move the current range to the dest range. | ||
function | 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. | ||
function | setOutlineBorder(borderEdge, borderStyle, borderColor) | |
Sets outline border around a range of cells. | ||
function | setOutlineBorders(borderStyle, borderColor) | |
Sets the outline borders around a range of cells with same border style and color. | ||
function | setOutlineBorders(borderStyles, borderColors) | |
Sets out line borders around a range of cells. | ||
function | setStyle(style) | |
Sets the style of the range. | ||
function | toString() | |
Returns a string represents the current Range object. | ||
function | union(range) | |
Returns the union of two ranges. | ||
function | unMerge() | |
Unmerges merged cells of this range. |
Property Getters/Setters Detail |
---|
getHyperlinks : Hyperlink[] | |
function getHyperlinks() |
getRowCount : Number | |
function getRowCount() |
getColumnCount : Number | |
function getColumnCount() |
getCellCount : Number | |
function getCellCount() |
getName/setName : String | |
function getName() / function setName(value) |
range.Name = "Sheet1!MyRange";
getRefersTo : String | |
function getRefersTo() |
getAddress : String | |
function getAddress() |
getFirstRow : Number | |
function getFirstRow() |
getFirstColumn : Number | |
function getFirstColumn() |
getValue/setValue : Object | |
function getValue() / function setValue(value) |
getColumnWidth/setColumnWidth : Number | |
function getColumnWidth() / function setColumnWidth(value) |
getRowHeight/setRowHeight : Number | |
function getRowHeight() / function setRowHeight(value) |
getEntireColumn : Range | |
function getEntireColumn() |
getEntireRow : Range | |
function getEntireRow() |
getWorksheet : Worksheet | |
function getWorksheet() |
get : Cell | |
function get(rowOffset, columnOffset) |
rowOffset
- Row offset in this range, zero based.columnOffset
- Column offset in this range, zero based.Method Detail |
---|
iterator | |
function iterator() |
isIntersect | |
function isIntersect(range) |
range: Range
- The range.intersect | |
function intersect(range) |
range: Range
- The intersecting range.union | |
function union(range) |
range: Range
- The rangemerge | |
function merge() |
unMerge | |
function unMerge() |
putValue | |
function putValue(stringValue, isConverted, setStyle) |
stringValue: String
- Input valueisConverted: boolean
- True: converted to other data type if appropriate.setStyle: boolean
- True: set the number format to cell's style when converting to other data typeapplyStyle | |
function applyStyle(style, flag) |
style: Style
- The style object which will be applied.flag: StyleFlag
- Flags which indicates applied formatting properties.setStyle | |
function setStyle(style) |
style: Style
- The Style object.setOutlineBorders | |
function setOutlineBorders(borderStyle, borderColor) |
borderStyle: Number
- A borderColor: Color
- Border color.setOutlineBorders | |
function setOutlineBorders(borderStyles, borderColors) |
borderStyles: Number Array
- Border styles.borderColors: Color[]
- Border colors.setOutlineBorder | |
function setOutlineBorder(borderEdge, borderStyle, borderColor) |
borderEdge: Number
- A borderStyle: Number
- A borderColor: Color
- Border color.moveTo | |
function moveTo(destRow, destColumn) |
destRow: Number
- The start row of the dest range.destColumn: Number
- The start column of the dest range.copyData | |
function copyData(range) |
range: Range
- Source copyValue | |
function copyValue(range) |
range: Range
- Source copyStyle | |
function copyStyle(range) |
range: Range
- Source copy | |
function copy(range, options) |
range: Range
- The soure range.options: PasteOptions
- The paste special options.copy | |
function copy(range) |
range: Range
- Source getCellOrNull | |
function getCellOrNull(rowOffset, columnOffset) |
rowOffset: Number
- Row offset in this range, zero based.columnOffset: Number
- Column offset in this range, zero based.getOffset | |
function getOffset(rowOffset, columnOffset) |
rowOffset: Number
- Row offset in this range, zero based.columnOffset: Number
- Column offset in this range, zero based.toString | |
function toString() |