|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Represents a sheet within a workbook. Provides a handle to the individual cells, or lines of cells (grouped by Row or Column)
Method Summary | |
Cell |
findCell(java.util.regex.Pattern pattern,
int firstCol,
int firstRow,
int lastCol,
int lastRow,
boolean reverse)
Gets the cell whose contents match the regular expressionstring passed in. |
Cell |
findCell(java.lang.String contents)
Gets the cell whose contents match the string passed in. |
Cell |
findCell(java.lang.String contents,
int firstCol,
int firstRow,
int lastCol,
int lastRow,
boolean reverse)
Gets the cell whose contents match the string passed in. |
LabelCell |
findLabelCell(java.lang.String contents)
Gets the cell whose contents match the string passed in. |
Cell |
getCell(int column,
int row)
Returns the cell specified at this row and at this column. |
Cell |
getCell(java.lang.String loc)
Returns the cell for the specified location eg. |
Cell[] |
getColumn(int col)
Gets all the cells on the specified column |
CellFormat |
getColumnFormat(int col)
Deprecated. Use getColumnView and the CellView bean instead |
int[] |
getColumnPageBreaks()
Accessor for the page breaks on this sheet |
int |
getColumns()
Returns the number of columns in this sheet |
CellView |
getColumnView(int col)
Gets the column width for the specified column |
int |
getColumnWidth(int col)
Deprecated. Use getColumnView instead |
Image |
getDrawing(int i)
Accessor for the image |
Hyperlink[] |
getHyperlinks()
Gets the hyperlinks on this sheet |
Range[] |
getMergedCells()
Gets the cells which have been merged on this sheet |
java.lang.String |
getName()
Gets the name of this sheet |
int |
getNumberOfImages()
Accessor for the number of images on the sheet |
Cell[] |
getRow(int row)
Gets all the cells on the specified row |
int |
getRowHeight(int row)
Deprecated. use getRowView instead |
int[] |
getRowPageBreaks()
Accessor for the page breaks on this sheet |
int |
getRows()
Returns the number of rows in this sheet |
CellView |
getRowView(int row)
Gets the row height for the specified column |
SheetSettings |
getSettings()
Gets the settings used on a particular sheet |
boolean |
isHidden()
Deprecated. in favour of the getSettings() method |
boolean |
isProtected()
Deprecated. in favour of the getSettings() method |
Method Detail |
public Cell getCell(int column, int row)
column
- the column numberrow
- the row number
public Cell getCell(java.lang.String loc)
loc
- the cell reference
public int getRows()
public int getColumns()
public Cell[] getRow(int row)
row
- the rows whose cells are to be returned
public Cell[] getColumn(int col)
col
- the column whose cells are to be returned
public java.lang.String getName()
public boolean isHidden()
public boolean isProtected()
public Cell findCell(java.lang.String contents)
contents
- the string to match
public Cell findCell(java.lang.String contents, int firstCol, int firstRow, int lastCol, int lastRow, boolean reverse)
contents
- the string to matchfirstCol
- the first column within the rangefirstRow
- the first row of the rangelastCol
- the last column within the rangelastRow
- the last row within the rangereverse
- indicates whether to perform a reverse search or not
public Cell findCell(java.util.regex.Pattern pattern, int firstCol, int firstRow, int lastCol, int lastRow, boolean reverse)
pattern
- the regular expression string to matchfirstCol
- the first column within the rangefirstRow
- the first row of the ranglastCol
- the last column within the rangelastRow
- the last row within the rangereverse
- indicates whether to perform a reverse search or not
public LabelCell findLabelCell(java.lang.String contents)
contents
- the string to match
public Hyperlink[] getHyperlinks()
public Range[] getMergedCells()
public SheetSettings getSettings()
public CellFormat getColumnFormat(int col)
col
- the column number
public int getColumnWidth(int col)
col
- the column number
public CellView getColumnView(int col)
col
- the column number
public int getRowHeight(int row)
row
- the row number
public CellView getRowView(int row)
row
- the row number
public int getNumberOfImages()
public Image getDrawing(int i)
i
- the 0 based image number
public int[] getRowPageBreaks()
public int[] getColumnPageBreaks()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |