public interface Sheet
Modifier and Type | Method and Description |
---|---|
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
|
Cell getCell(int column, int row)
column
- the column numberrow
- the row numberCell getCell(java.lang.String loc)
loc
- the cell referenceint getRows()
int getColumns()
Cell[] getRow(int row)
row
- the rows whose cells are to be returnedCell[] getColumn(int col)
col
- the column whose cells are to be returnedjava.lang.String getName()
boolean isHidden()
boolean isProtected()
Cell findCell(java.lang.String contents)
contents
- the string to matchCell 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 notCell 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 notLabelCell findLabelCell(java.lang.String contents)
contents
- the string to matchHyperlink[] getHyperlinks()
Range[] getMergedCells()
SheetSettings getSettings()
CellFormat getColumnFormat(int col)
col
- the column numberint getColumnWidth(int col)
col
- the column numberCellView getColumnView(int col)
col
- the column numberint getRowHeight(int row)
row
- the row numberCellView getRowView(int row)
row
- the row numberint getNumberOfImages()
Image getDrawing(int i)
i
- the 0 based image numberint[] getRowPageBreaks()
int[] getColumnPageBreaks()