org.apache.poi.ss.util
Class AreaReference

java.lang.Object
  extended by org.apache.poi.ss.util.AreaReference
Direct Known Subclasses:
AreaReference

public class AreaReference
extends java.lang.Object


Constructor Summary
AreaReference(CellReference topLeft, CellReference botRight)
          Creates an area ref from a pair of Cell References.
AreaReference(java.lang.String reference)
          Create an area ref from a string representation.
 
Method Summary
 java.lang.String formatAsString()
          Example return values:
ResultComment A1:A1Single cell area reference without sheet A1:$C$1Multi-cell area reference without sheet Sheet1!A$1:B4Standard sheet name 'O''Brien''s Sales'!B5:C6' Sheet name with special characters
static AreaReference[] generateContiguous(java.lang.String reference)
          Takes a non-contiguous area reference, and returns an array of contiguous area references.
 CellReference[] getAllReferencedCells()
          Returns a reference to every cell covered by this area
 CellReference getFirstCell()
           
 CellReference getLastCell()
          Note - if this area reference refers to a single cell, the return value of this method will be identical to that of getFirstCell()
static AreaReference getWholeColumn(java.lang.String start, java.lang.String end)
           
static AreaReference getWholeRow(java.lang.String start, java.lang.String end)
           
static boolean isContiguous(java.lang.String reference)
          Is the reference for a contiguous (i.e.
 boolean isSingleCell()
           
 boolean isWholeColumnReference()
           
static boolean isWholeColumnReference(CellReference topLeft, CellReference botRight)
          Is the reference for a whole-column reference, such as C:C or D:G ?
 java.lang.String toString()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

AreaReference

public AreaReference(java.lang.String reference)
Create an area ref from a string representation. Sheet names containing special characters should be delimited and escaped as per normal syntax rules for formulas.
The area reference must be contiguous (i.e. represent a single rectangle, not a union of rectangles)


AreaReference

public AreaReference(CellReference topLeft,
                     CellReference botRight)
Creates an area ref from a pair of Cell References.

Method Detail

isContiguous

public static boolean isContiguous(java.lang.String reference)
Is the reference for a contiguous (i.e. unbroken) area, or is it made up of several different parts? (If it is, you will need to call generateContiguous(String))


getWholeRow

public static AreaReference getWholeRow(java.lang.String start,
                                        java.lang.String end)

getWholeColumn

public static AreaReference getWholeColumn(java.lang.String start,
                                           java.lang.String end)

isWholeColumnReference

public static boolean isWholeColumnReference(CellReference topLeft,
                                             CellReference botRight)
Is the reference for a whole-column reference, such as C:C or D:G ?


isWholeColumnReference

public boolean isWholeColumnReference()

generateContiguous

public static AreaReference[] generateContiguous(java.lang.String reference)
Takes a non-contiguous area reference, and returns an array of contiguous area references.


isSingleCell

public boolean isSingleCell()
Returns:
false if this area reference involves more than one cell

getFirstCell

public CellReference getFirstCell()
Returns:
the first cell reference which defines this area. Usually this cell is in the upper left corner of the area (but this is not a requirement).

getLastCell

public CellReference getLastCell()
Note - if this area reference refers to a single cell, the return value of this method will be identical to that of getFirstCell()

Returns:
the second cell reference which defines this area. For multi-cell areas, this is cell diagonally opposite the 'first cell'. Usually this cell is in the lower right corner of the area (but this is not a requirement).

getAllReferencedCells

public CellReference[] getAllReferencedCells()
Returns a reference to every cell covered by this area


formatAsString

public java.lang.String formatAsString()
Example return values:
ResultComment
A1:A1Single cell area reference without sheet
A1:$C$1Multi-cell area reference without sheet
Sheet1!A$1:B4Standard sheet name
'O''Brien''s Sales'!B5:C6' Sheet name with special characters

Returns:
the text representation of this area reference as it would appear in a formula.

toString

public java.lang.String toString()
Overrides:
toString in class java.lang.Object


Copyright 2012 The Apache Software Foundation or its licensors, as applicable.