|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.poi.ss.util.CellReference
public class CellReference
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. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
static boolean |
cellReferenceIsWithinRange(java.lang.String colStr,
java.lang.String rowStr)
Used to decide whether a name of the form "[A-Z]*[0-9]*" that appears in a formula can be interpreted as a cell reference. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
static int |
classifyCellReference(java.lang.String str)
Classifies an identifier as either a simple (2D) cell reference or a named range name |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
protected static int |
convertColStringToIndex(java.lang.String ref)
takes in a column reference portion of a CellRef and converts it from ALPHA-26 number format to 0-based base 10. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
protected static java.lang.String |
convertNumToColString(int col)
Takes in a 0-based base-10 column and returns a ALPHA-26 representation. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
java.lang.String |
formatAsString()
Example return values:
CellReferencepublic CellReference(java.lang.String cellRef)
CellReferencepublic CellReference(int pRow, int pCol) CellReferencepublic CellReference(int pRow, short pCol) CellReferencepublic CellReference(int pRow, int pCol, boolean pAbsRow, boolean pAbsCol) CellReferencepublic CellReference(java.lang.String pSheetName, int pRow, int pCol, boolean pAbsRow, boolean pAbsCol)
getRowpublic int getRow() getColpublic short getCol() isRowAbsolutepublic boolean isRowAbsolute() isColAbsolutepublic boolean isColAbsolute() getSheetNamepublic java.lang.String getSheetName()
isPartAbsolutepublic static boolean isPartAbsolute(java.lang.String part) convertColStringToIndexprotected static int convertColStringToIndex(java.lang.String ref)
classifyCellReferencepublic static int classifyCellReference(java.lang.String str)
cellReferenceIsWithinRangepublic static boolean cellReferenceIsWithinRange(java.lang.String colStr, java.lang.String rowStr)
convertNumToColStringprotected static java.lang.String convertNumToColString(int col)
formatAsStringpublic java.lang.String formatAsString()
toStringpublic java.lang.String toString()
getCellRefPartspublic java.lang.String[] getCellRefParts()
appendCellReferenceprotected void appendCellReference(java.lang.StringBuffer sb)
Copyright 2008 The Apache Software Foundation or its licensors, as applicable. |