org.zkoss.poi.hssf.util

Class AreaReference

java.lang.Object

org.zkoss.poi.ss.util.AreaReference

org.zkoss.poi.hssf.util.AreaReference

public final class AreaReference
extends AreaReference

Field Summary

Fields inherited from class org.zkoss.poi.ss.util.AreaReference

version

Constructor Summary

Constructors

Constructor and Description
AreaReference(CellReference topLeft, CellReference botRight) Creates an area ref from a pair of Cell References.
AreaReference(String reference) Create an area ref from a string representation.

Method Summary

Methods inherited from class org.zkoss.poi.ss.util.AreaReference

formatAsString, generateContiguous, getAllReferencedCells, getFirstCell, getLastCell, getWholeColumn, getWholeRow, isContiguous, isSingleCell, isWholeColumnReference, isWholeColumnReference, isWholeRowReference, isWholeRowReference, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

AreaReference

public AreaReference(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. Also normalises such that the top-left