loci.poi.hssf.util

Class CellReference

java.lang.Object

loci.poi.hssf.util.CellReference

public class CellReference
extends Object

Author:

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

Field Summary

Fields

Modifier and Type	Field and Description
private int	col
private boolean	colAbs
private int	row Creates new CellReference
private boolean	rowAbs
private String	sheetName

Constructor Summary

Constructors

Constructor and Description
CellReference(int pRow, int pCol)
CellReference(int pRow, int pCol, boolean pAbsRow, boolean pAbsCol)
CellReference(String cellRef)

Method Summary

Methods

Modifier and Type	Method and Description
private int	convertColStringToNum(String ref) takes in a column reference portion of a CellRef and converts it from ALPHA-26 number format to 0-based base 10.
private static String	convertNumToColString(int col) takes in a 0-based base-10 column and returns a ALPHA-26 representation
short	getCol()
int	getRow()
String	getSheetName()
boolean	isColAbsolute()
boolean	isRowAbsolute()
private String[]	separateRefParts(String reference) Seperates the row from the columns and returns an array.
String	toString()

Methods inherited from class java.lang.Object

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

Field Detail

row

private int row

Creates new CellReference

col

private int col

sheetName

private String sheetName

rowAbs

private boolean rowAbs

colAbs

private boolean colAbs

Constructor Detail

CellReference

public CellReference(String cellRef)

CellReference

public CellReference(int pRow,
             int pCol)

CellReference

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

Method Detail

getRow

public int getRow()

getCol

public short getCol()

isRowAbsolute

public boolean isRowAbsolute()

isColAbsolute

public boolean isColAbsolute()

getSheetName

public String getSheetName()

convertColStringToNum

private int convertColStringToNum(String ref)

takes in a column reference portion of a CellRef and converts it from ALPHA-26 number format to 0-based base 10.

separateRefParts

private String[] separateRefParts(String reference)

Seperates the row from the columns and returns an array. Element in position one is the substring containing the columns still in ALPHA-26 number format.

convertNumToColString

private static String convertNumToColString(int col)

takes in a 0-based base-10 column and returns a ALPHA-26 representation

toString

public String toString()

Overrides:

toString in class Object