loci.poi.hssf.util

Class RangeAddress

java.lang.Object

loci.poi.hssf.util.RangeAddress

public class RangeAddress
extends Object

Title: Range Address

Description: provides connectivity utilities for ranges

REFERENCE:

Version:

1.0

Author:

IgOr KaTz && EuGeNe BuMaGiN (Tal Moshaiov) (VistaPortal LDT.)

Constructor Summary

Constructors

Constructor and Description
RangeAddress(int _startCol, int _startRow, int _endCol, int _endRow)
RangeAddress(String _url) Accepts an external reference from excel.

Method Summary

Methods

Modifier and Type	Method and Description
int	get26Sys(String _s)
String	getAddress()
String	getCharPart(String _value)
String	getDigitPart(String _value)
String	getFromCell()
int	getHeight()
String	getRange()
String	getSheetName()
String	getToCell()
int	getWidth()
int	getXPosition(String _subrange)
int	getYPosition(String _subrange)
boolean	hasCell()
boolean	hasRange()
boolean	hasSheetName()
boolean	isCellOk(String _cell)
boolean	isSheetNameOk()
static boolean	isSheetNameOk(String _sheetName)
String	numTo26Sys(int _num)
String	removeString(String _source, String _match)
String	replaceString(String _source, String _oldPattern, String _newPattern)
void	setSize(int _width, int _height)

Methods inherited from class java.lang.Object

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

Constructor Detail

RangeAddress

public RangeAddress(String _url)

Accepts an external reference from excel.

i.e. Sheet1!$A$4:$B$9

Parameters:

_url -

RangeAddress

public RangeAddress(int _startCol,
            int _startRow,
            int _endCol,
            int _endRow)

Method Detail

getAddress

public String getAddress()

Returns:

String note: All absolute references are removed

getSheetName

public String getSheetName()

getRange

public String getRange()

isCellOk

public boolean isCellOk(String _cell)

isSheetNameOk

public boolean isSheetNameOk()

isSheetNameOk

public static boolean isSheetNameOk(String _sheetName)

getFromCell

public String getFromCell()

getToCell

public String getToCell()

getWidth

public int getWidth()

getHeight

public int getHeight()

setSize

public void setSize(int _width,
           int _height)

hasSheetName

public boolean hasSheetName()

hasRange

public boolean hasRange()

hasCell

public boolean hasCell()

getYPosition

public int getYPosition(String _subrange)

getXPosition

public int getXPosition(String _subrange)

getDigitPart

public String getDigitPart(String _value)

getCharPart

public String getCharPart(String _value)

get26Sys

public int get26Sys(String _s)

numTo26Sys

public String numTo26Sys(int _num)

replaceString

public String replaceString(String _source,
                   String _oldPattern,
                   String _newPattern)

removeString

public String removeString(String _source,
                  String _match)