|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.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(Cell cell)
|
|
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
static boolean |
cellReferenceIsWithinRange(java.lang.String colStr,
java.lang.String rowStr,
SpreadsheetVersion ssVersion)
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 CellReference.NameType |
classifyCellReference(java.lang.String str,
SpreadsheetVersion ssVersion)
Classifies an identifier as either a simple (2D) cell reference or a named range name |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
static java.lang.String |
convertNumToColString(int col)
Takes in a 0-based base-10 column and returns a ALPHA-26 representation. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
boolean |
equals(java.lang.Object o)
Checks whether this cell reference is equal to another object. |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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(Cell cell) 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) convertColStringToIndexpublic static int convertColStringToIndex(java.lang.String ref)
classifyCellReferencepublic static CellReference.NameType classifyCellReference(java.lang.String str, SpreadsheetVersion ssVersion)
cellReferenceIsWithinRangepublic static boolean cellReferenceIsWithinRange(java.lang.String colStr, java.lang.String rowStr, SpreadsheetVersion ssVersion)
isColumnWithnRangepublic static boolean isColumnWithnRange(java.lang.String colStr, SpreadsheetVersion ssVersion) isRowWithnRangepublic static boolean isRowWithnRange(java.lang.String rowStr, SpreadsheetVersion ssVersion) convertNumToColStringpublic static java.lang.String convertNumToColString(int col)
formatAsStringpublic java.lang.String formatAsString()
toStringpublic java.lang.String toString()
getCellRefPartspublic java.lang.String[] getCellRefParts()
equalspublic boolean equals(java.lang.Object o)
Copyright 2012 The Apache Software Foundation or its licensors, as applicable. |