Public Cell findCell( pattern,īoolean reverse) Gets the cell whose contents match the regular expressionstring passed in. Returns: the Cell whose contents match the parameter, null if not found 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 Public Cell findCell( contents,īoolean reverse) Gets the cell whose contents match the string passed in. Returns: the Cell whose contents match the paramter, null if not found Parameters: contents - the string to match On a row by row basis, so the lower the row number, the more If no match is found, then null is returned. Public Cell findCell( contents) Gets the cell whose contents match the string passed in. Returns: whether or not the sheet is protected in favour of the getSettings() methodĭetermines whether the sheet is protected

Returns: whether or not the sheet is hidden Public getName() Gets the name of this sheet Returns: the cells on the specified column Parameters: col - the column whose cells are to be returned Public Cell getColumn(int col) Gets all the cells on the specified column Parameters: row - the rows whose cells are to be returned Public Cell getRow(int row) Gets all the cells on the specified row Returns: the number of columns in this sheet

Public int getColumns() Returns the number of columns in this sheet Returns: the number of rows in this sheet Public int getRows() Returns the number of rows in this sheet Method is identical to calling getCell(CellReferenceHelper.getColumn(loc),ĬellReferenceHelper.getRow(loc)) and its implicit performance Public Cell getCell( loc) Returns the cell for the specified location eg. Returns: the cell at the specified co-ordinates Parameters: column - the column number row - the row number Then (unless it is the first cell of the group) a blank cell If a column/row combination forms part of a merged group of cells Int row) Returns the cell specified at this row and at this column. Gets the settings used on a particular sheetĭeprecated. Gets the row height for the specified column Gets the cells which have been merged on this sheetĪccessor for the number of images on the sheet

Gets the column width for the specified column Returns the number of columns in this sheet Use getColumnView and the CellView bean insteadĪccessor for the page breaks on this sheet Gets all the cells on the specified columnĭeprecated. Returns the cell for the specified location eg. Returns the cell specified at this row and at this column. Gets the cell whose contents match the string passed in. Gets the cell whose contents match the regular expressionstring passed in. Provides a handle to the individualĬells, or lines of cells (grouped by Row or Column)įindCell( pattern, Interface Sheet All Known Subinterfaces: WritableSheet SUMMARY: NESTED | FIELD | CONSTR | METHOD

Java jxl update a cell