|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||
| Packages that use WorkSheetHandle | |
|---|---|
| com.extentech.ExtenXLS | The ExtenXLS package contains the primary classes for working with 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 WorkSheetHandle in com.extentech.ExtenXLS |
|---|
| Methods in com.extentech.ExtenXLS that return WorkSheetHandle | |
|---|---|
WorkSheetHandle |
WorkBookWritableParser.addWorkSheet(WorkSheetHandle sourceSheet)
|
WorkSheetHandle |
WorkBookParser.addWorkSheet(WorkSheetHandle sourceSheet)
|
WorkSheetHandle |
WorkBookHandle.addWorkSheet(WorkSheetHandle sourceSheet)
Inserts a WorkSheetHandle from a separate WorkBookhandle into the current WorkBookHandle. |
WorkSheetHandle |
WorkBookWritableParser.addWorkSheet(WorkSheetHandle sourceSheet,
java.lang.String NewSheetName)
|
WorkSheetHandle |
WorkBookParser.addWorkSheet(WorkSheetHandle sourceSheet,
java.lang.String NewSheetName)
|
WorkSheetHandle |
WorkBookHandle.addWorkSheet(WorkSheetHandle sourceSheet,
java.lang.String NewSheetName)
Inserts a WorkSheetHandle from a separate WorkBookhandle into the current WorkBookHandle. |
WorkSheetHandle |
WorkBook.addWorkSheet(WorkSheetHandle sht,
java.lang.String NewSheetName)
Deprecated. Inserts a new worksheet and places it at the end of the workbook |
WorkSheetHandle |
WorkBookWritableParser.copyWorkSheet(java.lang.String SourceSheetName,
java.lang.String NewSheetName)
|
WorkSheetHandle |
WorkBookParser.copyWorkSheet(java.lang.String SourceSheetName,
java.lang.String NewSheetName)
|
WorkSheetHandle |
WorkBookHandle.copyWorkSheet(java.lang.String SourceSheetName,
java.lang.String NewSheetName)
Copy (duplicate) a worksheet in the workbook and add it to the end of the workbook with a new name |
WorkSheetHandle |
WorkBook.copyWorkSheet(java.lang.String SourceSheetName,
java.lang.String NewSheetName)
Deprecated. Copy (duplicate) a worksheet in the workbook and add it to the end of the workbook with a new name |
WorkSheetHandle |
WorkBookHandle.createWorkSheet(java.lang.String name)
Creates a new worksheet and places it at the end of the workbook. |
WorkSheetHandle |
WorkBook.createWorkSheet(java.lang.String name)
Deprecated. Creates a new worksheet and places it at the end of the workbook |
WorkSheetHandle |
WorkBookHandle.createWorkSheet(java.lang.String name,
int sheetpos)
Creates a new worksheet and places it at the specified position. |
WorkSheetHandle |
CellRangeRef.getFirstSheet()
Returns the first sheet in this range. |
WorkSheetHandle |
CellRangeRef.getLastSheet()
Returns the last sheet in this range. |
WorkSheetHandle[] |
NameHandle.getReferencedSheets()
Get WorkSheetHandles for all of the Boundsheets referenced in this NameHandle. |
WorkSheetHandle |
CellRange.getSheet()
Returns the WorkSheet referenced in this CellRange. |
WorkSheetHandle |
WorkBookHandle.getWorkSheet(int sheetnum)
returns the handle to a WorkSheet by number. |
WorkSheetHandle |
WorkBook.getWorkSheet(int i)
Deprecated. returns the handle to a WorkSheet by name. |
WorkSheetHandle |
WorkBookWritableParser.getWorkSheet(java.lang.String sheetName)
|
WorkSheetHandle |
WorkBookHandle.getWorkSheet(java.lang.String handstr)
returns the handle to a WorkSheet by name. |
WorkSheetHandle |
WorkBook.getWorkSheet(java.lang.String handstr)
Deprecated. returns the handle to a WorkSheet by name. |
WorkSheetHandle |
ConditionalFormatHandle.getWorkSheetHandle()
get the WorkSheetHandle for this ConditionalFormat ConditionalFormats are bound to a specific worksheet and cannot be applied to multiple worksheets |
WorkSheetHandle |
CellHandle.getWorkSheetHandle()
get the WorkSheetHandle for this Cell |
WorkSheetHandle[] |
WorkBookHandle.getWorkSheets()
Returns an array of handles to all of the WorkSheets in the Workbook. |
WorkSheetHandle[] |
WorkBook.getWorkSheets()
Deprecated. Returns an array of handles to all of the WorkSheets in the Workbook. |
| Methods in com.extentech.ExtenXLS with parameters of type WorkSheetHandle | |
|---|---|
WorkSheetHandle |
WorkBookWritableParser.addWorkSheet(WorkSheetHandle sourceSheet)
|
WorkSheetHandle |
WorkBookParser.addWorkSheet(WorkSheetHandle sourceSheet)
|
WorkSheetHandle |
WorkBookHandle.addWorkSheet(WorkSheetHandle sourceSheet)
Inserts a WorkSheetHandle from a separate WorkBookhandle into the current WorkBookHandle. |
WorkSheetHandle |
WorkBookWritableParser.addWorkSheet(WorkSheetHandle sourceSheet,
java.lang.String NewSheetName)
|
WorkSheetHandle |
WorkBookParser.addWorkSheet(WorkSheetHandle sourceSheet,
java.lang.String NewSheetName)
|
WorkSheetHandle |
WorkBookHandle.addWorkSheet(WorkSheetHandle sourceSheet,
java.lang.String NewSheetName)
Inserts a WorkSheetHandle from a separate WorkBookhandle into the current WorkBookHandle. |
WorkSheetHandle |
WorkBook.addWorkSheet(WorkSheetHandle sht,
java.lang.String NewSheetName)
Deprecated. Inserts a new worksheet and places it at the end of the workbook |
CellRange |
CellRange.copy(WorkSheetHandle sheet,
int row,
int col,
int what)
Copies this range to another location. |
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 |
WorkBookWritableParser.copyChartToSheet(ChartHandle chart,
WorkSheetHandle sheet)
|
void |
WorkBookParser.copyChartToSheet(ChartHandle chart,
WorkSheetHandle sheet)
|
void |
WorkBookHandle.copyChartToSheet(ChartHandle chart,
WorkSheetHandle sheet)
Copies an existing Chart to another WorkSheet |
void |
WorkBook.copyChartToSheet(ChartHandle chart,
WorkSheetHandle sheet)
Deprecated. Copies an existing Chart to another WorkSheet |
ChartHandle |
WorkBookWritableParser.createChart(java.lang.String name,
WorkSheetHandle wsh)
|
ChartHandle |
WorkBookParser.createChart(java.lang.String name,
WorkSheetHandle wsh)
|
ChartHandle |
WorkBookHandle.createChart(java.lang.String name,
WorkSheetHandle wsh)
Creates a new Chart and places it at the end of the workbook |
static ChartHandle |
ChartHandle.createNewChart(WorkSheetHandle sheet,
int chartType,
java.util.EnumSet<ChartHandle.ChartOptions> options)
Static method to create a new chart on WorkSheet sheet of type chartType with chart Options options After creating, you can set the chart title via ChartHandle.setTitle and Position via ChartHandle.setRelativeBounds (row/col-based) or ChartHandle.setCoords (pixel-based) as well as several other customizations possible |
void |
WorkBookWritableParser.deleteChart(java.lang.String chartname,
WorkSheetHandle wsh)
|
void |
WorkBookParser.deleteChart(java.lang.String chartname,
WorkSheetHandle wsh)
|
void |
WorkBookHandle.deleteChart(java.lang.String chartname,
WorkSheetHandle wsh)
delete an existing chart of the workbook |
static CellHandle[] |
ExcelTools.getCellHandlesFromSheet(java.lang.String strRange,
WorkSheetHandle sheet)
Return an array of cell handles specified from the string passed in. |
void |
ChartHandle.parseXML(WorkSheetHandle sht,
org.xmlpull.v1.XmlPullParser xpp,
java.util.HashMap maps)
given a XmlPullParser positioned at the chart element, parse all chart elements to create desired chart |
void |
CellRangeRef.setFirstSheet(WorkSheetHandle sheet)
Sets the first sheet in this range. |
void |
CellRangeRef.setLastSheet(WorkSheetHandle sheet)
Sets the last sheet in this range. |
void |
CellRange.setSheet(WorkSheetHandle aSheet)
Sets the sheet reference for this CellRange. |
void |
CellHandle.setWorkSheetHandle(WorkSheetHandle handle)
set the WorkSheetHandle for this Cell |
| Constructors in com.extentech.ExtenXLS with parameters of type WorkSheetHandle | |
|---|---|
CellRange(WorkSheetHandle sht,
int[] coords)
Constructor to create a new CellRange from a WorkSheetHandle and a set of range coordinates: coords[0] = first row coords[1] = first col coords[2] = last row coords[3] = last col |
|
CellRange(WorkSheetHandle sht,
int[] coords,
boolean cb)
Constructor to create a new CellRange from a WorkSheetHandle and a set of range coordinates: coords[0] = first row coords[1] = first col coords[2] = last row coords[3] = last col |
|
CellRangeRef(int first_row,
int first_col,
int last_row,
int last_col,
WorkSheetHandle first_sheet,
WorkSheetHandle last_sheet)
|
|
ImageHandle(java.io.InputStream imagebytestream,
WorkSheetHandle _sheet)
Constructor which takes image file bytes and inserts into specific sheet |
|
TransientRowHandle(RowHandle myRow,
com.extentech.formats.XLS.PassThruOOXMLWriter passThruWriter,
WorkSheetHandle sheet)
Construct a Transient Row from an existing rowHandle |
|
| Uses of WorkSheetHandle in com.extentech.ExtenXLS.eventui |
|---|
| Fields in com.extentech.ExtenXLS.eventui declared as WorkSheetHandle | |
|---|---|
WorkSheetHandle |
ExtenXLSCellRenderer.mysheet
Deprecated. No longer used internally. Should not have been public. |
| Methods in com.extentech.ExtenXLS.eventui that return WorkSheetHandle | |
|---|---|
WorkSheetHandle |
WorkBookModel.getActiveSheet()
Returns the current active sheet. |
WorkSheetHandle |
ExtenXLSCellRenderer.getSheet()
|
| Methods in com.extentech.ExtenXLS.eventui with parameters of type WorkSheetHandle | |
|---|---|
void |
ExtenXLSCellRenderer.setSheet(WorkSheetHandle handle)
|
| Uses of WorkSheetHandle in com.extentech.ExtenXLS.ui |
|---|
| Fields in com.extentech.ExtenXLS.ui declared as WorkSheetHandle | |
|---|---|
WorkSheetHandle |
ExtenXLSCellRenderer.mysheet
|
| Methods in com.extentech.ExtenXLS.ui that return WorkSheetHandle | |
|---|---|
WorkSheetHandle |
WorkSheetTableModel.getSheet()
|
WorkSheetHandle |
WorkSheetPanel.getSheet()
|
WorkSheetHandle |
ExtenXLSCellRenderer.getSheet()
|
WorkSheetHandle |
WorkSheetTableModel.getWorkSheet()
|
| Methods in com.extentech.ExtenXLS.ui with parameters of type WorkSheetHandle | |
|---|---|
void |
WorkSheetTableModel.setSheet(WorkSheetHandle b)
|
void |
ExtenXLSCellRenderer.setSheet(WorkSheetHandle handle)
|
void |
WorkSheetPanel.setSheet(WorkSheetHandle bs,
javax.swing.event.TableModelListener ts)
|
void |
WorkSheetTableModel.setWorkSheet(WorkSheetHandle b)
|
| Constructors in com.extentech.ExtenXLS.ui with parameters of type WorkSheetHandle | |
|---|---|
WorkSheetTableModel(WorkSheetHandle bs)
Constructor which takes a WorkSheetHandle |
|
| Uses of WorkSheetHandle in com.extentech.ExtenXLS.web |
|---|
| Methods in com.extentech.ExtenXLS.web that return WorkSheetHandle | |
|---|---|
WorkSheetHandle |
MemeWorkBook.addWorkSheet(WorkSheetHandle sourceSheet)
|
WorkSheetHandle |
MemeWorkBook.addWorkSheet(WorkSheetHandle sourceSheet,
java.lang.String NewSheetName)
|
WorkSheetHandle |
MemeWorkBook.copyWorkSheet(java.lang.String SourceSheetName,
java.lang.String NewSheetName)
|
WorkSheetHandle |
MemeWorkBook.createWorkSheet(java.lang.String name)
|
WorkSheetHandle |
MemeWorkBook.createWorkSheet(java.lang.String name,
int sheetpos)
|
WorkSheetHandle |
MemeWorkBook.getWorkSheet(int sheetnum)
|
WorkSheetHandle |
MemeWorkBook.getWorkSheet(java.lang.String handstr)
|
WorkSheetHandle[] |
MemeWorkBook.getWorkSheets()
|
| Methods in com.extentech.ExtenXLS.web with parameters of type WorkSheetHandle | |
|---|---|
WorkSheetHandle |
MemeWorkBook.addWorkSheet(WorkSheetHandle sourceSheet)
|
WorkSheetHandle |
MemeWorkBook.addWorkSheet(WorkSheetHandle sourceSheet,
java.lang.String NewSheetName)
|
void |
MemeWorkBook.copyChartToSheet(ChartHandle chart,
WorkSheetHandle sheet)
|
ChartHandle |
MemeWorkBook.createChart(java.lang.String name,
WorkSheetHandle wsh)
|
void |
MemeWorkBook.deleteChart(java.lang.String chartname,
WorkSheetHandle wsh)
|
|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||