Represents a sheet within a workbook. Provides a handle to the individual
cells, or lines of cells (grouped by Row or Column)
Method from jxl.Sheet Detail: |
public Cell findCell(String contents)
Gets the cell whose contents match the string passed in.
If no match is found, then null is returned. The search is performed
on a row by row basis, so the lower the row number, the more
efficiently the algorithm will perform |
public Cell findCell(String contents,
int firstCol,
int firstRow,
int lastCol,
int lastRow,
boolean reverse)
Gets the cell whose contents match the string passed in.
If no match is found, then null is returned. The search is performed
on a row by row basis, so the lower the row number, the more
efficiently the algorithm will perform |
public Cell findCell(Pattern pattern,
int firstCol,
int firstRow,
int lastCol,
int lastRow,
boolean reverse)
Gets the cell whose contents match the regular expressionstring passed in.
If no match is found, then null is returned. The search is performed
on a row by row basis, so the lower the row number, the more
efficiently the algorithm will perform |
public LabelCell findLabelCell(String contents)
Gets the cell whose contents match the string passed in.
If no match is found, then null is returned. The search is performed
on a row by row basis, so the lower the row number, the more
efficiently the algorithm will perform. This method differs
from the findCell method in that only cells with labels are
queried - all numerical cells are ignored. This should therefore
improve performance. |
public Cell getCell(String loc)
Returns the cell for the specified location eg. "A4". Note that this
method is identical to calling getCell(CellReferenceHelper.getColumn(loc),
CellReferenceHelper.getRow(loc)) and its implicit performance
overhead for string parsing. As such,this method should therefore
be used sparingly |
public Cell getCell(int column,
int row)
Returns the cell specified at this row and at this column.
If a column/row combination forms part of a merged group of cells
then (unless it is the first cell of the group) a blank cell
will be returned |
public Cell[] getColumn(int col)
Gets all the cells on the specified column |
public CellFormat getColumnFormat(int col)Deprecated! Use - getColumnView and the CellView bean instead
Gets the column format for the specified column |
public int[] getColumnPageBreaks()
Accessor for the page breaks on this sheet |
public CellView getColumnView(int col)
Gets the column width for the specified column |
public int getColumnWidth(int col)Deprecated! Use - getColumnView instead
Gets the column width for the specified column |
public int getColumns()
Returns the number of columns in this sheet |
public Image getDrawing(int i)
|
public Hyperlink[] getHyperlinks()
Gets the hyperlinks on this sheet |
public Range[] getMergedCells()
Gets the cells which have been merged on this sheet |
public String getName()
Gets the name of this sheet |
public int getNumberOfImages()
Accessor for the number of images on the sheet |
public Cell[] getRow(int row)
Gets all the cells on the specified row |
public int getRowHeight(int row)Deprecated! use - getRowView instead
Gets the row height for the specified column |
public int[] getRowPageBreaks()
Accessor for the page breaks on this sheet |
public CellView getRowView(int row)
Gets the row height for the specified column |
public int getRows()
Returns the number of rows in this sheet |
public SheetSettings getSettings()
Gets the settings used on a particular sheet |
public boolean isHidden()Deprecated! in - favour of the getSettings() method
Determines whether the sheet is hidden |
public boolean isProtected()Deprecated! in - favour of the getSettings() method
Determines whether the sheet is protected |