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.)

Field Summary

Fields

Modifier and Type	Field and Description
(package private) String	m_cellFrom
(package private) String	m_cellTo
(package private) String	m_sheetName
(package private) static int	MAX_HEIGHT
(package private) static char	SO_FORMNAME_ENCLOSURE
(package private) static int	WRONG_POS

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
private String	filter$(String _range)
int	get26Sys(String _s)
String	getAddress()
String	getCharPart(String _value)
String	getDigitPart(String _value)
private int	getFirstDigitPosition(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()
private void	init(String _url)
private static boolean	intern_isSheetNameOk(String _sheetName, boolean _canBeWaitSpace)
boolean	isCellOk(String _cell)
private static boolean	isLetter(String _str)
boolean	isSheetNameOk()
static boolean	isSheetNameOk(String _sheetName)
String	numTo26Sys(int _num)
private String[]	parseURL(String _url)
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

Field Detail

WRONG_POS

static final int WRONG_POS

See Also:

Constant Field Values

MAX_HEIGHT

static final int MAX_HEIGHT

See Also:

Constant Field Values

SO_FORMNAME_ENCLOSURE

static final char SO_FORMNAME_ENCLOSURE

See Also:

Constant Field Values

m_sheetName

String m_sheetName

m_cellFrom

String m_cellFrom

m_cellTo

String m_cellTo

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()

intern_isSheetNameOk

private static boolean intern_isSheetNameOk(String _sheetName,
                           boolean _canBeWaitSpace)

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()

init

private void init(String _url)

parseURL

private String[] parseURL(String _url)

getYPosition

public int getYPosition(String _subrange)

isLetter

private static boolean isLetter(String _str)

getXPosition

public int getXPosition(String _subrange)

getDigitPart

public String getDigitPart(String _value)

getCharPart

public String getCharPart(String _value)

filter$

private String filter$(String _range)

getFirstDigitPosition

private int getFirstDigitPosition(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)