Property Getters/Setters Summary | ||
---|---|---|
function | getCellCount() | |
Gets all cell count in the range. | ||
function | getColumnCount() | |
Gets the count of rows in the 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 | hasRange() | |
Indicates whether this has range. | ||
function | getHyperlinks() | |
Gets all hyperlink in the range. | ||
function | getName() | |
function | setName(value) | |
Gets or sets the name of the range. | ||
function | getRangeCount() | |
Gets the count of the ranges. | ||
function | getRanges() | |
Gets all union ranges. | ||
function | getRefersTo() | |
Gets the range's refers to. | ||
function | getRowCount() | |
Gets the count of rows in the range. | ||
function | getValue() | |
function | setValue(value) | |
Gets and sets the values of the range. |
Method Summary | ||
---|---|---|
function | applyStyle(style, flag) | |
Applies formats for a whole range. | ||
function | copy(range, options) | |
Copying the range with paste special options. | ||
function | intersect(ranges) | |
Intersects another range. | ||
function | intersect(unionRange) | |
Intersects another range. | ||
function | intersect(range) | |
Intersects another range. | ||
function | iterator() | |
Gets the enumerator for cells in this Range. | ||
function | merge() | |
Combines a range of cells into a single cell. | ||
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 | 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 | union(ranges) | |
Union the ranges. | ||
function | union(unionRange) | |
Union another range. | ||
function | union(range) | |
Union another range. | ||
function | unMerge() | |
Unmerges merged cells of this range. |
Property Getters/Setters Detail |
---|
getFirstRow : Number | |
function getFirstRow() |
getFirstColumn : Number | |
function getFirstColumn() |
getRowCount : Number | |
function getRowCount() |
getColumnCount : Number | |
function getColumnCount() |
getValue/setValue : Object | |
function getValue() / function setValue(value) |
getName/setName : String | |
function getName() / function setName(value) |
range.Name = "Sheet1!MyRange";
getRefersTo : String | |
function getRefersTo() |
hasRange : boolean | |
function hasRange() |
getHyperlinks : Hyperlink[] | |
function getHyperlinks() |
getCellCount : Number | |
function getCellCount() |
getRangeCount : Number | |
function getRangeCount() |
getRanges : Range[] | |
function getRanges() |
Method Detail |
---|
merge | |
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 typesetStyle | |
function setStyle(style) |
style: Style
- The Style object.applyStyle | |
function applyStyle(style, flag) |
style: Style
- The style object which will be applied.flag: StyleFlag
- Flags which indicates applied formatting properties.copy | |
function copy(range, options) |
range: UnionRange
- The source range.options: PasteOptions
- The paste special options.iterator | |
function iterator() |
setOutlineBorders | |
function setOutlineBorders(borderStyles, borderColors) |
borderStyles: Number Array
- Border styles.borderColors: Color[]
- Border colors.setOutlineBorders | |
function setOutlineBorders(borderStyle, borderColor) |
borderStyle: Number
- A borderColor: Color
- Border color.intersect | |
function intersect(range) |
range: String
- The range.intersect | |
function intersect(unionRange) |
unionRange: UnionRange
- The range.intersect | |
function intersect(ranges) |
ranges: Range[]
- The range.union | |
function union(range) |
range: String
- The range.union | |
function union(unionRange) |
unionRange: UnionRange
- The range.union | |
function union(ranges) |
ranges: Range[]
- The ranges.