Overview  Package  Class   Use  Tree  Deprecated  Index  Help 
 PREV   NEXT FRAMES    NO FRAMES    

Uses of Interface
com.extentech.ExtenXLS.Handle

Packages that use Handle
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.ExtenXLS
 

Subinterfaces of Handle in com.extentech.ExtenXLS
 interface WorkBook
          Deprecated. This interface does not provide any useful abstraction. In practice it is equivalent to the WorkBookHandle class. Use that type instead.
 interface WorkSheet
          An interface representing an ExtenXLS WorkSheet
 

Classes in com.extentech.ExtenXLS that implement Handle
 class AutoFilterHandle
          AutoFilterHandle allows for manipulation of the AutoFilters within the Spreadsheet AutoFilters allow for
 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
          ConditionalFormatRule defines a single rule for manipulation of the ConditionalFormat cells in Excel Each ConditionalFormatRule contains one rule and corresponding format data.
 class DocumentHandle
          Functionality common to all document types.
 class EncryptedWorkBookHandle
          EncryptedWorkBookHandle is a WorkBookHandle that manages encrypted files.
 class EncryptedWorkBookWritableParser
          EncryptedWorkBookWritableParser is a type of WorkBookWritableParser that handles encrypting the output file.
 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 such as whether to print in landscape or portrait mode.
 class ValidationHandle
          ValidationHandle allows for manipulation of the validation cells in Excel
 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 WorkBookParser
          A READ-ONLY WorkBookHandle implementation which handles high-performance spreadsheet reading using a parse-event driven model.
 class WorkBookWritableParser
          A WorkBookHandle implementation which handles high-performance spreadsheet reading using a parse-event driven model.
 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");
 

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 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.
 

Overview  Package  Class   Use  Tree  Deprecated  Index  Help 
 PREV   NEXT FRAMES    NO FRAMES    
Copyright © 2011 Extentech Inc. All Rights Reserved.