Uses of Interface
com.extentech.ExtenXLS.Handle

Packages that use Handle

com.extentech.ExtenDOC
com.extentech.ExtenXLS	The ExtenXLS package contains the primary classes for working with spreadsheets.
com.extentech.ExtenXLS.web	The ExtenXLS.web package contains ExtenXLS Spreadsheet classes enhanced with web and database persistence capabilities.

Uses of Handle in com.extentech.ExtenDOC

Classes in com.extentech.ExtenDOC that implement Handle

class

com.extentech.ExtenDOC.DocHandle This is the Abstract document class which represents an atomic Document file or object.

Uses of Handle in com.extentech.ExtenXLS

Subinterfaces of Handle in com.extentech.ExtenXLS

interface	WorkBook An interface representing an ExtenXLS WorkBook.
interface	WorkSheet An interface representing an ExtenXLS WorkSheet

Classes in com.extentech.ExtenXLS that implement Handle

class	AutoFilterHandle AutoFilterHandle allows for manipulation of the AutoFilter feature of Excel
class	CellHandle The CellHandle provides a handle to an XLS Cell and its values.
class	CommentHandle CommentHandle allows for manipulation of the Note or Comment feature of Excel In order to create CommentHandles programatically use the methods in WorkSheetHandle or CellHandle
class	ConditionalFormatHandle ConditionalFormatHandle allows for manipulation of the ConditionalFormat cells in Excel Using the ConditionalFormatHandle, the affected range of ConditionalFormats can be modified, along with the formatting applied to the cells when the condition is true.
class	ConditionalFormatRule
class	DocumentHandle This is the Abstract document class which represents an atomic Document file or object.
class	EncryptedWorkBookHandle EncryptedWorkBookHandle is a WorkBookHandle that manages encrypted files.
class	FormatHandle Provides methods for querying and changing cell formatting information.
class	PrinterSettingsHandle The PrinterSettingsHandle gives you control over the printer settings for a Sheet.
class	ValidationHandle ValidationHandle allows for manipulation of the validation cells in Excel Using the ValidationHandle, the affected range of validations can be modified, along with many of the error messages and actual validation upon the cells.
class	WorkBookHandle The WorkBookHandle provides a handle to the XLS file and includes convenience methods for working with the WorkSheets and Cell values within the XLS file.
class	WorkSheetHandle The WorkSheetHandle provides a handle to a Worksheet within an XLS file and includes convenience methods for working with the Cell values within the sheet. for example: WorkBookHandle book = new WorkBookHandle("testxls.xls"); WorkSheetHandle sheet1 = book.getWorkSheet("Sheet1"); CellHandle cell = sheet1.getCell("B22"); to add a cell: CellHandle cell = sheet1.add("Hello World","C22"); to add a numeric cell: CellHandle cell = sheet1.add(new Integer(120),"C23"); to add a formula cell: CellHandle cell = sheet1.add("=PI()","C24"); to write out the workbook to a file:

Methods in com.extentech.ExtenXLS that return Handle

Handle

NameHandle.getScope() Returns a handle to the object (either workbook or sheet) that is scoped to the name record Default scope is a WorkBookHandle, else the WorkSheetHandle is returned.

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

void	NameHandle.setScope(Handle scope) Set the scope of this name to that of the handle passed in.

Uses of Handle in com.extentech.ExtenXLS.web

Classes in com.extentech.ExtenXLS.web that implement Handle

class	FileWebWorkBook
class	MemeDoc this is a Word Doc specific MemeDocument
class	MemeDocument This class provides Saving and Reconstituting Documents as memes in the Extentech KB schema.
class	MemeWorkBook This class provides Saving and Reconstituting WorkBooks as memes in the Extentech KB schema.
class	WebDoc The WebWorkBook class provides additional functionality to the WorkBookHandle class to allow it to participate in a Service-Oriented-Architecture.
class	WebWorkBook The WebWorkBook class provides additional functionality to the WorkBookHandle class to allow it to participate in a Service-Oriented-Architecture.