org.apache.poi.hssf.util
Class CellReference
java.lang.Object
org.apache.poi.ss.util.CellReference
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 java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
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)
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.