Home » JCraft » jxl » [javadoc | source]
jxl
public interface: Sheet [javadoc | source]

All Known Implementing Classes:
    SheetImpl, WritableSheet, WritableSheetImpl

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 Summary:
findCell,   findCell,   findCell,   findLabelCell,   getCell,   getCell,   getColumn,   getColumnFormat,   getColumnPageBreaks,   getColumnView,   getColumnWidth,   getColumns,   getDrawing,   getHyperlinks,   getMergedCells,   getName,   getNumberOfImages,   getRow,   getRowHeight,   getRowPageBreaks,   getRowView,   getRows,   getSettings,   isHidden,   isProtected
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)
    Accessor for the image
 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