|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.acesoft.aceoffix.ExcelRect
public class ExcelRect
ExcelRect class is used to help developers to validate and parse A1-style reference.
Field Summary | |
---|---|
int |
bottom
End index of row. |
int |
left
Start index of column. |
int |
right
End index of column. |
int |
top
Start index of row. |
Constructor Summary | |
---|---|
ExcelRect(java.lang.String rangeAddress)
Initializes a new instance of the ExcelRect class with the specified rangeAddress. |
Method Summary | |
---|---|
static boolean |
cellAddressIsValid(java.lang.String cellAddress)
Static method. |
boolean |
isValid()
Determines whether the rangeAddress specified in constructor is valid. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public int left
public int top
public int right
public int bottom
Constructor Detail |
---|
public ExcelRect(java.lang.String rangeAddress) throws java.lang.Exception, java.io.IOException
rangeAddress
- The rangeAddress represents a range of cells containing one contiguous block of cells and it must use A1-style notation.
The A1-style notation is defined in Microsoft Excel. For example: A1:F8, it means a range of cells A1 through F8. The A1 cell is the cell whose row index is 1 and column index is 1. The F8 cell is the cell whose row index is 8 and column index is 6.
Note: There is a limit that the maximum number of columns per worksheet is 256 and the maximum number of rows is 65,536 in Excel2003 and earlier versions.
java.lang.Exception
java.io.IOException
Method Detail |
---|
public boolean isValid()
public static boolean cellAddressIsValid(java.lang.String cellAddress)
cellAddress
- The cellAddress represents a single cell and it must use A1-style notation.
The A1-style notation is defined in Microsoft Excel. For example: the B5 cell is the cell whose row index is 5 and column index is 2.
Note: There is a limit that the maximum number of columns per worksheet is 256 and the maximum number of rows is 65,536 in Excel2003 and earlier versions.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |