Package com.extentech.ExtenXLS

The ExtenXLS package contains the primary classes for working with spreadsheets.

See:
Description

Interface Summary

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()).
CellParseEventListener	A lightweight Cell parser event listener
Document	Deprecated. This interface provides no functionality beyond the abstract DocumentHandle class.
Handle	A type that represents a component of a document.
WorkBook	Deprecated. This interface does not provide any useful abstraction.
WorkSheet	An interface representing an ExtenXLS WorkSheet

Class Summary

AutoFilterHandle	AutoFilterHandle allows for manipulation of the AutoFilters within the Spreadsheet AutoFilters allow for
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.
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.
DateConverter	Provides methods for conversion to and from Excel serial date values.
DocumentHandle	Functionality common to all document types.
EncryptedWorkBookHandle	EncryptedWorkBookHandle is a WorkBookHandle that manages encrypted files.
ExcelTools	ExtenXLS helper methods.
ExtenXLS	Useful Entry-Point for ExtenXLS functionality.
FormatCache	Deprecated.
FormatHandle	Provides methods for querying and changing cell formatting information.
FormulaHandle	Formula Handle allows for manipulation of Formulas within a WorkBook.
GetInfo	Prints various bits of information about this build.
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.
SimpleCellValue	a simple implementation of Cell for use in
ValidationHandle	ValidationHandle allows for manipulation of the validation cells in Excel
WorkBookBeanFactory
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.
WorkBookParser	A READ-ONLY WorkBookHandle implementation which handles high-performance spreadsheet reading using a parse-event driven model.
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");

Exception Summary

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

Package com.extentech.ExtenXLS Description

The ExtenXLS package contains the primary classes for working with spreadsheets. See: ExtenXLS Docs