jxl
Interface Sheet

All Known Subinterfaces:
WritableSheet

public interface Sheet

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

getCell

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

Parameters:
column - the column number
row - the row number
Returns:
the cell at the specified co-ordinates

getCell

public Cell getCell(java.lang.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

Parameters:
loc - the cell reference
Returns:
the cell at the specified co-ordinates

getRows

public int getRows()
Returns the number of rows in this sheet

Returns:
the number of rows in this sheet

getColumns

public int getColumns()
Returns the number of columns in this sheet

Returns:
the number of columns in this sheet

getRow

public Cell[] getRow(int row)
Gets all the cells on the specified row

Parameters:
row - the rows whose cells are to be returned
Returns:
the cells on the given row

getColumn

public Cell[] getColumn(int col)
Gets all the cells on the specified column

Parameters:
col - the column whose cells are to be returned
Returns:
the cells on the specified column

getName

public java.lang.String getName()
Gets the name of this sheet

Returns:
the name of the sheet

isHidden

public boolean isHidden()
Deprecated. in favour of the getSettings() method

Determines whether the sheet is hidden

Returns:
whether or not the sheet is hidden

isProtected

public boolean isProtected()
Deprecated. in favour of the getSettings() method

Determines whether the sheet is protected

Returns:
whether or not the sheet is protected

findCell

public Cell findCell(java.lang.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

Parameters:
contents - the string to match
Returns:
the Cell whose contents match the paramter, null if not found

findCell

public 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. 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

Parameters:
contents - the string to match
firstCol - the first column within the range
firstRow - the first row of the range
lastCol - the last column within the range
lastRow - the last row within the range
reverse - indicates whether to perform a reverse search or not
Returns:
the Cell whose contents match the parameter, null if not found

findCell

public 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. 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

Parameters:
pattern - the regular expression string to match
firstCol - the first column within the range
firstRow - the first row of the rang
lastCol - the last column within the range
lastRow - the last row within the range
reverse - indicates whether to perform a reverse search or not
Returns:
the Cell whose contents match the parameter, null if not found

findLabelCell

public LabelCell findLabelCell(java.lang.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.

Parameters:
contents - the string to match
Returns:
the Cell whose contents match the paramter, null if not found

getHyperlinks

public Hyperlink[] getHyperlinks()
Gets the hyperlinks on this sheet

Returns:
an array of hyperlinks

getMergedCells

public Range[] getMergedCells()
Gets the cells which have been merged on this sheet

Returns:
an array of range objects

getSettings

public SheetSettings getSettings()
Gets the settings used on a particular sheet

Returns:
the sheet settings

getColumnFormat

public CellFormat getColumnFormat(int col)
Deprecated. Use getColumnView and the CellView bean instead

Gets the column format for the specified column

Parameters:
col - the column number
Returns:
the column format, or NULL if the column has no specific format

getColumnWidth

public int getColumnWidth(int col)
Deprecated. Use getColumnView instead

Gets the column width for the specified column

Parameters:
col - the column number
Returns:
the column width, or the default width if the column has no specified format

getColumnView

public CellView getColumnView(int col)
Gets the column width for the specified column

Parameters:
col - the column number
Returns:
the column format, or the default format if no override is specified

getRowHeight

public int getRowHeight(int row)
Deprecated. use getRowView instead

Gets the row height for the specified column

Parameters:
row - the row number
Returns:
the row height, or the default height if the column has no specified format

getRowView

public CellView getRowView(int row)
Gets the row height for the specified column

Parameters:
row - the row number
Returns:
the row format, which may be the default format if no format is specified

getNumberOfImages

public int getNumberOfImages()
Accessor for the number of images on the sheet

Returns:
the number of images on this sheet

getDrawing

public Image getDrawing(int i)
Accessor for the image

Parameters:
i - the 0 based image number
Returns:
the image at the specified position

getRowPageBreaks

public int[] getRowPageBreaks()
Accessor for the page breaks on this sheet

Returns:
the page breaks on this sheet

getColumnPageBreaks

public int[] getColumnPageBreaks()
Accessor for the page breaks on this sheet

Returns:
the page breaks on this sheet