Package loci.poi.hssf.util
Class RangeAddress
java.lang.Object
loci.poi.hssf.util.RangeAddress
Title: Range Address
Description: provides connectivity utilities for ranges
REFERENCE:
- Version:
- 1.0
- Author:
- IgOr KaTz && EuGeNe BuMaGiN (Tal Moshaiov) (VistaPortal LDT.)
-
Constructor Summary
ConstructorsConstructorDescriptionRangeAddress(int _startCol, int _startRow, int _endCol, int _endRow) RangeAddress(String _url) Accepts an external reference from excel. -
Method Summary
Modifier and TypeMethodDescriptionintgetCharPart(String _value) getDigitPart(String _value) intgetRange()intgetWidth()intgetXPosition(String _subrange) intgetYPosition(String _subrange) booleanhasCell()booleanhasRange()booleanbooleanbooleanstatic booleanisSheetNameOk(String _sheetName) numTo26Sys(int _num) removeString(String _source, String _match) replaceString(String _source, String _oldPattern, String _newPattern) voidsetSize(int _width, int _height)
-
Constructor Details
-
RangeAddress
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 Details
-
getAddress
- Returns:
- String note: All absolute references are removed
-
getSheetName
-
getRange
-
isCellOk
-
isSheetNameOk
public boolean isSheetNameOk() -
isSheetNameOk
-
getFromCell
-
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
-
getXPosition
-
getDigitPart
-
getCharPart
-
get26Sys
-
numTo26Sys
-
replaceString
-
removeString
-