Uses of Class
com.extentech.ExtenXLS.WorkSheetHandle

Packages that use WorkSheetHandle

com.extentech.ExtenXLS	The ExtenXLS package contains the primary classes for working with 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 WorkSheetHandle in com.extentech.ExtenXLS

Methods in com.extentech.ExtenXLS that return WorkSheetHandle

WorkSheetHandle	WorkBookHandle.addWorkSheet(WorkSheetHandle sourceSheet) Inserts a WorkSheetHandle from a separate WorkBookhandle into the current WorkBookHandle.
WorkSheetHandle	WorkBookHandle.addWorkSheet(WorkSheetHandle sourceSheet, String NewSheetName) Inserts a WorkSheetHandle from a separate WorkBookhandle into the current WorkBookHandle.
WorkSheetHandle	WorkBook.addWorkSheet(WorkSheetHandle sht, String NewSheetName) Inserts a new worksheet and places it at the end of the workbook
WorkSheetHandle	WorkBookHandle.copyWorkSheet(String SourceSheetName, 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(String SourceSheetName, String NewSheetName) Copy (duplicate) a worksheet in the workbook and add it to the end of the workbook with a new name
WorkSheetHandle	WorkBookHandle.createWorkSheet(String name) Creates a new worksheet and places it at the end of the workbook.
WorkSheetHandle	WorkBook.createWorkSheet(String name) Creates a new worksheet and places it at the end of the workbook
WorkSheetHandle	WorkBookHandle.createWorkSheet(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) returns the handle to a WorkSheet by name.
WorkSheetHandle	WorkBookHandle.getWorkSheet(String handstr) returns the handle to a WorkSheet by name.
WorkSheetHandle	WorkBook.getWorkSheet(String handstr) 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() Returns an array of handles to all of the WorkSheets in the Workbook.

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

WorkSheetHandle	WorkBookHandle.addWorkSheet(WorkSheetHandle sourceSheet) Inserts a WorkSheetHandle from a separate WorkBookhandle into the current WorkBookHandle.
WorkSheetHandle	WorkBookHandle.addWorkSheet(WorkSheetHandle sourceSheet, String NewSheetName) Inserts a WorkSheetHandle from a separate WorkBookhandle into the current WorkBookHandle.
WorkSheetHandle	WorkBook.addWorkSheet(WorkSheetHandle sht, String NewSheetName) Inserts a new worksheet and places it at the end of the workbook
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	WorkBookHandle.copyChartToSheet(ChartHandle chart, WorkSheetHandle sheet) Copies an existing Chart to another WorkSheet
void	WorkBook.copyChartToSheet(ChartHandle chart, WorkSheetHandle sheet) Copies an existing Chart to another WorkSheet
ChartHandle	WorkBookHandle.createChart(String name, WorkSheetHandle wsh) Creates a new Chart and places it at the end of the workbook Under development and unsupported!
void	WorkBookHandle.deleteChart(String chartname, WorkSheetHandle wsh) delete an existing chart of the workbook
static CellHandle[]	ExcelTools.getCellHandlesFromSheet(String strRange, WorkSheetHandle sheet) Return an array of cell handles specified from the string passed in.
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(InputStream imagebytestream, WorkSheetHandle _sheet)
Constructor which takes image file bytes and inserts into specific sheet

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, 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, String NewSheetName)
WorkSheetHandle	MemeWorkBook.copyWorkSheet(String SourceSheetName, String NewSheetName)
WorkSheetHandle	MemeWorkBook.createWorkSheet(String name)
WorkSheetHandle	MemeWorkBook.createWorkSheet(String name, int sheetpos)
WorkSheetHandle	MemeWorkBook.getWorkSheet(int sheetnum)
WorkSheetHandle	MemeWorkBook.getWorkSheet(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, String NewSheetName)
void	MemeWorkBook.copyChartToSheet(ChartHandle chart, WorkSheetHandle sheet)
ChartHandle	MemeWorkBook.createChart(String name, WorkSheetHandle wsh)
void	MemeWorkBook.deleteChart(String chartname, WorkSheetHandle wsh)