Package loci.poi.hssf.util
Class RangeAddress
- java.lang.Object
-
- loci.poi.hssf.util.RangeAddress
-
public class RangeAddress extends Object
Title: Range AddressDescription: provides connectivity utilities for ranges
REFERENCE:
- Version:
- 1.0
- Author:
- IgOr KaTz && EuGeNe BuMaGiN (Tal Moshaiov) (VistaPortal LDT.)
-
-
Constructor Summary
Constructors Constructor Description RangeAddress(int _startCol, int _startRow, int _endCol, int _endRow)
RangeAddress(String _url)
Accepts an external reference from excel.
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method 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)
-
-
-
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)
-
get26Sys
public int get26Sys(String _s)
-
numTo26Sys
public String numTo26Sys(int _num)
-
-