Package com.extentech.ExtenXLS

Interface Summary

Handle	A generic handle interface to various XLS components
WorkBook	An interface representing an ExtenXLS WorkBook.
WorkSheet	An interface representing an ExtenXLS WorkSheet

Class Summary

BMIServlet	A Sample Servlet demonstrating ExtenXLS usage in a Servlet application.
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.
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.
DateConverter	DateConverter Provides helper methods to convert String and Java dates to Excel-compatible numeric dates which are represented as number of days since Jan 01, 1900.
Excel2HTMLServlet	A Servlet which allows one to upload an Excel File, then retrieve an HTML version of its contents.
Excel2XMLServlet	A Servlet which allows one to upload an Excel File, then retrieve an XML version of its contents.
ExcelTools	ExtenXLS helper methods.
ExtenXLS	Useful Entry-Point for ExtenXLS functionality.
FormatCache	Handles the caching of the Formats ------------------------------------------------------------
FormatHandle	Format Handle allows for manipulation of Cell Formatting within a WorkBook.
FormulaHandle	Formula Handle allows for manipulation of Formulas within a WorkBook.
ImageHandle	The ImageHandle provides access to an Image embedded in a spreadsheet. Use the ImageHandle to work with images in spreadsheet. With a ImageHandle you can: set the position of the image set the width and height of the image write the image bytes to an outputstream
MapDemoServlet	A Sample Servlet demonstrating ExtenXLS usage in a Servlet application.
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.
RowHandle	The RowHandle provides access to a Worksheet Row and its Cells.
SalarySurveyServlet	A Sample Servlet demonstrating ExtenXLS usage in a Servlet application.
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.
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. for example: WorkBookHandle book = new WorkBookHandle("testxls.xls"); WorkSheetHandle sheet1 = book.getWorkSheet("Sheet1"); CellHandle cell = sheet1.getCell("B22"); For usability reasons, ExtenXLS will convert the internal Excel 'Mulblank' record type to the 'Blank' record type when parsing the 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"); to write out the workbook to a file: