Uses of Class
com.extentech.ExtenXLS.CellHandle

Packages that use CellHandle

com.extentech.ExtenXLS	The ExtenXLS package contains the primary classes for working with spreadsheets.
com.extentech.ExtenXLS.binder	The ExtenXLS binder package contains the CellBinder API which automates mapping of data to spreadsheets.
com.extentech.ExtenXLS.ui	The ExtenXLS UI package contains swing UI spreadsheet components.
com.extentech.ExtenXLS.web	The ExtenXLS.web package contains ExtenXLS Spreadsheet classes enhanced with web and database persistence capabilities.

Uses of CellHandle in com.extentech.ExtenXLS

Fields in com.extentech.ExtenXLS declared as CellHandle

CellHandle[]

CellRange.cells

Methods in com.extentech.ExtenXLS that return CellHandle

CellHandle	WorkSheetHandle.add(Date dt, int row, int col, String fmt) Add a java.sql.Date Cell to a WorkSheet.
CellHandle	WorkSheetHandle.add(Date dt, String address, String fmt) Add a java.sql.Date Cell to a WorkSheet.
CellHandle	WorkSheet.add(Date dt, String address, String fmt) Add a java.sql.Date Cell to a WorkSheet.
CellHandle	WorkSheetHandle.add(Object obj, int row, int col) Add a Cell with the specified value to a WorkSheet.
CellHandle	WorkSheet.add(Object obj, int row, int col) Add a Cell with the specified value to a WorkSheet.
CellHandle	WorkSheetHandle.add(Object obj, int row, int col, int formatId) Add a Cell with the specified value to a WorkSheet.
CellHandle	WorkSheetHandle.add(Object obj, String address) Add a Cell with the specified value to a WorkSheet.
CellHandle	WorkSheet.add(Object obj, String address) Add a Cell with the specified value to a WorkSheet.
CellHandle	WorkSheetHandle.add(Timestamp dt, String address, String fmt) Add a java.sql.Timestamp Cell to a WorkSheet.
CellHandle[]	WorkSheetHandle.addValidated(Date dt, int row, int col, String fmt) Add a java.sql.Date Cell to a WorkSheet.
CellHandle[]	WorkSheetHandle.addValidated(Date dt, String address, String fmt) Add a java.sql.Date Cell to a WorkSheet.
CellHandle[]	WorkSheetHandle.addValidated(Object obj, int row, int col) Add a Cell with the specified value to a WorkSheet.
CellHandle[]	WorkSheetHandle.addValidated(Object obj, int row, int col, int formatId) Add a Cell with the specified value to a WorkSheet.
CellHandle[]	WorkSheetHandle.addValidated(Object obj, String address) Add a Cell with the specified value to a WorkSheet.
CellHandle[]	WorkSheetHandle.addValidated(Timestamp dt, String address, String fmt) Add a java.sql.Timestamp Cell to a WorkSheet.
static CellHandle	CellHandle.copyCellToWorkSheet(CellHandle sourcecell, WorkSheetHandle newsheet) Create a copy of this Cell in another WorkBook
static CellHandle	CellHandle.copyCellToWorkSheet(CellHandle sourcecell, WorkSheetHandle newsheet, int row, int col) Creates a copy of this cell on the given worksheet at the given address.
static CellHandle	CellHandle.copyCellToWorkSheet(CellHandle sourcecell, WorkSheetHandle newsheet, int row, int col, boolean copyByValue) Creates a copy of this cell on the given worksheet at the given address.
CellHandle	CellHandle.copyTo(String newaddr) copy this Cell to another location.
CellHandle	WorkSheetHandle.getCell(int row, int col) Returns a CellHandle for working with the value of a Cell on a WorkSheet.
CellHandle	WorkSheet.getCell(int row, int col) Returns a CellHandle for working with the value of a Cell on a WorkSheet.
CellHandle	WorkSheetHandle.getCell(int row, int col, boolean cache) Returns a CellHandle for working with the value of a Cell on a WorkSheet.
CellHandle	WorkSheetHandle.getCell(String addr) Returns a CellHandle for working with the value of a Cell on a WorkSheet.
CellHandle	WorkSheet.getCell(String addr) Returns a CellHandle for working with the value of a Cell on a WorkSheet.
CellHandle	WorkBookHandle.getCell(String address) Returns the Cell at the specified Location
CellHandle	WorkBook.getCell(String address) Returns the Cell at the specified Location
static CellHandle[]	ExcelTools.getCellHandlesFromSheet(String strRange, WorkSheetHandle sheet) Return an array of cell handles specified from the string passed in.
CellHandle[]	WorkSheetHandle.getCells() Returns all CellHandles defined on this WorkSheet.
CellHandle[]	WorkSheet.getCells() Returns all CellHandles defined on this WorkSheet.
CellHandle[]	WorkBookHandle.getCells() Returns an array containing all cells in the WorkBook
CellHandle[]	WorkBook.getCells() Returns all of the Cells contained in the WorkBook
CellHandle[]	RowHandle.getCells() Returns the array of Cells in this Row
CellHandle[]	NameHandle.getCells() gets the array of Cells in this Name
CellHandle[]	ColHandle.getCells() returns the array of Cells in this Column
CellHandle[]	CellRange.getCells() get the Cells in this cell range
CellHandle[]	RowHandle.getCells(boolean cached) Returns the array of Cells in this Row
static CellHandle[]	CellRange.getCells(String range, WorkBookHandle wbh) returns the cells for a given range static version
CellHandle[]	WorkSheetHandle.insertRow(int row1, Object[] data) Insert a row of Objects into the worksheet.
CellHandle[]	WorkSheetHandle.insertRow(int rownum, Object[] data, boolean shiftrows) Insert a row of Objects into the worksheet.

Methods in com.extentech.ExtenXLS with parameters of type CellHandle

void	NameHandle.addCell(CellHandle cx) add a cell to this named range
void	FormatHandle.addCell(CellHandle c) add a Cell to this FormatHandle thus applying the Format to the Cell
void	ConditionalFormatHandle.addCell(CellHandle cellHandle) Add a cell to this conditional format record
void	FormatHandle.addCellArray(CellHandle[] crcells) Apply this Format to a Range of Cells
boolean	CellRange.addCellToRange(CellHandle ch) Increase the bounds of the CellRange by including the CellHandle.
boolean	FormulaHandle.addCellToRange(String formulaLoc, CellHandle handle) Changes a range in a formula to expand until it includes the cell address from CellHandle.
ChartSeriesHandle	ChartHandle.addSeriesRange(CellHandle legendCell, CellRange categoryRange, CellRange seriesRange, CellRange bubbleRange) Adds a new Series to the chart via CellHandles and CellRange Objects.
boolean	ConditionalFormatHandle.contains(CellHandle cellHandle) Determine if the conditional format contains/affects the cell handle passed in
boolean	CellRange.contains(CellHandle ch) returns whether this CellRange contains a particular Cell
static CellHandle	CellHandle.copyCellToWorkSheet(CellHandle sourcecell, WorkSheetHandle newsheet) Create a copy of this Cell in another WorkBook
static CellHandle	CellHandle.copyCellToWorkSheet(CellHandle sourcecell, WorkSheetHandle newsheet, int row, int col) Creates a copy of this cell on the given worksheet at the given address.
static CellHandle	CellHandle.copyCellToWorkSheet(CellHandle sourcecell, WorkSheetHandle newsheet, int row, int col, boolean copyByValue) Creates a copy of this cell on the given worksheet at the given address.
void	CellHandle.copyFormat(CellHandle source) Copy all formats from a source Cell to this Cell
boolean	ConditionalFormatRule.evaluate(CellHandle refcell) evaluates the criteria for this Conditional Format Rule if the criteria involves a comparison i.e.
ConditionalFormatRule	ConditionalFormatHandle.evaluate(CellHandle refcell) evaluates the criteria for this Conditional Format if the criteria involves a comparison i.e.
static Calendar	DateConverter.getCalendarFromCell(CellHandle cell) Gets the Calendar for the given cell.
static Calendar	DateConverter.getCalendarFromCellWithPrecision(CellHandle cell, int roundingCalendarField) returns a Java Calendar from a CellHandle containing an Excel-formatted Date The Excel date format does not map 100% accurately to Java dates, due to the limitation of the precision of the Excel floating-point value record.
static Date	DateConverter.getDateFromCell(CellHandle cell) Gets the Date for the given cell.
int[]	CellRange.getEdgePositions(CellHandle ch, int sz) returns edge status of the desired CellHandle within this CellRange ie: top, left, bottom, right returns 0 or 1 for 4 sides 1,1,1,1 is a single cell in a range 1,1,0,0 is on the top left edge of the range
static String	DateConverter.getFormattedDateVal(CellHandle cell) Returns the value of the cell as a date formatted as a String date representation.
static String	ExtenXLS.getJSON(CellHandle ch) Get a JSON representation of a cell utilizing a merged range identifier
static String	ExtenXLS.getJSON(CellHandle ch, int[] mergedRange) Get a JSON representation of a cell utilizing a merged range identifier
static org.json.JSONObject	ExtenXLS.getJSONObject(CellHandle ch) Get a JSON representation of a cell utilizing a merged range identifier
static org.json.JSONObject	ExtenXLS.getJSONObject(CellHandle ch, int[] mergedRange) Get a JSON Object representation of a cell utilizing a merged range identifier
static String	ExtenXLS.getStyleHTML(CellHandle cx) Get an HTML representation of the Cell Style
void	WorkSheetHandle.moveCell(CellHandle c, String addr) Move a cell on this WorkSheet.
void	WorkSheet.moveCell(CellHandle c, String addr) Move a cell on this WorkSheet.
void	WorkSheetHandle.removeCell(CellHandle celldel) Remove a Cell from this WorkSheet.
void	WorkSheet.removeCell(CellHandle celldel) Remove a Cell from this WorkSheet.
void	FormatHandle.stamp(CellHandle cell) Applies the format to a cell without establishing a relationship.

Constructors in com.extentech.ExtenXLS with parameters of type CellHandle

CellRange(CellHandle[] newcells)
Constructor which creates a new CellRange using an array of cells as it's constructor.

CellRange(CellHandle[] newcells, boolean createblanks)
create a new CellRange using an array of cells as it's constructor.

FormatHandle(CellHandle c)
Creates a FormatHandle for the given cell.

Uses of CellHandle in com.extentech.ExtenXLS.binder

Methods in com.extentech.ExtenXLS.binder with parameters of type CellHandle

void	DataBoundCell.setCell(CellHandle c)
void	BoundCell.setCell(CellHandle c)
void	BeanBoundCell.setCell(CellHandle c)

Constructors in com.extentech.ExtenXLS.binder with parameters of type CellHandle

BeanBoundCell(CellHandle c, Object d, String fieldname)
Create a BeanBoundCell passing in the CellHandle that it represents, the Object to which it is bound, and the field/index in the Object containing its values.

BeanBoundCell(CellHandle c, Object d, String fieldname, int i)
Create a BeanBoundCell passing in the CellHandle that it represents, the Object to which it is bound, and the field/index in the Object containing its values.

DataBoundCell(CellHandle c, DataObject d, String fieldname)
Create a DataBoundCell passing in the CellHandle that it represents, the DataObject to which it is bound, and the field/index in the DataObject containing its values.

DataBoundCell(CellHandle c, DataObject d, String fieldname, int i)
Create a DataBoundCell passing in the CellHandle that it represents, the DataObject to which it is bound, and the field/index in the DataObject containing its values.

Uses of CellHandle in com.extentech.ExtenXLS.ui

Fields in com.extentech.ExtenXLS.ui declared as CellHandle

CellHandle

ExtenXLSCellRenderer.ch

Methods in com.extentech.ExtenXLS.ui that return CellHandle

CellHandle	WorkSheetTableModel.getCellAt(int rowNumber, int colNumber) nice caching cell lookup
CellHandle	ExtenXLSTableModel.getCellAt(int rowNumber, int colNumber)

Methods in com.extentech.ExtenXLS.ui with parameters of type CellHandle

boolean	ExtenXLSCellRenderer.checkRange(CellHandle ch, ExtenXLSCellRenderer cx) Check whether a CellHandle is contained in any of the Cell Ranges...
void	WorkSheetTableModel.fireCellFocusChanged(CellHandle ch)
static Border	ExtenXLSCellRenderer.getBorder(CellHandle ch)

Uses of CellHandle in com.extentech.ExtenXLS.web

Methods in com.extentech.ExtenXLS.web that return CellHandle

CellHandle	MemeWorkBook.getCell(String address)
static CellHandle[]	WorkBookUpdateBean.getcellhandles(Map parameters) Primarily set up for testing purposes, but I figure there's got to be some sort of useful thing to do with this.
CellHandle[]	MemeWorkBook.getCells()
CellHandle[]	CellHandlingBean.getCells() Get all the cellHandles referenced in this CellInfo.