Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate


com.aspose.cells
Class Range

java.lang.Object
  extended by com.aspose.cells.CellArea
      extended by com.aspose.cells.Range

public class Range
extends CellArea

Reprents a range in a worksheet.


Method Summary
 Cell getCell(int rowIndex, int columnIndex)
          Gets Cell object in this range.
 Cell[][] getCells()
          Gets all cells in the range.
 Worksheet getWorksheet()
          Gets the worksheet which contians this range .
 void setOutlineBorder(int borderLineType, Color borderColor)
          Sets outline border for this range.
 
Methods inherited from class com.aspose.cells.CellArea
equals, getEndColumn, getEndRow, getStartColumn, getStartRow, isValid, setEndColumn, setEndRow, setStartColumn, setStartRow, toString
 
Methods inherited from class java.lang.Object
getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Method Detail

getWorksheet

public Worksheet getWorksheet()
Gets the worksheet which contians this range .

Returns:
the worksheet.

getCell

public Cell getCell(int rowIndex,
                    int columnIndex)
Gets Cell object in this range.

Parameters:
rowIndex - row index in this range, zero based.
columnIndex - column index in this range, zero based.
Returns:
Cell object
Throws:
java.lang.IllegalArgumentException - if row or column index is out of range.

getCells

public Cell[][] getCells()
Gets all cells in the range.

Returns:
An array of cells objects.

setOutlineBorder

public void setOutlineBorder(int borderLineType,
                             Color borderColor)
Sets outline border for this range.

Parameters:
borderLineType - line type of border. see BorderLineType
borderColor - color of border