|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||
| 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.eventui | The ExtenXLS UI package contains swing UI spreadsheet components. |
| 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(java.util.Date dt,
int row,
int col,
java.lang.String fmt)
Add a java.sql.Date Cell to a WorkSheet. |
CellHandle |
WorkSheetHandle.add(java.util.Date dt,
java.lang.String address,
java.lang.String fmt)
Add a java.sql.Date Cell to a WorkSheet. |
CellHandle |
WorkSheet.add(java.util.Date dt,
java.lang.String address,
java.lang.String fmt)
Add a java.sql.Date Cell to a WorkSheet. |
CellHandle |
WorkSheetHandle.add(java.lang.Object obj,
int row,
int col)
Add a Cell with the specified value to a WorkSheet. |
CellHandle |
WorkSheet.add(java.lang.Object obj,
int row,
int col)
Add a Cell with the specified value to a WorkSheet. |
CellHandle |
WorkSheetHandle.add(java.lang.Object obj,
int row,
int col,
int formatId)
Add a Cell with the specified value to a WorkSheet. |
CellHandle |
WorkSheetHandle.add(java.lang.Object obj,
java.lang.String address)
Add a Cell with the specified value to a WorkSheet. |
CellHandle |
WorkSheet.add(java.lang.Object obj,
java.lang.String address)
Add a Cell with the specified value to a WorkSheet. |
CellHandle |
WorkSheetHandle.add(java.lang.Object obj,
java.lang.String address,
boolean fixNumberAsString)
Add a Cell with the specified value to a WorkSheet, optionally attempting to convert numeric values to appropriate number cells with appropriate number formatting applied. |
CellHandle |
WorkSheetHandle.add(java.sql.Timestamp dt,
java.lang.String address,
java.lang.String fmt)
Add a java.sql.Timestamp Cell to a WorkSheet. |
CellHandle |
TransientRowHandle.addCell(java.util.Date cellValue,
int columnNum,
java.lang.String format)
Create a cell handle with the date passed in, note that this will completely overwrite the existing cell |
CellHandle |
TransientRowHandle.addCell(java.lang.Object cellValue,
int columnNum)
Create a cell handle with the data passed in, note that this will completely overwrite the existing cell |
CellHandle |
TransientRowHandle.addCell(java.lang.Object cellValue,
int columnNum,
int formatId)
Create a cell handle with the data passed in, note that this will completely overwrite the existing cell In addition set the format id of the cell |
CellHandle[] |
WorkSheetHandle.addValidated(java.util.Date dt,
int row,
int col,
java.lang.String fmt)
Add a java.sql.Date Cell to a WorkSheet. |
CellHandle[] |
WorkSheetHandle.addValidated(java.util.Date dt,
java.lang.String address,
java.lang.String fmt)
Add a java.sql.Date Cell to a WorkSheet. |
CellHandle[] |
WorkSheetHandle.addValidated(java.lang.Object obj,
int row,
int col)
Add a Cell with the specified value to a WorkSheet. |
CellHandle[] |
WorkSheetHandle.addValidated(java.lang.Object obj,
int row,
int col,
int formatId)
Add a Cell with the specified value to a WorkSheet. |
CellHandle[] |
WorkSheetHandle.addValidated(java.lang.Object obj,
java.lang.String address)
Add a Cell with the specified value to a WorkSheet. |
CellHandle[] |
WorkSheetHandle.addValidated(java.sql.Timestamp dt,
java.lang.String address,
java.lang.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(java.lang.String newaddr)
copy this Cell to another location. |
CellHandle |
TransientRowHandle.getCell(int columnNum)
Get a cell at the particular column number (zero based) |
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(java.lang.String addr)
Returns a CellHandle for working with the value of a Cell on a WorkSheet. |
CellHandle |
WorkSheet.getCell(java.lang.String addr)
Returns a CellHandle for working with the value of a Cell on a WorkSheet. |
CellHandle |
WorkBookWritableParser.getCell(java.lang.String address)
|
CellHandle |
WorkBookParser.getCell(java.lang.String address)
|
CellHandle |
WorkBookHandle.getCell(java.lang.String address)
Returns the Cell at the specified Location |
CellHandle |
WorkBook.getCell(java.lang.String address)
Deprecated. Returns the Cell at the specified Location |
static CellHandle[] |
ExcelTools.getCellHandlesFromSheet(java.lang.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[] |
WorkBookWritableParser.getCells()
|
CellHandle[] |
WorkBookParser.getCells()
|
CellHandle[] |
WorkBookHandle.getCells()
Returns an array containing all cells in the WorkBook |
CellHandle[] |
WorkBook.getCells()
Deprecated. Returns all of the Cells contained in the WorkBook |
CellHandle[] |
TransientRowHandle.getCells()
|
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[] |
TransientRowHandle.getCells(boolean cached)
|
CellHandle[] |
RowHandle.getCells(boolean cached)
Returns the array of Cells in this Row |
static CellHandle[] |
CellRange.getCells(java.lang.String range,
WorkBookHandle wbh)
returns the cells for a given range static version |
CellHandle[] |
WorkSheetHandle.insertRow(int row1,
java.lang.Object[] data)
Insert a row of Objects into the worksheet. |
CellHandle[] |
WorkSheetHandle.insertRow(int rownum,
java.lang.Object[] data,
boolean shiftrows)
Insert a row of Objects into the worksheet. |
| Methods in com.extentech.ExtenXLS that return types with arguments of type CellHandle | |
|---|---|
java.util.Collection<CellHandle> |
CellRange.calculateAffectedCellsOnSheet()
|
java.util.List<CellHandle> |
CellHandle.calculateAffectedCellsOnSheet()
Calculates and returns all formulas on the same sheet that reference this CellHandle. |
| 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(java.lang.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. |
ChartSeriesHandle |
ChartHandle.addSeriesRange(CellHandle legendCell,
CellRange categoryRange,
CellRange seriesRange,
CellRange bubbleRange,
int nChart)
Adds a new Series to the chart via CellHandles and CellRange Objects. |
int |
CellHandle.compareTo(CellHandle that)
|
boolean |
ConditionalFormatHandle.contains(CellHandle cellHandle)
Determine if the conditional format contains/affects the cell handle passed in |
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. |
void |
CellRange.fill(CellHandle source,
int what,
double increment)
Fills this range from the given cell. |
static java.util.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 java.lang.String |
DateConverter.getFormattedDateVal(CellHandle cell)
Deprecated. The date format handling in this method is wildly incorrect. It is retained only to provide compatibility with legacy ExtenXLS XML files. |
static java.lang.String |
ExtenXLS.getJSON(CellHandle ch)
Get a JSON representation of a cell utilizing a merged range identifier |
static java.lang.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 java.lang.String |
ExtenXLS.getStyleHTML(CellHandle cx)
Get an HTML representation of the Cell Style |
void |
WorkSheetHandle.moveCell(CellHandle c,
java.lang.String addr)
Move a cell on this WorkSheet. |
void |
WorkSheet.moveCell(CellHandle c,
java.lang.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,
java.lang.Object d,
java.lang.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,
java.lang.Object d,
java.lang.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,
java.lang.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,
java.lang.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.eventui |
|---|
| Fields in com.extentech.ExtenXLS.eventui declared as CellHandle | |
|---|---|
CellHandle |
ExtenXLSCellRenderer.ch
Deprecated. No longer used internally. Should not have been public. |
| Methods in com.extentech.ExtenXLS.eventui that return CellHandle | |
|---|---|
CellHandle |
WorkBookModel.getActiveCell()
Returns the current active cell. |
| Methods in com.extentech.ExtenXLS.eventui with parameters of type CellHandle | |
|---|---|
boolean |
ExtenXLSCellRenderer.checkRange(CellHandle ch,
ExtenXLSCellRenderer cx)
Check whether a CellHandle is contained in any of the Cell Ranges... |
static javax.swing.border.Border |
ExtenXLSCellRenderer.getBorder(CellHandle ch)
|
| 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 javax.swing.border.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(java.lang.String address)
|
static CellHandle[] |
WorkBookUpdateBean.getcellhandles(java.util.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. |
|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||