org.apache.poi.ss.util
Class AreaReference

java.lang.Object
  org.apache.poi.ss.util.AreaReference

Direct Known Subclasses:

AreaReference

public class AreaReference
extends java.lang.Object

AreaReference

public AreaReference(java.lang.String reference,
                     SpreadsheetVersion version)

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

@Deprecated
@Removal(version="3.19")
public AreaReference(CellReference topLeft,
                                               CellReference botRight)

Deprecated. use AreaReference(CellReference, CellReference, SpreadsheetVersion) instead

Creates an area ref from a pair of Cell References.

AreaReference

public AreaReference(CellReference topLeft,
                     CellReference botRight,
                     SpreadsheetVersion version)

Creates an area ref from a pair of Cell References.

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(SpreadsheetVersion, String))

getWholeRow

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

getWholeColumn

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

isWholeColumnReference

public static boolean isWholeColumnReference(SpreadsheetVersion version,
                                             CellReference topLeft,
                                             CellReference botRight)

Is the reference for a whole-column reference, such as C:C or D:G ?

isWholeColumnReference

public boolean isWholeColumnReference()

generateContiguous

@Deprecated
@Removal(version="3.19")
public static AreaReference[] generateContiguous(java.lang.String reference)

Deprecated. use generateContiguous(SpreadsheetVersion, String) instead

Takes a non-contiguous area reference, and returns an array of contiguous area references

Returns:

an array of contiguous area references.

generateContiguous

public static AreaReference[] generateContiguous(SpreadsheetVersion version,
                                                 java.lang.String reference)

Takes a non-contiguous area reference, and returns an array of contiguous area references

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()

Returns a text representation of this area reference.

Example return values:

Result	Comment
A1:A1	Single cell area reference without sheet
A1:$C$1	Multi-cell area reference without sheet
Sheet1!A$1:B4	Standard 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