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