org.apache.poi.hssf.util
Class CellReference

java.lang.Object
  extended by org.apache.poi.ss.util.CellReference
      extended by org.apache.poi.hssf.util.CellReference

public final class CellReference
extends CellReference

Common convertion functions between Excel style A1, C27 style cell references, and POI usermodel style row=0, column=0 style references.

Author:
Avik Sengupta, Dennis Doubleday (patch to seperateRowColumns())

Nested Class Summary
static class CellReference.NameType
          Used to classify identifiers found in formulas as cell references or not.
 
Constructor Summary
CellReference(int pRow, int pCol)
           
CellReference(int pRow, int pCol, boolean pAbsRow, boolean pAbsCol)
           
CellReference(int pRow, short pCol)
           
CellReference(java.lang.String cellRef)
          Create an cell ref from a string representation.
CellReference(java.lang.String pSheetName, int pRow, int pCol, boolean pAbsRow, boolean pAbsCol)
           
 
Method Summary
protected  void appendCellReference(java.lang.StringBuffer sb)
          Appends cell reference with '$' markers for absolute values as required.
protected static java.lang.String convertNumToColString(int col)
           
 
Methods inherited from class org.apache.poi.ss.util.CellReference
cellReferenceIsWithinRange, classifyCellReference, convertColStringToIndex, formatAsString, getCellRefParts, getCol, getRow, getSheetName, isColAbsolute, isPartAbsolute, isRowAbsolute, toString
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

CellReference

public CellReference(java.lang.String cellRef)
Create an cell ref from a string representation. Sheet names containing special characters should be delimited and escaped as per normal syntax rules for formulas.


CellReference

public CellReference(int pRow,
                     int pCol)

CellReference

public CellReference(int pRow,
                     short pCol)

CellReference

public CellReference(int pRow,
                     int pCol,
                     boolean pAbsRow,
                     boolean pAbsCol)

CellReference

public CellReference(java.lang.String pSheetName,
                     int pRow,
                     int pCol,
                     boolean pAbsRow,
                     boolean pAbsCol)
Method Detail

appendCellReference

protected void appendCellReference(java.lang.StringBuffer sb)
Description copied from class: CellReference
Appends cell reference with '$' markers for absolute values as required. Sheet name is not included.

Overrides:
appendCellReference in class CellReference

convertNumToColString

protected static java.lang.String convertNumToColString(int col)


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