Uses of Package
com.extentech.ExtenXLS

Packages that use com.extentech.ExtenXLS

com.extentech.ExtenBean.swing	The ExtenBean swing package contains user interface components for the ExtenBean DataObjects.
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.eventui.event
com.extentech.ExtenXLS.eventui.swing	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.ui.jchart	The ExtenXLS UI.jchart package contains swing UI charting package for spreadsheet components.
com.extentech.ExtenXLS.web	The ExtenXLS.web package contains ExtenXLS Spreadsheet classes enhanced with web and database persistence capabilities.

Classes in com.extentech.ExtenXLS used by com.extentech.ExtenBean.swing

DocumentHandle
Functionality common to all document types.

Classes in com.extentech.ExtenXLS used by com.extentech.ExtenXLS

AutoFilterHandle
AutoFilterHandle allows for manipulation of the AutoFilters within the Spreadsheet AutoFilters allow for

Cell
A lightweight subset of Cell methods allowing for low memory overhead streaming implementations Feature Request: methods determining the type of the cell on the new Cell class (like CellHandle.isDate() or getCellType()).

CellHandle
The CellHandle provides a handle to an XLS Cell and its values.

CellParseEventListener
A lightweight Cell parser event listener

CellRange
Cell Range is a handle to a range of Workbook Cells
Contains useful methods for working with Collections of Cells.

CellRangeRef
Represents a reference to a 3D range of cells.

ChartHandle
Chart Handle allows for manipulation of Charts within a WorkBook.

ChartSeriesHandle
Chart Series Handle allows for manipulation of Chart Series within a Chart Handle.

ColHandle
The ColHandle provides access to an Worksheet Column and its Cells.

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

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.

ConditionalFormatRule
ConditionalFormatRule defines a single rule for manipulation of the ConditionalFormat cells in Excel Each ConditionalFormatRule contains one rule and corresponding format data.

Document
Deprecated. This interface provides no functionality beyond the abstract DocumentHandle class. Use that type instead.

DocumentHandle
Functionality common to all document types.

DocumentObjectNotFoundException

FormatHandle
Provides methods for querying and changing cell formatting information.

FormulaHandle
Formula Handle allows for manipulation of Formulas within a WorkBook.

Handle
A type that represents a component of a document.

ImageHandle
The ImageHandle provides access to an Image embedded in a spreadsheet.

Use the ImageHandle to work with images in spreadsheet.


With an ImageHandle you can:

insert images into your spreadsheet set the position of the image set the width and height of the image write spreadsheet image files to any outputstream

NameHandle
The NameHandle provides access to a Named Range and its Cells.

Use the NameHandle to work with individual Named Ranges in an XLS file.


With a NameHandle you can:

get a handle to the Cells in a Name
set the default formatting for a Name

PivotTableHandle
PivotTable Handle allows for manipulation of PivotTables within a WorkBook.

PrinterSettingsHandle
The PrinterSettingsHandle gives you control over the printer settings for a Sheet such as whether to print in landscape or portrait mode.

RowHandle
The RowHandle provides access to a Worksheet Row and its Cells.

ValidationHandle
ValidationHandle allows for manipulation of the validation cells in Excel

WorkBook
Deprecated. This interface does not provide any useful abstraction. In practice it is equivalent to the WorkBookHandle class. Use that type instead.

WorkBookException
WorkBookInstantiationException is thrown when a workbook cannot be parsed for a particular reason.

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.

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");

Classes in com.extentech.ExtenXLS used by com.extentech.ExtenXLS.binder

CellHandle
The CellHandle provides a handle to an XLS Cell and its values.

CellRange
Cell Range is a handle to a range of Workbook Cells
Contains useful methods for working with Collections of Cells.

DocumentHandle
Functionality common to all document types.

NameHandle
The NameHandle provides access to a Named Range and its Cells.

Use the NameHandle to work with individual Named Ranges in an XLS file.


With a NameHandle you can:

get a handle to the Cells in a Name
set the default formatting for a Name

WorkBook
Deprecated. This interface does not provide any useful abstraction. In practice it is equivalent to the WorkBookHandle class. Use that type instead.

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.

Classes in com.extentech.ExtenXLS used by com.extentech.ExtenXLS.eventui

CellHandle
The CellHandle provides a handle to an XLS Cell and its values.

CellRange
Cell Range is a handle to a range of Workbook Cells
Contains useful methods for working with Collections of Cells.

CellRangeRef
Represents a reference to a 3D range of cells.

NameHandle
The NameHandle provides access to a Named Range and its Cells.

Use the NameHandle to work with individual Named Ranges in an XLS file.


With a NameHandle you can:

get a handle to the Cells in a Name
set the default formatting for a Name

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.

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");

Classes in com.extentech.ExtenXLS used by com.extentech.ExtenXLS.eventui.event

CellRangeRef
Represents a reference to a 3D range of cells.

Classes in com.extentech.ExtenXLS used by com.extentech.ExtenXLS.eventui.swing

CellRange
Cell Range is a handle to a range of Workbook Cells
Contains useful methods for working with Collections of Cells.

Classes in com.extentech.ExtenXLS used by com.extentech.ExtenXLS.ui

CellHandle
The CellHandle provides a handle to an XLS Cell and its values.

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");

Classes in com.extentech.ExtenXLS used by com.extentech.ExtenXLS.ui.jchart

ChartHandle
Chart Handle allows for manipulation of Charts within a WorkBook.

Classes in com.extentech.ExtenXLS used by com.extentech.ExtenXLS.web

CellHandle
The CellHandle provides a handle to an XLS Cell and its values.

CellRange
Cell Range is a handle to a range of Workbook Cells
Contains useful methods for working with Collections of Cells.

ChartHandle
Chart Handle allows for manipulation of Charts within a WorkBook.

Document
Deprecated. This interface provides no functionality beyond the abstract DocumentHandle class. Use that type instead.

DocumentHandle
Functionality common to all document types.

FormatHandle
Provides methods for querying and changing cell formatting information.

FormulaHandle
Formula Handle allows for manipulation of Formulas within a WorkBook.

Handle
A type that represents a component of a document.

ImageHandle
The ImageHandle provides access to an Image embedded in a spreadsheet.

Use the ImageHandle to work with images in spreadsheet.


With an ImageHandle you can:

insert images into your spreadsheet set the position of the image set the width and height of the image write spreadsheet image files to any outputstream

NameHandle
The NameHandle provides access to a Named Range and its Cells.

Use the NameHandle to work with individual Named Ranges in an XLS file.


With a NameHandle you can:

get a handle to the Cells in a Name
set the default formatting for a Name

PivotTableHandle
PivotTable Handle allows for manipulation of PivotTables within a WorkBook.

WorkBook
Deprecated. This interface does not provide any useful abstraction. In practice it is equivalent to the WorkBookHandle class. Use that type instead.

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.

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");