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