A B C D E F G H I J L M N O P R S T U V W X Y Z

A

ACCESS_STATUS_PRIVATE - Static variable in class com.extentech.ExtenXLS.web.MemeDocument

ACCESS_STATUS_PUBLIC - Static variable in class com.extentech.ExtenXLS.web.MemeDocument

ACCESS_STATUS_SHARED - Static variable in class com.extentech.ExtenXLS.web.MemeDocument

actionPerformed(ActionEvent) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSPanel

Handle the display of Named CellRanges

actionPerformed(ActionEvent) - Method in class com.extentech.ExtenXLS.ui.ExtenXLSPanel

Handle the display of Named CellRanges

activate() - Method in interface com.extentech.ExtenBean.DataObject

load the data from the underlying persistence layer

activate() - Method in class com.extentech.ExtenBean.ExtenDataObject

A container invokes this method when the instance is taken out of the pool of available instances to become associated with a specific EJB object.

activate() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

activate() - Method in class com.extentech.ExtenBean.XMLDataObject

activate() - Method in class com.extentech.ExtenXLS.binder.NamedRangeDataObject

activeCellChanged(ActiveCellChangedEvent) - Method in interface com.extentech.ExtenXLS.eventui.event.ActiveCellChangedListener

ActiveCellChangedEvent - Class in com.extentech.ExtenXLS.eventui.event

ActiveCellChangedEvent(WorkBookModel) - Constructor for class com.extentech.ExtenXLS.eventui.event.ActiveCellChangedEvent

ActiveCellChangedListener - Interface in com.extentech.ExtenXLS.eventui.event

activeSheetChanged(ActiveSheetChangedEvent) - Method in interface com.extentech.ExtenXLS.eventui.event.ActiveSheetChangedListener

ActiveSheetChangedEvent - Class in com.extentech.ExtenXLS.eventui.event

Event sent by WorkBookModel when the active sheet has changed.

ActiveSheetChangedEvent(WorkBookModel, int, int) - Constructor for class com.extentech.ExtenXLS.eventui.event.ActiveSheetChangedEvent

Creates a new ActiveSheetChangedEvent.

ActiveSheetChangedListener - Interface in com.extentech.ExtenXLS.eventui.event

Defines the method for receiving ActiveSheetChangedEvents.

add(ExtenBeanTreeNode) - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

add(Object, int, int) - Method in interface com.extentech.ExtenXLS.WorkSheet

Add a Cell with the specified value to a WorkSheet.

add(Object, String) - Method in interface com.extentech.ExtenXLS.WorkSheet

Add a Cell with the specified value to a WorkSheet.

add(Date, String, String) - Method in interface com.extentech.ExtenXLS.WorkSheet

Add a java.sql.Date Cell to a WorkSheet.

add(Object, int, int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Add a Cell with the specified value to a WorkSheet.

add(Object, int, int, int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Add a Cell with the specified value to a WorkSheet.

add(Object, String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Add a Cell with the specified value to a WorkSheet.

add(Timestamp, String, String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Add a java.sql.Timestamp Cell to a WorkSheet.

add(Date, String, String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Add a java.sql.Date Cell to a WorkSheet.

add(Date, int, int, String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Add a java.sql.Date Cell to a WorkSheet.

addActiveCellChangedListener(ActiveCellChangedListener) - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

addActiveSheetChangedListener(ActiveSheetChangedListener) - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

addAllSeries(String[], String[], String[], String) - Method in class com.extentech.ExtenXLS.ChartHandle

updates (replaces) every Chart Series (bar, line or wedge on the Chart) with the data from the array of values, legends, bubble sizes (optional) and category range.

addAutoFilter(int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Adds a new AutoFilter for the specified column (0-based) in this sheet
returns a handle to the new AutoFilter

addCell(CellHandle) - Method in class com.extentech.ExtenXLS.ConditionalFormatHandle

Add a cell to this conditional format record

addCell(CellHandle) - Method in class com.extentech.ExtenXLS.FormatHandle

add a Cell to this FormatHandle thus applying the Format to the Cell

addCell(CellHandle) - Method in class com.extentech.ExtenXLS.NameHandle

add a cell to this named range

addcell(Map) - Static method in class com.extentech.ExtenXLS.web.WorkBookUpdateBean

Inserts a row into the worksheet

addCellArray(CellHandle[]) - Method in class com.extentech.ExtenXLS.FormatHandle

Apply this Format to a Range of Cells

addCellRange(DataBoundCellRange) - Method in class com.extentech.ExtenXLS.binder.CellRangeDataObject

Add a DataboundCellRange to this DataObject for retrieving data.

addCellRange(CellRange) - Method in class com.extentech.ExtenXLS.FormatHandle

Apply this Format to a Range of Cells

addCells(List) - Method in class com.extentech.ExtenXLS.FormatHandle

Add a List of Cells to this FormatHandle

addCellToRange(CellHandle) - Method in class com.extentech.ExtenXLS.CellRange

Increase the bounds of the CellRange by including the CellHandle.

addCellToRange(String, CellHandle) - Method in class com.extentech.ExtenXLS.FormulaHandle

Changes a range in a formula to expand until it includes the cell address from CellHandle.

addChart(byte[], String) - Method in interface com.extentech.ExtenXLS.WorkSheet

addChart(byte[], String, short[]) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

addChartEmbed(String[]) - Method in class com.extentech.ExtenXLS.ChartHandle

sets external information linked to or "embedded" in this OOXML chart; can be a chart user shape, an image ...

addChildObject(RelationalObject) - Method in class com.extentech.ExtenBean.DataObjectImpl

addChildObject(RelationalObject) - Method in class com.extentech.ExtenBean.ExtenDataObject

addChildObject(RelationalObject) - Method in interface com.extentech.ExtenBean.RelationalObject

addChildObject(RelationalObject) - Method in class com.extentech.ExtenBean.RelationalObjectImpl

addCol(String) - Method in class com.extentech.ExtenBean.ExtenDataObject

add a new col to this dataobject may affect ability to persist if model does not match

addCol(int, int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Deprecated. use addCol(int)

addCol(int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

adds the column (col1st, colLast) and returns the new ColHandle

addColinfo(colinfo) - Method in class com.extentech.ExtenXLS.binder.NamedRangeDataObject

Adds a colinfo to the list of colinfos if the colinfo doesn't exist.

addColumn(Object, Vector) - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

addConditionalFormat(ConditionalFormatHandle) - Method in class com.extentech.ExtenXLS.CellHandle

Set a conditional format upon this cell.

addDataObject(SimpleDataObject) - Method in class com.extentech.ExtenBean.swing.ExtenBeanComboBoxModel

addDataObjectActionListener(DataObjectActionListener) - Method in interface com.extentech.ExtenBean.DataObject

add a DataObjectActionListener

addDataObjectActionListener(DataObjectActionListener) - Method in class com.extentech.ExtenBean.DataObjectImpl

addDpt(DPt) - Method in class com.extentech.ExtenXLS.ChartSeriesHandle

adds an OOXML (Open Office XML) Data Point Property Element to this Series

addEditEndListener(EditEndListener) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

addEditStartListener(EditStartListener) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

addElement(Object) - Method in class com.extentech.ExtenBean.swing.ExtenBeanComboBoxModel

addFont(Font, WorkBookHandle) - Static method in class com.extentech.ExtenXLS.FormatHandle

adds a font to the global font store only if exact font is not already present

addImages(XmlPullParser, Boundsheet) - Static method in class com.extentech.ExtenXLS.ExtenXLS

Takes XML defining images and adds the images defined in it into the specific position in the sheet

addListDataListener(ListDataListener) - Method in class com.extentech.ExtenBean.swing.ExtenBeanComboBoxModel

addListDataListener(ListDataListener) - Method in class com.extentech.ExtenBean.swing.ExtenBeanListModel

addListener(ExtenBeanTreeChangeListener) - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeModel

Sets the tree model's container application to provide a handle to display and action methods outside of the tree itself.

addListener(CellParseEventListener) - Method in class com.extentech.ExtenXLS.WorkBookParser

addMultipleSeries(ArrayList) - Method in class com.extentech.ExtenXLS.ui.jchart.YSeries

Method to add multiple series (contained in an ArrayList) to this YSeries.

addMultipleYSeries(ArrayList) - Method in class com.extentech.ExtenXLS.ui.jchart.JChart

addNamedRange(NameHandle) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSPanel

addNamedRange(NameHandle) - Method in class com.extentech.ExtenXLS.ui.ExtenXLSPanel

addNewNode(DataObject) - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSRowTable

set table and XML Mapping values from PropertiesPanel

addNewNode(DataObject) - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSRowTable

set table and XML Mapping values from PropertiesPanel

addNotify() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenBeanListChooserFrame

addNotify() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenBeanListChooserFrame

addObject(Object) - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeModel

Add child to the currently selected node.

addObject(ExtenBeanTreeNode, Object) - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeModel

addObject(ExtenBeanTreeNode, Object, boolean) - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeModel

You can either add ExtenBeanTreeNodes or DataObjects to this TreeModel

addObject(DataObject) - Method in class com.extentech.ExtenBean.Transaction

addOrderByItem(int, Object) - Method in interface com.extentech.ExtenBean.DataObject

addOrderByItem(int, Object) - Method in class com.extentech.ExtenBean.DataObjectImpl

Maintain a numeric lookup for this DataObject.

addOrderByItem(int, Object) - Method in class com.extentech.ExtenBean.ExtenDataObject

Maintain a numeric lookup for this DataObject.

addParameter(String) - Method in class com.extentech.ExtenXLS.eventui.swing.DataObjectPanel

addParameter(DataObject) - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenDataObjectPanel

addParameter(String) - Method in class com.extentech.ExtenXLS.ui.swing.DataObjectPanel

addParameter(DataObject) - Method in class com.extentech.ExtenXLS.ui.swing.ExtenDataObjectPanel

addProperty(String, Object) - Method in interface com.extentech.ExtenXLS.Document

Deprecated. add non-Excel property

addProperty(String, Object) - Method in class com.extentech.ExtenXLS.DocumentHandle

Sets the value of a property in the workbook property store.

addProperty(String, Object) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

addProperty(String, Object) - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. add non-Excel property

addProperty(String, Object) - Method in class com.extentech.ExtenXLS.WorkBookParser

addRange(String) - Method in class com.extentech.ExtenXLS.ValidationHandle

Adds an additional range to the existing ranges in this validationhandle

addRow(Object[]) - Method in class com.extentech.ExtenXLS.NameHandle

add a row of cells to this named range

addRow(Vector) - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

addRow(Object[]) - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

addRow(Object, Vector) - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

addSelectionChangedListener(SelectionChangedListener) - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

addSeries(String) - Method in class com.extentech.ExtenXLS.ui.jchart.YSeries

Method to add a series to a YSeries object.

addSeriesRange(String, String, String, String) - Method in class com.extentech.ExtenXLS.ChartHandle

Adds a new Series to the chart.

addSeriesRange(String, String, String, String, int) - Method in class com.extentech.ExtenXLS.ChartHandle

Adds a new Series to the chart.

addSeriesRange(CellHandle, CellRange, CellRange, CellRange) - Method in class com.extentech.ExtenXLS.ChartHandle

Adds a new Series to the chart via CellHandles and CellRange Objects.

addSeriesRange(CellHandle, CellRange, CellRange, CellRange, int) - Method in class com.extentech.ExtenXLS.ChartHandle

Adds a new Series to the chart via CellHandles and CellRange Objects.

addSheetFromWorkBook(WorkBookHandle, String, String) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

Deprecated.

addSheetFromWorkBook(WorkBookHandle, String, String) - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated.

addSheetFromWorkBook(WorkBookHandle, String, String) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Deprecated. - use addWorkSheet(WorkSheetHandle sht, String NewSheetName){

addSheetFromWorkBook(WorkBookHandle, String, String) - Method in class com.extentech.ExtenXLS.WorkBookParser

Deprecated.

addSheetFromWorkBookWithFormatting(WorkBookHandle, String, String) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

Deprecated.

addSheetFromWorkBookWithFormatting(WorkBookHandle, String, String) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Deprecated. - use addWorkSheet(WorkSheetHandle sht, String NewSheetName){

addSheetFromWorkBookWithFormatting(WorkBookHandle, String, String) - Method in class com.extentech.ExtenXLS.WorkBookParser

Deprecated.

addSingleYSeries(String) - Method in class com.extentech.ExtenXLS.ui.jchart.JChart

addStructureChangedListener(StructureChangedListener) - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

addTableModelListener(TableModelListener) - Method in class com.extentech.ExtenXLS.eventui.WorkBookPanel

Deprecated. Use the various listeners on WorkBookModel instead.

addTableModelListener(TableModelListener) - Method in class com.extentech.ExtenXLS.ui.WorkBookPanel

addTableModelListener(TableModelListener) - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

addUser(User) - Method in class com.extentech.ExtenXLS.web.MemeDocument

add a concurrent user to the book

addValidated(Object, int, int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Add a Cell with the specified value to a WorkSheet.

addValidated(Object, int, int, int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Add a Cell with the specified value to a WorkSheet.

addValidated(Object, String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Add a Cell with the specified value to a WorkSheet.

addValidated(Timestamp, String, String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Add a java.sql.Timestamp Cell to a WorkSheet.

addValidated(Date, String, String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Add a java.sql.Date Cell to a WorkSheet.

addValidated(Date, int, int, String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Add a java.sql.Date Cell to a WorkSheet.

addWorkSheet(WorkSheetHandle, String) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

addWorkSheet(WorkSheetHandle) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

addWorkSheet(WorkSheetHandle, String) - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. Inserts a new worksheet and places it at the end of the workbook

addWorkSheet(WorkSheetHandle) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Inserts a WorkSheetHandle from a separate WorkBookhandle into the current WorkBookHandle.

addWorkSheet(WorkSheetHandle, String) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Inserts a WorkSheetHandle from a separate WorkBookhandle into the current WorkBookHandle.

addWorkSheet(WorkSheetHandle, String) - Method in class com.extentech.ExtenXLS.WorkBookParser

addWorkSheet(WorkSheetHandle) - Method in class com.extentech.ExtenXLS.WorkBookParser

addXf(Xf) - Method in class com.extentech.ExtenXLS.FormatHandle

adds all formatting represented by the sourceXf to this workbook, if not already present
This is used internally for transferring formats from one workbook to another

AdvancedFontChooser - Class in com.extentech.ExtenXLS.ui.jchart

AdvancedFontChooser(JFrame) - Constructor for class com.extentech.ExtenXLS.ui.jchart.AdvancedFontChooser

ALLOWAUTOFILTER - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Use Autofilter

ALLOWDELETECOLUMNS - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Delete columns

ALLOWDELETEROWS - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Delete rows

ALLOWDUPES - Static variable in interface com.extentech.ExtenXLS.WorkBook

Deprecated.

ALLOWFORMATCELLS - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Format cells

ALLOWFORMATCOLUMNS - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Format columns

ALLOWFORMATROWS - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Format rows

ALLOWINSERTCOLUMNS - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Insert columns

ALLOWINSERTHYPERLINKS - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Insert hyperlinks

ALLOWINSERTROWS - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Insert rows

ALLOWOBJECTS - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Edit Object

ALLOWPIVOTTABLES - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Use PivotTable reports

ALLOWSCENARIOS - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Edit scenario

ALLOWSELLOCKEDCELLS - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Select locked cells

ALLOWSELUNLOCKEDCELLS - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Select unlocked cells

ALLOWSORT - Static variable in class com.extentech.ExtenXLS.WorkSheetHandle

enhanced protection settings: Sort

ALPHASDELETE - Static variable in class com.extentech.ExtenXLS.ExcelTools

appendOutputDir(String) - Method in class com.extentech.ExtenXLS.web.MemeDocument

append to the existing outputDir, if any

appendRowCategoryToChart() - Method in class com.extentech.ExtenXLS.ChartHandle

Append a row of categories to the bottom of the chart.

appendRowCategoryToChart(int) - Method in class com.extentech.ExtenXLS.ChartHandle

Append a row of categories to the bottom of the chart.

appendRowSeriesToChart() - Method in class com.extentech.ExtenXLS.ChartHandle

Appends a series one row below the last series in the chart.

appendRowSeriesToChart(int) - Method in class com.extentech.ExtenXLS.ChartHandle

Appends a series one row below the last series in the chart for the desired chart

applyDiff(StringBuffer) - Method in class com.extentech.ExtenXLS.web.WebWorkBook

apply a single diff to a Document

AREA - Static variable in class com.extentech.ExtenXLS.ChartHandle

askQuestion(String) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSPanel

askQuestion(String) - Method in class com.extentech.ExtenXLS.ui.ExtenXLSPanel

AUTO_FORMAT_Classic - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Report1 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Report10 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Report2 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Report3 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Report4 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Report5 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Report6 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Report7 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Report8 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Report9 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Table1 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Table10 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Table2 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Table3 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Table4 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Table5 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Table6 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Table7 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Table8 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AUTO_FORMAT_Table9 - Static variable in class com.extentech.ExtenXLS.PivotTableHandle

AutoFilterHandle - Class in com.extentech.ExtenXLS

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

autoFit() - Method in class com.extentech.ExtenXLS.ColHandle

resizes this column to fit the width of all displayed, non-wrapped text.

AXExtenBean - Class in com.extentech.ExtenXLS.bean

An ActiveX Wrapper for CellBinder automations to allow use of CellBinder API within MS ActiveX applications.

AXExtenBean() - Constructor for class com.extentech.ExtenXLS.bean.AXExtenBean

B

BACKGROUNDCOLOR - Variable in class com.extentech.ExtenXLS.ui.jchart.JChart

BAR - Static variable in class com.extentech.ExtenXLS.ChartHandle

BeanBoundCell - Class in com.extentech.ExtenXLS.binder

The BeanBoundCell class extends the CellHandle class with data binding functionality
using the value Object.

BeanBoundCell() - Constructor for class com.extentech.ExtenXLS.binder.BeanBoundCell

Default Constructor.

BeanBoundCell(CellHandle, Object, String) - Constructor for class com.extentech.ExtenXLS.binder.BeanBoundCell

Create a BeanBoundCell passing in the CellHandle that it represents, the Object to which it is bound, and the field/index in the Object containing its values.

BeanBoundCell(CellHandle, Object, String, int) - Constructor for class com.extentech.ExtenXLS.binder.BeanBoundCell

Create a BeanBoundCell passing in the CellHandle that it represents, the Object to which it is bound, and the field/index in the Object containing its values.

BeanBoundCellRange - Class in com.extentech.ExtenXLS.binder

Binds a Cell range to a List of Bean values.

BeanBoundCellRange(String, WorkBook, boolean) - Constructor for class com.extentech.ExtenXLS.binder.BeanBoundCellRange

BeanInstantiationException - Exception in com.extentech.ExtenXLS.binder

BeanInstantiationException() - Constructor for exception com.extentech.ExtenXLS.binder.BeanInstantiationException

BeanInstantiationException(String) - Constructor for exception com.extentech.ExtenXLS.binder.BeanInstantiationException

BeanInstantiationException(Throwable) - Constructor for exception com.extentech.ExtenXLS.binder.BeanInstantiationException

BeanInstantiationException(String, Throwable) - Constructor for exception com.extentech.ExtenXLS.binder.BeanInstantiationException

beginTrans() - Method in class com.extentech.ExtenBean.DataObjectImpl

A simple roll-back mechanism copies the data to a backup hashtable, then waits for a commit from factory.

beginTrans() - Method in class com.extentech.ExtenBean.ExtenDataObject

A simple roll-back mechanism copies the data to a backup hashtable, then waits for a commit from factory.

beginTrans() - Method in interface com.extentech.ExtenBean.SQLObject

begintrans() - Method in class com.extentech.ExtenBean.Transaction

benchmark(String, Object) - Static method in class com.extentech.ExtenXLS.ExcelTools

tracks minimal info container for counters -> start time, last time, start mem, last mem

bind() - Method in class com.extentech.ExtenXLS.binder.SimpleCellBinder

execute the databinding, returns list of inserted rows

bindData(Map) - Method in class com.extentech.ExtenXLS.web.MemeDocument

Fetch and Merge Live Data: Returns a modified workbook

bindObject(Object, String) - Method in class com.extentech.ExtenXLS.binder.BeanBoundCell

bind a Object field in the first row of data for the Object to this CellHandle.

bindObject(Object, String, int) - Method in class com.extentech.ExtenXLS.binder.BeanBoundCell

bind a Object field to this CellHandle field.

bindObject(Object, String) - Method in interface com.extentech.ExtenXLS.binder.BoundCell

bind a Object field in the first row of data for the Object to this CellHandle.

bindObject(Object, String, int) - Method in interface com.extentech.ExtenXLS.binder.BoundCell

bind a Object field to this CellHandle field.

bindObject(Object, String) - Method in class com.extentech.ExtenXLS.binder.DataBoundCell

bind a DataObject field in the first row of data for the DataObject to this CellHandle.

bindObject(Object, String, int) - Method in class com.extentech.ExtenXLS.binder.DataBoundCell

bind a DataObject field to this CellHandle field.

bindXMLStream(String) - Method in class com.extentech.ExtenXLS.binder.CellBinder

Initializes the binding for stream-based DataBoundCellRanges Cell ranges are stored in a vector within a CellRangeDataObject.

bIsExteria() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapperFrame

bIsExteria() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapperFrame

bof - Variable in class com.extentech.ExtenBean.ExtenDataObject

book - Variable in class com.extentech.ExtenXLS.eventui.ExtenXLSPanel

book - Variable in class com.extentech.ExtenXLS.ui.ExtenXLSPanel

book - Variable in class com.extentech.ExtenXLS.ui.WorkBookPanel

BORDERCOLOR - Static variable in class com.extentech.ExtenXLS.ui.jchart.JChart

BorderStringToInt(String) - Static method in class com.extentech.ExtenXLS.FormatHandle

BoundCell - Interface in com.extentech.ExtenXLS.binder

This class represents a single WorkBook Cell which has been bound to an Object.

browser - Variable in class com.extentech.ExtenXLS.ui.WorkBookPanel

BUBBLE - Static variable in class com.extentech.ExtenXLS.ChartHandle

C

CALC_MODE_PROP - Static variable in interface com.extentech.ExtenXLS.WorkBook

Deprecated.

calculate() - Method in class com.extentech.ExtenXLS.FormulaHandle

Calculate the value of the formula and return it as an object Calling calculate will ignore the WorkBook formula calculation flags and forces calculation of the entire formula stack

CALCULATE_ALWAYS - Static variable in interface com.extentech.ExtenXLS.WorkBook

Deprecated.

CALCULATE_AUTO - Static variable in interface com.extentech.ExtenXLS.WorkBook

Deprecated.

CALCULATE_EXPLICIT - Static variable in interface com.extentech.ExtenXLS.WorkBook

Deprecated.

calculateAffectedCells() - Method in class com.extentech.ExtenXLS.CellHandle

Calculates and returns all formulas that reference this CellHandle.

calculateAffectedCells(String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Calculates all formulas that reference the cell address passed in.

calculateAffectedCellsOnSheet() - Method in class com.extentech.ExtenXLS.CellHandle

Calculates and returns all formulas on the same sheet that reference this CellHandle.

calculateFormulas() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

calculateFormulas() - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. Iterate through the formulas in this WorkBook and call the calculate method on each.

calculateFormulas() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Forces immediate recalculation of every formula in the workbook.

calculateFormulas() - Method in class com.extentech.ExtenXLS.WorkBookParser

Cell - Interface in com.extentech.ExtenXLS

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

CellBinder - Class in com.extentech.ExtenXLS.binder

The CellBinder maintains arbitrary mappings between
WorkBook CellRanges and external data sources such as a SQL Resultset.


The CellBinder uses an XML mapping file to determine which Cells in the
WorkBook to map to which values in the data source.

CellBinder(WorkBook, LogOutputter) - Constructor for class com.extentech.ExtenXLS.binder.CellBinder

The CellBinder is responsible for managing the data bindings of a single connection (JDBC) with the Cells of a single com.extentech.ExtenXLS.WorkBook.

CellBinder(WorkBook, DataObject, LogOutputter) - Constructor for class com.extentech.ExtenXLS.binder.CellBinder

The CellBinder is responsible for managing the data bindings of a single connection (JDBC) with the Cells of a single com.extentech.ExtenXLS.WorkBook.

CELLBINDER_RUN - Static variable in class com.extentech.ExtenXLS.binder.CellBinder

CellBinderUtils - Class in com.extentech.ExtenXLS.binder

Utility Class for CellBinder API

CellBinderUtils() - Constructor for class com.extentech.ExtenXLS.binder.CellBinderUtils

CELLBOUND_TEMPLATE - Static variable in class com.extentech.ExtenXLS.binder.CellBinder

CellHandle - Class in com.extentech.ExtenXLS

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

CellHandle(BiffRec) - Constructor for class com.extentech.ExtenXLS.CellHandle

Public Constructor added for use in Bean-context ONLY.

CellHandle(BiffRec, WorkBook) - Constructor for class com.extentech.ExtenXLS.CellHandle

Public Constructor added for use in Bean-context ONLY.

CellHandlingBean - Class in com.extentech.ExtenXLS.web

CellHandlingBean is a class to ease some of the rote inputting and looking up of parameters in relation to functions within the WorkBookUpdateBean.

CellParseEventListener - Interface in com.extentech.ExtenXLS

A lightweight Cell parser event listener

CellRange - Class in com.extentech.ExtenXLS

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

CellRange(CellRangeRef, boolean, boolean) - Constructor for class com.extentech.ExtenXLS.CellRange

Initializes a CellRange from a CellRangeRef.

CellRange(CellRangeRef) - Constructor for class com.extentech.ExtenXLS.CellRange

Initializes a CellRange from a CellRangeRef.

CellRange(WorkSheetHandle, int[], boolean) - Constructor for class com.extentech.ExtenXLS.CellRange

Constructor to create a new CellRange from a WorkSheetHandle and a set of range coordinates:
coords[0] = first row
coords[1] = first col
coords[2] = last row
coords[3] = last col

CellRange(WorkSheetHandle, int[]) - Constructor for class com.extentech.ExtenXLS.CellRange

Constructor to create a new CellRange from a WorkSheetHandle and a set of range coordinates:
coords[0] = first row
coords[1] = first col
coords[2] = last row
coords[3] = last col

CellRange(String) - Constructor for class com.extentech.ExtenXLS.CellRange

Constructor to Create a new CellRange from a String range
The String range must be in the format Sheet!CR:CR
For Example, "Sheet1!C9:I19"
NOTE: You MUST Set the WorkBookHandle explicitly on this CellRange or it will generate NullPointerException when trying to access the Cells.

CellRange(String, WorkBook, boolean, boolean) - Constructor for class com.extentech.ExtenXLS.CellRange

Constructor which creates a new CellRange from a String range
The String range must be in the format Sheet!CR:CR
For Example, "Sheet1!C9:I19"

CellRange(String, WorkBook, boolean) - Constructor for class com.extentech.ExtenXLS.CellRange

Constructor which creates a new CellRange from a String range
The String range must be in the format Sheet!CR:CR
For Example, "Sheet1!C9:I19"

CellRange(CellHandle[]) - Constructor for class com.extentech.ExtenXLS.CellRange

Constructor which creates a new CellRange using an array of cells as it's constructor.

CellRange(CellHandle[], boolean) - Constructor for class com.extentech.ExtenXLS.CellRange

create a new CellRange using an array of cells as it's constructor.

CellRange(String, WorkBook) - Constructor for class com.extentech.ExtenXLS.CellRange

Constructor which creates a new CellRange from a String range
The String range must be in the format Sheet!CR:CR
For Example, "Sheet1!C9:I19"

CellRangeDataObject - Class in com.extentech.ExtenXLS.binder

DataObject bound to a Cell Range.

CellRangeDataObject() - Constructor for class com.extentech.ExtenXLS.binder.CellRangeDataObject

CellRangeRef - Class in com.extentech.ExtenXLS

Represents a reference to a 3D range of cells.

CellRangeRef(int, int, int, int) - Constructor for class com.extentech.ExtenXLS.CellRangeRef

CellRangeRef(int, int, int, int, String, String) - Constructor for class com.extentech.ExtenXLS.CellRangeRef

CellRangeRef(int, int, int, int, WorkSheetHandle, WorkSheetHandle) - Constructor for class com.extentech.ExtenXLS.CellRangeRef

cells - Variable in class com.extentech.ExtenXLS.CellRange

ch - Variable in class com.extentech.ExtenXLS.eventui.ExtenXLSCellRenderer

Deprecated. No longer used internally. Should not have been public.

ch - Variable in class com.extentech.ExtenXLS.ui.ExtenXLSCellRenderer

changeCategoryRange(String, String) - Method in class com.extentech.ExtenXLS.ChartHandle

Change the Cell Range representing the Categories in the Chart.

changeDataView(String) - Method in class com.extentech.ExtenXLS.eventui.swing.DataObjectTablePanel

changeDataView(String) - Method in class com.extentech.ExtenXLS.ui.swing.DataObjectTablePanel

changeFormulaLocation(String, String) - Method in class com.extentech.ExtenXLS.FormulaHandle

Takes a string as a current formula location, and changes that pointer in the formula to the new string that is sent.

changeSeriesRange(String, String) - Method in class com.extentech.ExtenXLS.ChartHandle

Change the Cell Range referenced by one of the Series (a bar, line or wedge of data) in the Chart.

changeTextValue(String, String) - Method in class com.extentech.ExtenXLS.ChartHandle

Change the value of a Chart object.

CHARTAREACOLOR - Variable in class com.extentech.ExtenXLS.ui.jchart.JChart

ChartHandle - Class in com.extentech.ExtenXLS

Chart Handle allows for manipulation of Charts within a WorkBook.

ChartHandle(Chart, WorkBookHandle) - Constructor for class com.extentech.ExtenXLS.ChartHandle

Constructor which creates a new ChartHandle from an existing Chart Object

ChartSeriesHandle - Class in com.extentech.ExtenXLS

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

ChartSeriesHandle(Series, WorkBook) - Constructor for class com.extentech.ExtenXLS.ChartSeriesHandle

Constructor, used internally.

CHARWIDTH - Static variable in class com.extentech.ExtenXLS.eventui.swing.DataObjectTable

CHARWIDTH - Static variable in class com.extentech.ExtenXLS.ui.swing.DataObjectTable

checkNodeMatch(String, TreeNode) - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeModel

checkProtectionPassword(String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Checks whether the given password matches the protection password.

checkRange(CellHandle, ExtenXLSCellRenderer) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSCellRenderer

Check whether a CellHandle is contained in any of the Cell Ranges...

checkRange(CellHandle, ExtenXLSCellRenderer) - Method in class com.extentech.ExtenXLS.ui.ExtenXLSCellRenderer

Check whether a CellHandle is contained in any of the Cell Ranges...

children() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

CHOOSEEXISTINGXLS - Static variable in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSFileHandler

CHOOSEEXISTINGXLS - Static variable in class com.extentech.ExtenXLS.ui.swing.ExtenXLSFileHandler

clear() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeModel

Remove all nodes except the root node.

clear() - Method in class com.extentech.ExtenXLS.CellHandle

Resets this cell to the default, as if it had just been added.

clear() - Method in class com.extentech.ExtenXLS.CellRange

clears the contents and formats of the cells referenced by this range but does not remove the cells from the workbook.

clear() - Method in class com.extentech.ExtenXLS.ui.jchart.YSeries

Method to clear the YSeries of all series it contains.

clearContents() - Method in class com.extentech.ExtenXLS.CellHandle

Resets this cells contents to blank.

clearContents() - Method in class com.extentech.ExtenXLS.CellRange

clearFormats() - Method in class com.extentech.ExtenXLS.CellHandle

Resets this cell's format to the default.

clearFormats() - Method in class com.extentech.ExtenXLS.CellRange

clearPanel() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenBeanComponentPanel

clearPanel() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenBeanComponentPanel

clearParameterTable() - Method in class com.extentech.ExtenXLS.eventui.swing.ParameterTable

clearParameterTable() - Method in class com.extentech.ExtenXLS.ui.swing.ParameterTable

clone() - Method in class com.extentech.ExtenXLS.CellRangeRef

Creates and returns a copy of this range.

clone() - Method in class com.extentech.ExtenXLS.FormatHandle

Create a copy of this FormatHandle with its own Xf

cloneXf(Xf, WorkBook) - Static method in class com.extentech.ExtenXLS.FormatHandle

static version of cloneXf

cloneXf(Xf, Font, WorkBook) - Static method in class com.extentech.ExtenXLS.FormatHandle

static version of cloneXf

close() - Method in interface com.extentech.ExtenXLS.eventui.event.ActiveSheetChangedListener

close() - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

clear out object references in preparation for closing

close() - Method in class com.extentech.ExtenXLS.eventui.WorkBookPanel

close() - Method in class com.extentech.ExtenXLS.web.MemeDoc

close() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

close() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Closes the WorkBook and releases resources.

close() - Method in class com.extentech.ExtenXLS.WorkBookParser

CMP_WIDE - Static variable in class com.extentech.ExtenXLS.eventui.swing.ExtenBeanComponentPanel

CMP_WIDE - Static variable in class com.extentech.ExtenXLS.ui.swing.ExtenBeanComponentPanel

COL - Static variable in class com.extentech.ExtenXLS.ChartHandle

ColHandle - Class in com.extentech.ExtenXLS

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

colinfo - Class in com.extentech.ExtenBean

Colinfo class stores metadata information for columns selected by the DataObject's query.

colinfo(String, int) - Constructor for class com.extentech.ExtenBean.colinfo

colinfo(DatabaseMetaData, ResultSetMetaData, int) - Constructor for class com.extentech.ExtenBean.colinfo

colinfo(ResultSetMetaData, int) - Constructor for class com.extentech.ExtenBean.colinfo

colorBACKGROUND - Static variable in class com.extentech.ExtenXLS.FormatHandle

colorBORDER - Static variable in class com.extentech.ExtenXLS.FormatHandle

colorFONT - Static variable in class com.extentech.ExtenXLS.FormatHandle

Convert a converted hex string to a color int String must include beginning "#" also handle color # 9 exception

colorFOREGROUND - Static variable in class com.extentech.ExtenXLS.FormatHandle

colorToHexString(Color) - Static method in class com.extentech.ExtenXLS.FormatHandle

Convert a java.awt.Color to a hex string.

COLSIZE_DIVISOR - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COLSIZE_DIVISOR - Static variable in class com.extentech.ExtenXLS.ui.ExtenXLSTable

COLUMN - Variable in class com.extentech.ExtenXLS.CellHandle

columnMarginChanged(ChangeEvent) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

columnMarginChanged(ChangeEvent) - Method in class com.extentech.ExtenXLS.ui.ExtenXLSTable

com.extentech.ExtenBean - package com.extentech.ExtenBean

The ExtenBean package contains an Object Relational Data Object implementation used by ExtenXLS CellBinder data mapping and various data operations.

com.extentech.ExtenBean.swing - package com.extentech.ExtenBean.swing

The ExtenBean swing package contains user interface components for the ExtenBean DataObjects.

com.extentech.ExtenXLS - package com.extentech.ExtenXLS

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

com.extentech.ExtenXLS.bean - package com.extentech.ExtenXLS.bean

The ExtenXLS bean ActiveX Wrapper for CellBinder automations to allow use of CellBinder API within MS ActiveX applications.

com.extentech.ExtenXLS.binder - package com.extentech.ExtenXLS.binder

The ExtenXLS binder package contains the CellBinder API which automates mapping of data to spreadsheets.

com.extentech.ExtenXLS.eventui - package com.extentech.ExtenXLS.eventui

The ExtenXLS UI package contains swing UI spreadsheet components.

com.extentech.ExtenXLS.eventui.event - package com.extentech.ExtenXLS.eventui.event

com.extentech.ExtenXLS.eventui.swing - package com.extentech.ExtenXLS.eventui.swing

The ExtenXLS UI package contains swing UI spreadsheet components.

com.extentech.ExtenXLS.ui - package com.extentech.ExtenXLS.ui

The ExtenXLS UI package contains swing UI spreadsheet components.

com.extentech.ExtenXLS.ui.jchart - package com.extentech.ExtenXLS.ui.jchart

The ExtenXLS UI.jchart package contains swing UI charting package for spreadsheet components.

com.extentech.ExtenXLS.ui.swing - package com.extentech.ExtenXLS.ui.swing

The ExtenXLS UI package contains swing UI spreadsheet components.

com.extentech.ExtenXLS.web - package com.extentech.ExtenXLS.web

The ExtenXLS.web package contains ExtenXLS Spreadsheet classes enhanced with web and database persistence capabilities.

combine(int[], int[]) - Method in class com.extentech.ExtenXLS.CellHandle

unimplemented - do not use

COMMAND_ADDALIGNMENT - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDBORDERS - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDCELL - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDCELLDATA - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDCELLPROTECT - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDCHART - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDCHARTFONT - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDCHARTFONTREC - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDCHARTOPTIONS - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDCHARTSERIES - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDCOLORS - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDCOLUMNS - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDCONDITIONALFORMAT - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDDATARANGE - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDEXTERNALNAME - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDFONT - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDIMAGES - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDNAME - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDNUMBERFORMAT - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDPANE - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDROW - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDSHEET - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDTHREEDREC - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDVALIDATION - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDVALIDATIONFORMULA1 - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDVALIDATIONFORMULA2 - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_ADDWINDOWOPTIONS - Static variable in class com.extentech.ExtenXLS.ExtenXLS

COMMAND_AXISOPTIONS - Static variable in class com.extentech.ExtenXLS.ExtenXLS

CommentHandle - Class in com.extentech.ExtenXLS

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

commit() - Method in class com.extentech.ExtenBean.Transaction

commit() - Method in class com.extentech.ExtenXLS.web.WebWorkBook

Deprecated. for now, this is not tested anywhere, and does not seem to function, returns false, handle storage/saving issues to reimplement (see 2 commented out storeNewDocument() and save() calls below)

commitStyleChanges() - Method in class com.extentech.ExtenXLS.web.CellHandlingBean

Commits any non-null style changes to the workbook.

commitValueChanges() - Method in class com.extentech.ExtenXLS.web.CellHandlingBean

Commits any value changes to the cell.

compareTo(Object) - Method in class com.extentech.ExtenXLS.CellHandle

compare this Cell (via it's string value i.e.

completed - Variable in class com.extentech.ExtenXLS.ui.WorkBookPanel

CONDITION_BETWEEN - Static variable in class com.extentech.ExtenXLS.ConditionalFormatRule

CONDITION_BETWEEN - Static variable in class com.extentech.ExtenXLS.ValidationHandle

CONDITION_EQUAL - Static variable in class com.extentech.ExtenXLS.ConditionalFormatRule

CONDITION_EQUAL - Static variable in class com.extentech.ExtenXLS.ValidationHandle

CONDITION_GREATER_OR_EQUAL - Static variable in class com.extentech.ExtenXLS.ConditionalFormatRule

CONDITION_GREATER_OR_EQUAL - Static variable in class com.extentech.ExtenXLS.ValidationHandle

CONDITION_GREATER_THAN - Static variable in class com.extentech.ExtenXLS.ConditionalFormatRule

CONDITION_GREATER_THAN - Static variable in class com.extentech.ExtenXLS.ValidationHandle

CONDITION_LESS_OR_EQUAL - Static variable in class com.extentech.ExtenXLS.ConditionalFormatRule

CONDITION_LESS_OR_EQUAL - Static variable in class com.extentech.ExtenXLS.ValidationHandle

CONDITION_LESS_THAN - Static variable in class com.extentech.ExtenXLS.ConditionalFormatRule

CONDITION_LESS_THAN - Static variable in class com.extentech.ExtenXLS.ValidationHandle

CONDITION_NOT_BETWEEN - Static variable in class com.extentech.ExtenXLS.ConditionalFormatRule

CONDITION_NOT_BETWEEN - Static variable in class com.extentech.ExtenXLS.ValidationHandle

CONDITION_NOT_EQUAL - Static variable in class com.extentech.ExtenXLS.ConditionalFormatRule

CONDITION_NOT_EQUAL - Static variable in class com.extentech.ExtenXLS.ValidationHandle

ConditionalFormatHandle - Class in com.extentech.ExtenXLS

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 - Class in com.extentech.ExtenXLS

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

CONDITIONS - Static variable in class com.extentech.ExtenXLS.ValidationHandle

CONE - Static variable in class com.extentech.ExtenXLS.ChartHandle

CONEBAR - Static variable in class com.extentech.ExtenXLS.ChartHandle

conn - Variable in class com.extentech.ExtenBean.ExtenBeanFactory

contains(CellHandle) - Method in class com.extentech.ExtenXLS.CellRange

returns whether this CellRange contains a particular Cell

contains(int[]) - Method in class com.extentech.ExtenXLS.CellRange

returns whether this CellRange contains the specified Row/Col coordinates

contains(CellRangeRef) - Method in class com.extentech.ExtenXLS.CellRangeRef

Returns whether this range entirely contains the given range.

contains(CellHandle) - Method in class com.extentech.ExtenXLS.ConditionalFormatHandle

Determine if the conditional format contains/affects the cell handle passed in

contains(String) - Method in class com.extentech.ExtenXLS.ConditionalFormatHandle

Determines if the ConditionalFormatHandle contains the cell address passed in

containsCol(int) - Method in class com.extentech.ExtenXLS.PivotTableHandle

returns whether a given col is contained in this PivotTable

containsMergeRange() - Method in class com.extentech.ExtenXLS.ColHandle

determines if this Column passes through i.e.

containsRow(int) - Method in class com.extentech.ExtenXLS.PivotTableHandle

returns whether a given row is contained in this PivotTable

containsVerticalMergeRange() - Method in class com.extentech.ExtenXLS.RowHandle

Determines if the row passes through a vertical merge range

convertColToModel(int) - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

Gets the workbook index of a column based on its view index.

convertColToView(int) - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

Gets the view index of a column based on its workbook index.

convertData(InputStream) - Method in class com.extentech.ExtenXLS.ImageHandle

converts image data into byte array used by Jan 22, 2010

convertDocumentToInputStream(Document) - Static method in class com.extentech.ExtenXLS.web.WebWorkBook

convertFormatString(String) - Method in class com.extentech.ExtenXLS.FormatHandle

converts an Excel-style format string to a Java Format string.

CONVERTMULBLANKS - Static variable in class com.extentech.ExtenXLS.WorkBookHandle

convertPixelsToTwips(double) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

Converts pixels to Excel row height units (twips).

convertPixelsToZeros(double) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

Converts pixels to Excel column width units.

convertRowToModel(int) - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

Gets the workbook index of a row based on its view index.

convertRowToView(int) - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

Gets the view index of a row based on its workbook index.

convertStringToCalendar(String) - Static method in class com.extentech.ExtenXLS.DateConverter

Converts a string representation of a date into a valid calendar object date must be in format mm/dd/yy (or yyyy)

convertTwipsToPixels(double) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

Converts Excel row height units (twips) to pixels.

convertType(Object, String, boolean) - Static method in class com.extentech.ExtenXLS.binder.XMLBeanObjectValueAdapter

convertZerosToPixels(double) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

Converts Excel column width units to pixels.

copy(WorkSheetHandle, int, int, int) - Method in class com.extentech.ExtenXLS.CellRange

Copies this range to another location.

copy(File, File) - Static method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSFileHandler

Copy method, using FileChannel#transferTo NOTE: will overwrite existing files

copy(File, File) - Static method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSFileHandler

Copy method, using FileChannel#transferTo NOTE: will overwrite existing files

COPY_CONTENTS - Static variable in class com.extentech.ExtenXLS.CellRange

Whether to copy the cell contents.

COPY_FORMATS - Static variable in class com.extentech.ExtenXLS.CellRange

COPY_FORMULAS - Static variable in class com.extentech.ExtenXLS.CellRange

Whether formulas should be copied.

copyAskOverwrite(String, String) - Static method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSFileHandler

copyAskOverwrite(String, String) - Static method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSFileHandler

copyCellToWorkSheet(CellHandle, WorkSheetHandle, int, int) - Static method in class com.extentech.ExtenXLS.CellHandle

Creates a copy of this cell on the given worksheet at the given address.

copyCellToWorkSheet(CellHandle, WorkSheetHandle, int, int, boolean) - Static method in class com.extentech.ExtenXLS.CellHandle

Creates a copy of this cell on the given worksheet at the given address.

copyCellToWorkSheet(CellHandle, WorkSheetHandle) - Static method in class com.extentech.ExtenXLS.CellHandle

Create a copy of this Cell in another WorkBook

copyChartToSheet(ChartHandle, WorkSheetHandle) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

copyChartToSheet(String, String) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

copyChartToSheet(String, String) - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. Copies an existing Chart to another WorkSheet

copyChartToSheet(ChartHandle, WorkSheetHandle) - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. Copies an existing Chart to another WorkSheet

copyChartToSheet(String, String) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Copies an existing Chart to another WorkSheet

copyChartToSheet(ChartHandle, WorkSheetHandle) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Copies an existing Chart to another WorkSheet

copyChartToSheet(ChartHandle, WorkSheetHandle) - Method in class com.extentech.ExtenXLS.WorkBookParser

copyChartToSheet(String, String) - Method in class com.extentech.ExtenXLS.WorkBookParser

copyFormat(CellHandle) - Method in class com.extentech.ExtenXLS.CellHandle

Copy all formats from a source Cell to this Cell

copyTo(String) - Method in class com.extentech.ExtenXLS.CellHandle

copy this Cell to another location.

copyWorkSheet(String, String) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

copyWorkSheet(String, String) - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. Copy (duplicate) a worksheet in the workbook and add it to the end of the workbook with a new name

copyWorkSheet(String, String) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Copy (duplicate) a worksheet in the workbook and add it to the end of the workbook with a new name

copyWorkSheet(String, String) - Method in class com.extentech.ExtenXLS.WorkBookParser

createChart(String, WorkSheetHandle) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

createChart(String, WorkSheetHandle) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Creates a new Chart and places it at the end of the workbook

createChart(String, WorkSheetHandle) - Method in class com.extentech.ExtenXLS.WorkBookParser

createComment(String, String) - Method in class com.extentech.ExtenXLS.CellHandle

Creates a new annotation (Note or Comment) to the cell

createConditionalFormatHandle(String, String, String, String, String, String, String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Create a Conditional Format handle for a cell/range

createDom(InputStream) - Method in class com.extentech.ExtenBean.XMLDataObjectFactory

ParseXML creates the DOM based off of an xml file passed to it

createDom(InputSource) - Method in class com.extentech.ExtenBean.XMLDataObjectFactory

create Dom Document from an InputSource object 20061005 KSC

createDom() - Method in class com.extentech.ExtenBean.XMLDataObjectFactory

ParseXML creates the DOM based off of an xml file passed to it

CREATEFROMTEMPLATE - Static variable in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSFileHandler

CREATEFROMTEMPLATE - Static variable in class com.extentech.ExtenXLS.ui.swing.ExtenXLSFileHandler

createNamedRange(String, String) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

createNamedRange(String, String) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Create a named range in the workbook Note that the named range designation can conform to excel specs, that is, boolean values, references, or string variables can be set.

createNamedRange(String, String) - Method in class com.extentech.ExtenXLS.WorkBookParser

createNamedRangeDataObject(NameHandle, RelationalObject) - Method in class com.extentech.ExtenXLS.WorkBookBeanFactory

creates a named range data object based off of a name handle

createNamedRangeDataObjectX(NameHandle) - Method in class com.extentech.ExtenXLS.binder.ExtenXLSReportFactory

Create a namedRangeDataObject off of a NameHandle.

createNewDataObject(DataObject) - Method in class com.extentech.ExtenBean.ExtenBeanFactory

Gets a new instance of a dataobject including empty fields.

createNewDataObject(PageableDataObject) - Method in class com.extentech.ExtenBean.PagedDataFactory

Initialize a new, empty dataobject.

createNewDataObject(DataObject) - Method in interface com.extentech.ExtenBean.PersistenceEngine

Gets a new instance of a dataobject including empty fields.

createNewDataObject(DataObject) - Method in class com.extentech.ExtenBean.XMLDataObjectFactory

creates a new Data Object

createNewNode(PersistenceEngine, String) - Static method in class com.extentech.ExtenXLS.binder.CellBinderUtils

Create a new XMLBeanNode

createNote(String, String, String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Creates a new annotation (Note or Comment) to the worksheeet, attached to a specific cell

createNote(String, Unicodestring, String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Creates a new annotation (Note or Comment) to the worksheeet, attached to a specific cell
The note or comment is a Unicode string, thus it can contain formatting information

createPopupMenu() - Method in class com.extentech.ExtenXLS.ui.jchart.JChart

createRDF(WorkBookHandle, String, List, Object, HashMap, HashMap) - Static method in class com.extentech.ExtenXLS.binder.CellBinderUtils

Create an RDF from a template, a list of ranges and a data object of mappings

createRDFfromOfficeWriterMappings(DocumentHandle, String, List, List, HashMap) - Static method in class com.extentech.ExtenXLS.binder.CellBinderUtils

Create an RDF from a template and a list of ranges + a data object storing element info mapped to specific cells/fieldnames RoundTrip Reporting style

createValidationHandle(String, byte, byte, String, String, String, String, String, String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Create a validation handle for a cell/range

createWorkSheet(String, int) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

createWorkSheet(String) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

createWorkSheet(String) - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. Creates a new worksheet and places it at the end of the workbook

createWorkSheet(String, int) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Creates a new worksheet and places it at the specified position.

createWorkSheet(String) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Creates a new worksheet and places it at the end of the workbook.

currencyFormatMap - Static variable in class com.extentech.ExtenXLS.FormatHandle

customBindings - Class in com.extentech.ExtenXLS.binder

CustomBindings allows for conversion of OfficeWriter templates containing OfficeWriter tags into ExtenXLS CellBinder RDFs.

customBindings(String) - Constructor for class com.extentech.ExtenXLS.binder.customBindings

customBindings(String, String) - Constructor for class com.extentech.ExtenXLS.binder.customBindings

customBindings(String, String, String) - Constructor for class com.extentech.ExtenXLS.binder.customBindings

Take an OfficeWriter-style Template and create an RDF from the mappings.

CYLINDER - Static variable in class com.extentech.ExtenXLS.ChartHandle

CYLINDERBAR - Static variable in class com.extentech.ExtenXLS.ChartHandle

D

DataAccessException - Exception in com.extentech.ExtenXLS.binder

DataAccessException() - Constructor for exception com.extentech.ExtenXLS.binder.DataAccessException

DataAccessException(String) - Constructor for exception com.extentech.ExtenXLS.binder.DataAccessException

DataAccessException(Throwable) - Constructor for exception com.extentech.ExtenXLS.binder.DataAccessException

DataAccessException(String, Throwable) - Constructor for exception com.extentech.ExtenXLS.binder.DataAccessException

DataBoundCell - Class in com.extentech.ExtenXLS.binder

The DataBoundCell class extends the CellHandle class with data binding functionality
using the ExtenDataObject persistent data bean classes.

DataBoundCell() - Constructor for class com.extentech.ExtenXLS.binder.DataBoundCell

Default Constructor.

DataBoundCell(CellHandle, DataObject, String) - Constructor for class com.extentech.ExtenXLS.binder.DataBoundCell

Create a DataBoundCell passing in the CellHandle that it represents, the DataObject to which it is bound, and the field/index in the DataObject containing its values.

DataBoundCell(CellHandle, DataObject, String, int) - Constructor for class com.extentech.ExtenXLS.binder.DataBoundCell

Create a DataBoundCell passing in the CellHandle that it represents, the DataObject to which it is bound, and the field/index in the DataObject containing its values.

DataBoundCellRange - Class in com.extentech.ExtenXLS.binder

Binds a Cell range to a JDBC Recordset.

DataBoundCellRange(String, WorkBook, boolean) - Constructor for class com.extentech.ExtenXLS.binder.DataBoundCellRange

DataBoundCellRange(String, String, WorkBook, boolean) - Constructor for class com.extentech.ExtenXLS.binder.DataBoundCellRange

dataChanged(DataObject) - Method in interface com.extentech.ExtenBean.DataObjectActionListener

dataChanged(DataObject) - Method in class com.extentech.ExtenXLS.eventui.swing.DataObjectPanel

dataChanged(DataObject) - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenDataObjectPanel

dataChanged(DataObject) - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSXMLEditorPanel

dataChanged(DataObject) - Method in class com.extentech.ExtenXLS.ui.ExtenXLSCellRenderer

dataChanged(DataObject) - Method in class com.extentech.ExtenXLS.ui.swing.DataObjectPanel

dataChanged(DataObject) - Method in class com.extentech.ExtenXLS.ui.swing.ExtenDataObjectPanel

dataChanged(DataObject) - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSXMLEditorPanel

DataObject - Interface in com.extentech.ExtenBean

Interface defining a Data Object encapsulating data.

DataObjectActionListener - Interface in com.extentech.ExtenBean

Listens for DataObject Actions

dataObjectActionListeners - Variable in class com.extentech.ExtenBean.DataObjectImpl

DataObjectImpl - Class in com.extentech.ExtenBean

A concrete implementation of DataObject and RelationalObject

DataObjectImpl() - Constructor for class com.extentech.ExtenBean.DataObjectImpl

DataObjectPanel - Class in com.extentech.ExtenXLS.eventui.swing

DataObjectPanel() - Constructor for class com.extentech.ExtenXLS.eventui.swing.DataObjectPanel

DataObjectPanel - Class in com.extentech.ExtenXLS.ui.swing

DataObjectPanel() - Constructor for class com.extentech.ExtenXLS.ui.swing.DataObjectPanel

DataObjectQueryParser - Class in com.extentech.ExtenBean

This class is responsible for bi-directional query building for data objects SQL is built by default, but should also support XQuery/XPath etc.

DataObjectQueryParser() - Constructor for class com.extentech.ExtenBean.DataObjectQueryParser

DataObjectTable - Class in com.extentech.ExtenXLS.eventui.swing

DataObjectTable() - Constructor for class com.extentech.ExtenXLS.eventui.swing.DataObjectTable

DataObjectTable(TableModel) - Constructor for class com.extentech.ExtenXLS.eventui.swing.DataObjectTable

DataObjectTable - Class in com.extentech.ExtenXLS.ui.swing

DataObjectTable() - Constructor for class com.extentech.ExtenXLS.ui.swing.DataObjectTable

DataObjectTable(TableModel) - Constructor for class com.extentech.ExtenXLS.ui.swing.DataObjectTable

DataObjectTableControllerPanel - Class in com.extentech.ExtenXLS.eventui.swing

Live Display of DB

DataObjectTableControllerPanel() - Constructor for class com.extentech.ExtenXLS.eventui.swing.DataObjectTableControllerPanel

DataObjectTableControllerPanel - Class in com.extentech.ExtenXLS.ui.swing

Live Display of DB

DataObjectTableControllerPanel() - Constructor for class com.extentech.ExtenXLS.ui.swing.DataObjectTableControllerPanel

DataObjectTablePanel - Class in com.extentech.ExtenXLS.eventui.swing

DataObjectTablePanel() - Constructor for class com.extentech.ExtenXLS.eventui.swing.DataObjectTablePanel

DataObjectTablePanel(String, Connection, DataObject) - Constructor for class com.extentech.ExtenXLS.eventui.swing.DataObjectTablePanel

DataObjectTablePanel(DataObject, PersistenceEngine, DataObject) - Constructor for class com.extentech.ExtenXLS.eventui.swing.DataObjectTablePanel

DataObjectTablePanel - Class in com.extentech.ExtenXLS.ui.swing

DataObjectTablePanel() - Constructor for class com.extentech.ExtenXLS.ui.swing.DataObjectTablePanel

DataObjectTablePanel(String, Connection, DataObject) - Constructor for class com.extentech.ExtenXLS.ui.swing.DataObjectTablePanel

DataObjectTablePanel(DataObject, PersistenceEngine, DataObject) - Constructor for class com.extentech.ExtenXLS.ui.swing.DataObjectTablePanel

DateConverter - Class in com.extentech.ExtenXLS

Provides methods for conversion to and from Excel serial date values.

DateConverter() - Constructor for class com.extentech.ExtenXLS.DateConverter

dateFormatMap - Static variable in class com.extentech.ExtenXLS.FormatHandle

dbmd - Variable in class com.extentech.ExtenBean.ExtenBeanFactory

DEBUG - Static variable in class com.extentech.ExtenXLS.binder.CellBinderUtils

DEBUG - Variable in class com.extentech.ExtenXLS.CellRange

DEBUG - Variable in class com.extentech.ExtenXLS.eventui.ExtenXLSCellRenderer

Deprecated. No longer used internally. Should not have been public.

DEBUG - Variable in class com.extentech.ExtenXLS.ui.ExtenXLSCellRenderer

DEBUG - Variable in class com.extentech.ExtenXLS.ui.WorkBookPanel

DEBUG_HIGH - Static variable in interface com.extentech.ExtenXLS.Document

Deprecated.

DEBUG_LOW - Static variable in interface com.extentech.ExtenXLS.Document

Deprecated.

DEBUG_MEDIUM - Static variable in interface com.extentech.ExtenXLS.Document

Deprecated.

DEBUGLEVEL - Variable in class com.extentech.ExtenXLS.DateConverter

Deprecated. No longer used internally. Should not have been public.

debuglevel - Variable in class com.extentech.ExtenXLS.ui.WorkBookPanel

DECRYPTION_ERROR - Static variable in exception com.extentech.ExtenXLS.WorkBookException

DECRYPTION_INCORRECT_FORMAT - Static variable in exception com.extentech.ExtenXLS.WorkBookException

DECRYPTION_INCORRECT_PASSWORD - Static variable in exception com.extentech.ExtenXLS.WorkBookException

DEFAULT_COLWIDTH - Static variable in class com.extentech.ExtenXLS.ColHandle

DEFAULT_HEIGHT - Static variable in class com.extentech.ExtenXLS.ui.jchart.JChart

DEFAULT_WIDTH - Static variable in class com.extentech.ExtenXLS.ui.jchart.JChart

defaultFont - Static variable in class com.extentech.ExtenXLS.eventui.swing.ExtenBeanComponentPanel

defaultFont - Static variable in class com.extentech.ExtenXLS.ui.swing.ExtenBeanComponentPanel

DEFAULTNAME - Static variable in class com.extentech.ExtenBean.swing.XMLBeanNode

deleteChart(String, WorkSheetHandle) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

deleteChart(String, WorkSheetHandle) - Method in class com.extentech.ExtenXLS.WorkBookHandle

delete an existing chart of the workbook

deleteChart(String, WorkSheetHandle) - Method in class com.extentech.ExtenXLS.WorkBookParser

deletecol(Map) - Static method in class com.extentech.ExtenXLS.web.WorkBookUpdateBean

delete a column from the workbook, shifting all subsequent columns back one.

deleteDocument(DocumentHandle, int) - Method in class com.extentech.ExtenXLS.web.MemeDocument

Deletes the meme record

deleteRow(int) - Method in class com.extentech.ExtenXLS.NameHandle

deletes a row of cells in this named range, shifts subsequent rows up.

deleterow(Map) - Static method in class com.extentech.ExtenXLS.web.WorkBookUpdateBean

Delete a row from the worksheet

deletesheet(Map) - Static method in class com.extentech.ExtenXLS.web.WorkBookUpdateBean

Delete a sheet from the workbook

display() - Method in class com.extentech.ExtenXLS.ui.jchart.JChart

Opens a new Swing frame that displays the chart.

displaycmpPopup(DropTargetDropEvent, Object[]) - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSRowTable

popup a dialog to choose: 1.

displaycmpPopup(DropTargetDropEvent, Object[]) - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSRowTable

popup a dialog to choose: 1.

displayDebug(String) - Static method in class com.extentech.ExtenXLS.eventui.swing.StandAloneDebugger

displayDebug(Container, String, String) - Static method in class com.extentech.ExtenXLS.eventui.swing.StandAloneDebugger

displayDebug(String) - Static method in class com.extentech.ExtenXLS.ui.swing.StandAloneDebugger

displayDebug(Container, String, String) - Static method in class com.extentech.ExtenXLS.ui.swing.StandAloneDebugger

Document - Interface in com.extentech.ExtenXLS

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

DocumentHandle - Class in com.extentech.ExtenXLS

Functionality common to all document types.

DocumentHandle() - Constructor for class com.extentech.ExtenXLS.DocumentHandle

default constructor

DocumentHandle(InputStream) - Constructor for class com.extentech.ExtenXLS.DocumentHandle

Apr 5, 2011

DocumentObjectNotFoundException - Exception in com.extentech.ExtenXLS

DocumentObjectNotFoundException(String) - Constructor for exception com.extentech.ExtenXLS.DocumentObjectNotFoundException

documentStorageLocation() - Method in class com.extentech.ExtenXLS.web.MemeDocument

Where to store the document, maps to STORAGE_LOCATION ints

doparent - Variable in class com.extentech.ExtenBean.DataObjectImpl

doQuery(String) - Method in class com.extentech.ExtenBean.ExtenBeanFactory

doTest() - Method in class com.extentech.ExtenBean.XMLDOTester

DOUBLE_STREAM_FILE - Static variable in exception com.extentech.ExtenXLS.WorkBookException

DOUGHNUT - Static variable in class com.extentech.ExtenXLS.ChartHandle

doUpdate(String[]) - Method in class com.extentech.ExtenBean.ExtenBeanFactory

Perform a series UPDATE, INSERT or DELETE operations on the datastore

doUpdate(String) - Method in class com.extentech.ExtenBean.ExtenBeanFactory

Perform an UPDATE, INSERT or DELETE operation on the datastore

dragDropEnd(DragSourceDropEvent) - Method in class com.extentech.ExtenXLS.eventui.swing.ParameterTable

dragDropEnd(DragSourceDropEvent) - Method in class com.extentech.ExtenXLS.ui.swing.ParameterTable

dragEnter(DropTargetDragEvent) - Method in class com.extentech.ExtenXLS.eventui.swing.ParameterTable

dragEnter(DropTargetDragEvent) - Method in class com.extentech.ExtenXLS.ui.swing.ParameterTable

dragGestureRecognized(DragGestureEvent) - Method in class com.extentech.ExtenXLS.eventui.swing.DataObjectTable

handle the dragging of table columns

dragGestureRecognized(DragGestureEvent) - Method in class com.extentech.ExtenXLS.eventui.swing.ParameterTable

handle the dragging of table columns

dragGestureRecognized(DragGestureEvent) - Method in class com.extentech.ExtenXLS.ui.swing.DataObjectTable

handle the dragging of table columns

dragGestureRecognized(DragGestureEvent) - Method in class com.extentech.ExtenXLS.ui.swing.ParameterTable

handle the dragging of table columns

dragOver(DropTargetDragEvent) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

dragOver(DropTargetDragEvent) - Method in class com.extentech.ExtenXLS.ui.ExtenXLSTable

drop(DropTargetDropEvent) - Method in class com.extentech.ExtenXLS.eventui.swing.DataObjectTable

drop(DropTargetDropEvent) - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSRowTable

drop(DropTargetDropEvent) - Method in class com.extentech.ExtenXLS.eventui.swing.ParameterTable

drop(DropTargetDropEvent) - Method in class com.extentech.ExtenXLS.ui.swing.DataObjectTable

drop(DropTargetDropEvent) - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSRowTable

drop(DropTargetDropEvent) - Method in class com.extentech.ExtenXLS.ui.swing.ParameterTable

dropDebug(String) - Method in class com.extentech.ExtenXLS.eventui.swing.ParameterTable

dropDebug(String) - Method in class com.extentech.ExtenXLS.ui.swing.ParameterTable

dump_input - Static variable in class com.extentech.ExtenXLS.ExtenXLS

A Writer to which a record dump should be written on input.

dumpCSVtoSpreadsheet(File, WorkBook, int) - Static method in class com.extentech.ExtenXLS.ExtenXLS

simply read the csv into a workbook set the "com.extentech.extenxls.csvdelimiter" system property to change the delimiter aka: System.getProperties().setProperty("com.extentech.extenxls.csvdelimiter", "|");

dumpCSVtoSpreadsheet(InputStream, WorkBook, int) - Static method in class com.extentech.ExtenXLS.ExtenXLS

simply read the csv into a workbook set the "com.extentech.extenxls.csvdelimiter" system property to change the delimiter aka: System.getProperties().setProperty("com.extentech.extenxls.csvdelimiter", "|");

dumpNameVals() - Method in class com.extentech.ExtenBean.DataObjectImpl

a convenience method for debugging which outputs all names and values for the data in this object.

dumpNameVals(PrintStream) - Method in class com.extentech.ExtenBean.DataObjectImpl

dumpNameVals() - Method in class com.extentech.ExtenBean.ExtenDataObject

a convenience method for debugging which outputs all names and values for the data in this object.

E

EditEndEvent - Class in com.extentech.ExtenXLS.eventui.event

Event indicating the user has finished editing a cell.

EditEndEvent(ExtenXLSTable) - Constructor for class com.extentech.ExtenXLS.eventui.event.EditEndEvent

Creates a new EditEndEvent.

editEnding(EditEndEvent) - Method in interface com.extentech.ExtenXLS.eventui.event.EditEndListener

EditEndListener - Interface in com.extentech.ExtenXLS.eventui.event

Defines the method for receiving EditEndEvents.

EditStartEvent - Class in com.extentech.ExtenXLS.eventui.event

Event indicating that the user has started to edit a cell.

EditStartEvent(ExtenXLSTable, int, int, String) - Constructor for class com.extentech.ExtenXLS.eventui.event.EditStartEvent

Creates a new EditStartEvent.

editStarting(EditStartEvent) - Method in interface com.extentech.ExtenXLS.eventui.event.EditStartListener

EditStartListener - Interface in com.extentech.ExtenXLS.eventui.event

Defines the method for receiving EditStartEvents.

el - Variable in class com.extentech.ExtenXLS.eventui.ExtenXLSPanel

el - Variable in class com.extentech.ExtenXLS.ui.ExtenXLSPanel

EncryptedWorkBookHandle - Class in com.extentech.ExtenXLS

EncryptedWorkBookHandle is a WorkBookHandle that manages encrypted files.

EncryptedWorkBookHandle(String) - Constructor for class com.extentech.ExtenXLS.EncryptedWorkBookHandle

Default constructor creates a new, empty EncryptedWorkBookHandle with a password set for saveEncrypted functionality 3 WorkSheets: "Sheet1","Sheet2",and "Sheet3".

EncryptedWorkBookHandle(WorkBookHandle, String) - Constructor for class com.extentech.ExtenXLS.EncryptedWorkBookHandle

Constructor to convert a WorkBookHandle into an EncryptedWorkBookHandle.

EncryptedWorkBookHandle(InputStream, String) - Constructor for class com.extentech.ExtenXLS.EncryptedWorkBookHandle

Create a new WorkBookHandle from the byte array passed in.

ENCRYPTION_ERROR - Static variable in exception com.extentech.ExtenXLS.WorkBookException

ensureSelectedRangeIsVisible() - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSCellRenderer

examines selectedRange and ensures the range is visible

ensureSelectedRangeIsVisible() - Method in class com.extentech.ExtenXLS.ui.ExtenXLSCellRenderer

examines selectedRange and ensures the range is visible

eof - Variable in class com.extentech.ExtenBean.ExtenDataObject

equals(Object) - Method in class com.extentech.ExtenXLS.CellHandle

compare this Cells equality (via it's string value i.e.

equals(Object) - Method in class com.extentech.ExtenXLS.CellRangeRef

Compares this range to the specified object.

equals(Object) - Method in class com.extentech.ExtenXLS.FormatHandle

overrides the equals method to perform equality based on format properties ------------------------------------------------------------

equals(Object) - Method in class com.extentech.ExtenXLS.ImageHandle

Override equals so that Sheet cannot contain dupes.

equals(Object) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

ERROR_INFO - Static variable in class com.extentech.ExtenXLS.ConditionalFormatRule

ERROR_INFO - Static variable in class com.extentech.ExtenXLS.ValidationHandle

ERROR_STOP - Static variable in class com.extentech.ExtenXLS.ConditionalFormatRule

ERROR_STOP - Static variable in class com.extentech.ExtenXLS.ValidationHandle

ERROR_WARN - Static variable in class com.extentech.ExtenXLS.ConditionalFormatRule

ERROR_WARN - Static variable in class com.extentech.ExtenXLS.ValidationHandle

errorMessage(String, String) - Method in class com.extentech.ExtenXLS.eventui.swing.DataObjectPanel

errorMessage(String, String) - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenDataObjectPanel

errorMessage(String, String) - Method in class com.extentech.ExtenXLS.ui.swing.DataObjectPanel

errorMessage(String, String) - Method in class com.extentech.ExtenXLS.ui.swing.ExtenDataObjectPanel

evaluate(CellHandle) - Method in class com.extentech.ExtenXLS.ConditionalFormatHandle

evaluates the criteria for this Conditional Format
if the criteria involves a comparison i.e.

evaluate(CellHandle) - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

evaluates the criteria for this Conditional Format Rule
if the criteria involves a comparison i.e.

evaluateAutoFilters() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Updates the Row filter (hidden status) for each row on the sheet by evaluating all AutoFilter conditions

evaluatesToString() - Method in class com.extentech.ExtenXLS.FormulaHandle

If the Formula evaluates to a String, there will be a Stringrec attached to the Formula which contains the latest value.

eventMode() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

eventMode() - Method in class com.extentech.ExtenXLS.WorkBookHandle

ExcelTools - Class in com.extentech.ExtenXLS

ExtenXLS helper methods.

ExcelTools() - Constructor for class com.extentech.ExtenXLS.ExcelTools

exceptionThrown(Exception) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSWorkBookViewer

exceptionThrown(Exception) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSWorkBookViewerApplet

exceptionThrown(Exception) - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapperFrame

exceptionThrown(Exception) - Method in class com.extentech.ExtenXLS.ui.ExtenXLSWorkBookViewer

exceptionThrown(Exception) - Method in class com.extentech.ExtenXLS.ui.ExtenXLSWorkBookViewerApplet

exceptionThrown(Exception) - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapperFrame

executeCommand(Map) - Static method in class com.extentech.ExtenXLS.web.WorkBookUpdateBean

A basic reflection call to the method passed in as command.

exitApplication() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapperFrame

exitApplication() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapperFrame

EXTENBEAN_LOADER_NAME - Static variable in class com.extentech.ExtenBean.DataObjectImpl

ExtenBeanComboBoxModel - Class in com.extentech.ExtenBean.swing

ComboBoxModel backed by a DataObject

ExtenBeanComboBoxModel() - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanComboBoxModel

ExtenBeanComboBoxModel(DataObject[]) - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanComboBoxModel

ExtenBeanComponentPanel - Class in com.extentech.ExtenXLS.eventui.swing

ExtenBeanComponentPanel() - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenBeanComponentPanel

ExtenBeanComponentPanel - Class in com.extentech.ExtenXLS.ui.swing

ExtenBeanComponentPanel() - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenBeanComponentPanel

ExtenBeanFactory - Class in com.extentech.ExtenBean

A DataObjectFactory which populates the data in classes which implement the DataObject interface.

ExtenBeanFactory(Connection) - Constructor for class com.extentech.ExtenBean.ExtenBeanFactory

Allows the controller class to specify the connection

ExtenBeanFactory() - Constructor for class com.extentech.ExtenBean.ExtenBeanFactory

Blank constructor, you MUST NOW SET THE CONNECTION.

ExtenBeanListChooserFrame - Class in com.extentech.ExtenXLS.eventui.swing

ExtenBeanListChooserFrame() - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenBeanListChooserFrame

ExtenBeanListChooserFrame(String) - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenBeanListChooserFrame

ExtenBeanListChooserFrame - Class in com.extentech.ExtenXLS.ui.swing

ExtenBeanListChooserFrame() - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenBeanListChooserFrame

ExtenBeanListChooserFrame(String) - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenBeanListChooserFrame

ExtenBeanListModel - Class in com.extentech.ExtenBean.swing

ListModel backed by a DataObject

ExtenBeanListModel() - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanListModel

ExtenBeanListModel(DataObject) - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanListModel

ExtenBeanPopupTree - Class in com.extentech.ExtenXLS.eventui.swing

ExtenBeanPopupTree() - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenBeanPopupTree

ExtenBeanPopupTree(JTree) - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenBeanPopupTree

ExtenBeanPopupTree - Class in com.extentech.ExtenXLS.ui.swing

ExtenBeanPopupTree() - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenBeanPopupTree

ExtenBeanPopupTree(JTree) - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenBeanPopupTree

ExtenBeanTreeCellRenderer - Class in com.extentech.ExtenBean.swing

TreeRenderer for DataObjects

ExtenBeanTreeCellRenderer() - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanTreeCellRenderer

ExtenBeanTreeChangeListener - Interface in com.extentech.ExtenBean.swing

TreeChangeListener defines the interface for an object that listens to changes in a TreeModel.

ExtenBeanTreeModel - Class in com.extentech.ExtenBean.swing

TreeModel backed by a DataObject

ExtenBeanTreeModel(TreeNode, JTree) - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanTreeModel

Default Constructor.

ExtenBeanTreeModel(JTree) - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanTreeModel

Superclass constructor.

ExtenBeanTreeModel(TreeNode, JTree, boolean) - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanTreeModel

Superclass constructor.

ExtenBeanTreeNode - Class in com.extentech.ExtenBean.swing

An ExtenDataObject which is also a MutableTreeNode

ExtenBeanTreeNode(String) - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

ExtenBeanTreeNode() - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

ExtenBeanTreeNode(DataObject) - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

init with an alternate DataObject type

ExtenBeanTreeNode(DataObject, String) - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

init with an alternate DataObject type

ExtenBeanTreeNode(ExtenBeanTreeNode) - Constructor for class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

init with an alternate DataObject type

ExtenDataObject - Class in com.extentech.ExtenBean

The ExtenDataObject provides the functionality of a persistent entity bean.

ExtenDataObject() - Constructor for class com.extentech.ExtenBean.ExtenDataObject

ExtenDataObjectPanel - Class in com.extentech.ExtenXLS.eventui.swing

ExtenDataObjectPanel() - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenDataObjectPanel

ExtenDataObjectPanel - Class in com.extentech.ExtenXLS.ui.swing

ExtenDataObjectPanel() - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenDataObjectPanel

ExtenDataObjectTableModel - Class in com.extentech.ExtenBean.swing

TableModel backed by a DataObject

ExtenDataObjectTableModel(DataObject, PersistenceEngine) - Constructor for class com.extentech.ExtenBean.swing.ExtenDataObjectTableModel

ExtenXLS - Class in com.extentech.ExtenXLS

Useful Entry-Point for ExtenXLS functionality.

ExtenXLS() - Constructor for class com.extentech.ExtenXLS.ExtenXLS

ExtenXLSBeanLauncher - Class in com.extentech.ExtenXLS.bean

ExtenXLSBeanLauncher() - Constructor for class com.extentech.ExtenXLS.bean.ExtenXLSBeanLauncher

ExtenXLSCellRenderer - Class in com.extentech.ExtenXLS.eventui

Provides a cell renderer for WorkBooks.

ExtenXLSCellRenderer() - Constructor for class com.extentech.ExtenXLS.eventui.ExtenXLSCellRenderer

ExtenXLSCellRenderer - Class in com.extentech.ExtenXLS.ui

Provides a cell renderer for WorkBooks

ExtenXLSCellRenderer() - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSCellRenderer

ExtenXLSCellRenderer(WorkSheetTableModel) - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSCellRenderer

ExtenXLSFileHandler - Class in com.extentech.ExtenXLS.eventui.swing

Governs all XLS/DOML file choosing and template operations

ExtenXLSFileHandler() - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenXLSFileHandler

Default constructor retrieves resources from ExtenXLSMapperWizard.properties file

ExtenXLSFileHandler - Class in com.extentech.ExtenXLS.ui.swing

Governs all XLS/DOML file choosing and template operations

ExtenXLSFileHandler() - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenXLSFileHandler

Default constructor retrieves resources from ExtenXLSMapperWizard.properties file

ExtenXLSMapPanel - Class in com.extentech.ExtenXLS.eventui.swing

ExtenXLSMapPanel() - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapPanel

ExtenXLSMapPanel(JTree) - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapPanel

ExtenXLSMapPanel - Class in com.extentech.ExtenXLS.ui.swing

ExtenXLSMapPanel() - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapPanel

ExtenXLSMapPanel(JTree) - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapPanel

ExtenXLSMapperFrame - Class in com.extentech.ExtenXLS.eventui.swing

ExtenXLSMapperFrame(Container) - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapperFrame

ExtenXLSMapperFrame() - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapperFrame

ExtenXLSMapperFrame - Class in com.extentech.ExtenXLS.ui.swing

ExtenXLSMapperFrame(Container) - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapperFrame

ExtenXLSMapperFrame() - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapperFrame

ExtenXLSPanel - Class in com.extentech.ExtenXLS.eventui

Provides a basic tabbed panel for WorkBooks

ExtenXLSPanel() - Constructor for class com.extentech.ExtenXLS.eventui.ExtenXLSPanel

ExtenXLSPanel - Class in com.extentech.ExtenXLS.ui

Provides a basic tabbed panel for WorkBooks

ExtenXLSPanel(JInternalFrame) - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSPanel

ExtenXLSPanel() - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSPanel

ExtenXLSReportFactory - Class in com.extentech.ExtenXLS.binder

This class is responsible for managing ExtenXLS Reporting
sessions for a single ExtenXLS Report.


Provides:

- shared XLS template instance
- manages CellBinders

ExtenXLSReportFactory(LogOutputter, String) - Constructor for class com.extentech.ExtenXLS.binder.ExtenXLSReportFactory

Constructor for the Factory which takes a logger and a full path to the working directory.

ExtenXLSReportFactory(LogOutputter) - Constructor for class com.extentech.ExtenXLS.binder.ExtenXLSReportFactory

Constructor which takes a logger

ExtenXLSRowTable - Class in com.extentech.ExtenXLS.eventui.swing

A Row Table for XLS Files.

ExtenXLSRowTable(WorkBookModel) - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenXLSRowTable

ExtenXLSRowTable - Class in com.extentech.ExtenXLS.ui.swing

A Row Table for XLS Files.

ExtenXLSRowTable() - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenXLSRowTable

ExtenXLSRowTable(WorkSheetTableModel) - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenXLSRowTable

ExtenXLSScrollPaneUI - Class in com.extentech.ExtenXLS.eventui

Had to implement this to fix problem with unsycnhronized row headers step one disable drag update of VSB -- click thru works

ExtenXLSScrollPaneUI - Class in com.extentech.ExtenXLS.ui

Had to implement this to fix problem with unsycnhronized row headers step one disable drag update of VSB -- click thru works

ExtenXLSScrollPaneUI.myHSBChangeListener - Class in com.extentech.ExtenXLS.eventui

ExtenXLSScrollPaneUI.myHSBChangeListener() - Constructor for class com.extentech.ExtenXLS.eventui.ExtenXLSScrollPaneUI.myHSBChangeListener

ExtenXLSScrollPaneUI.myHSBChangeListener - Class in com.extentech.ExtenXLS.ui

ExtenXLSScrollPaneUI.myHSBChangeListener() - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSScrollPaneUI.myHSBChangeListener

ExtenXLSScrollPaneUI.myViewportChangeHandler - Class in com.extentech.ExtenXLS.eventui

ExtenXLSScrollPaneUI.myViewportChangeHandler() - Constructor for class com.extentech.ExtenXLS.eventui.ExtenXLSScrollPaneUI.myViewportChangeHandler

ExtenXLSScrollPaneUI.myViewportChangeHandler - Class in com.extentech.ExtenXLS.ui

ExtenXLSScrollPaneUI.myViewportChangeHandler() - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSScrollPaneUI.myViewportChangeHandler

ExtenXLSScrollPaneUI.myVSBChangeListener - Class in com.extentech.ExtenXLS.eventui

ExtenXLSScrollPaneUI.myVSBChangeListener() - Constructor for class com.extentech.ExtenXLS.eventui.ExtenXLSScrollPaneUI.myVSBChangeListener

ExtenXLSScrollPaneUI.myVSBChangeListener - Class in com.extentech.ExtenXLS.ui

ExtenXLSScrollPaneUI.myVSBChangeListener() - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSScrollPaneUI.myVSBChangeListener

ExtenXLSTable - Class in com.extentech.ExtenXLS.eventui

ExtenXLSTable(WorkBookModel) - Constructor for class com.extentech.ExtenXLS.eventui.ExtenXLSTable

ExtenXLSTable - Class in com.extentech.ExtenXLS.ui

Provides a basic tabbed panel for WorkBooks

ExtenXLSTable() - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSTable

ExtenXLSTable(int, int) - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSTable

ExtenXLSTable(WorkSheetTableModel) - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSTable

ExtenXLSTable(WorkSheetTableModel, TableColumnModel) - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSTable

ExtenXLSTable(WorkSheetTableModel, TableColumnModel, ListSelectionModel) - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSTable

ExtenXLSTableModel - Interface in com.extentech.ExtenXLS.ui

Provides ability to work with Row Names

ExtenXLSTableUI - Class in com.extentech.ExtenXLS.eventui

Override BasicTableUI to enable Cell Spanning

ExtenXLSTableUI() - Constructor for class com.extentech.ExtenXLS.eventui.ExtenXLSTableUI

ExtenXLSTableUI - Class in com.extentech.ExtenXLS.ui

Override BasicTableUI to enable Cell Spanning

ExtenXLSTableUI() - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSTableUI

ExtenXLSWorkBookViewer - Class in com.extentech.ExtenXLS.eventui

Java Swing Spreadsheet User Interface
Provides basic formatting, execution of formulas, ability to add and edit Cells, and ability to create new, edit existing, and save WorkBooks.

ExtenXLSWorkBookViewer() - Constructor for class com.extentech.ExtenXLS.eventui.ExtenXLSWorkBookViewer

ExtenXLSWorkBookViewer(String) - Constructor for class com.extentech.ExtenXLS.eventui.ExtenXLSWorkBookViewer

Constructor which takes a file path.

ExtenXLSWorkBookViewer - Class in com.extentech.ExtenXLS.ui

Java Swing Spreadsheet User Interface
Provides basic formatting, execution of formulas, ability to add and edit Cells, and ability to create new, edit existing, and save WorkBooks.

ExtenXLSWorkBookViewer() - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSWorkBookViewer

ExtenXLSWorkBookViewer(String) - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSWorkBookViewer

Constructor which takes a file path.

ExtenXLSWorkBookViewerApplet - Class in com.extentech.ExtenXLS.eventui

A basic WorkBook User Interface
Provides basic formatting, execution of formulas, ability to add and edit Cells, and ability to create new, edit existing, and save WorkBooks.

ExtenXLSWorkBookViewerApplet(String) - Constructor for class com.extentech.ExtenXLS.eventui.ExtenXLSWorkBookViewerApplet

Constructor which takes a file path.

ExtenXLSWorkBookViewerApplet - Class in com.extentech.ExtenXLS.ui

A basic WorkBook User Interface
Provides basic formatting, execution of formulas, ability to add and edit Cells, and ability to create new, edit existing, and save WorkBooks.

ExtenXLSWorkBookViewerApplet(String) - Constructor for class com.extentech.ExtenXLS.ui.ExtenXLSWorkBookViewerApplet

Constructor which takes a file path.

ExtenXLSXMLEditorPanel - Class in com.extentech.ExtenXLS.eventui.swing

A panel for editing XML

ExtenXLSXMLEditorPanel(ExtenXLSMapperFrame) - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenXLSXMLEditorPanel

ExtenXLSXMLEditorPanel(Boolean) - Constructor for class com.extentech.ExtenXLS.eventui.swing.ExtenXLSXMLEditorPanel

This constructor is used by the getGUIBuilderInstance method to provide an instance of this class which has not had it's GUI elements initialized (ie, initGUI is not called in this constructor).

ExtenXLSXMLEditorPanel - Class in com.extentech.ExtenXLS.ui.swing

A panel for editing XML

ExtenXLSXMLEditorPanel(ExtenXLSMapperFrame) - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenXLSXMLEditorPanel

ExtenXLSXMLEditorPanel(Boolean) - Constructor for class com.extentech.ExtenXLS.ui.swing.ExtenXLSXMLEditorPanel

This constructor is used by the getGUIBuilderInstance method to provide an instance of this class which has not had it's GUI elements initialized (ie, initGUI is not called in this constructor).

extractChartToDirectory(String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

retrieves all charts for this sheet and writes them (in SVG form) to outpdir
Filename is in form of: _Chart<#>.svg

extractImagesToDirectory(String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

write out all of the images in the Sheet to a directory

F

factory - Variable in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSRowTable

factory - Variable in class com.extentech.ExtenXLS.ui.swing.ExtenXLSRowTable

fastAdd(Object, int, int, int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Fast-adds a Cell with the specified value to a WorkSheet.

FILE_TYPE_NATIVE - Static variable in class com.extentech.ExtenXLS.web.MemeDocument

FILE_TYPE_XLS - Static variable in class com.extentech.ExtenXLS.web.MemeDocument

FILE_TYPE_XLSX - Static variable in class com.extentech.ExtenXLS.web.MemeDocument

FILE_TYPE_XMLSS - Static variable in class com.extentech.ExtenXLS.web.MemeDocument

finalize() - Method in class com.extentech.ExtenBean.ExtenBeanFactory

Close all open resources and destroy object.

finalize() - Method in class com.extentech.ExtenBean.XMLDataObjectFactory

perform cleanup

findColumn(String) - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

findTokens(WorkBook) - Method in class com.extentech.ExtenXLS.binder.SimpleCellBinder

returns a list of all cells within the workbook containing the mapping tokens.

finpath - Variable in class com.extentech.ExtenXLS.ui.WorkBookPanel

fireCellFocusChanged(CellHandle) - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

fireDataObjectActionEvent(DataObject) - Method in interface com.extentech.ExtenBean.DataObject

fires a DataObjectAction event

fireDataObjectActionEvent(DataObject) - Method in class com.extentech.ExtenBean.DataObjectImpl

fireEmptyCellFocusChanged(Object, int, int) - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

fireEvent(Cell) - Method in interface com.extentech.ExtenXLS.CellParseEventListener

when a cell record is parsed, an event is fired, passing the Cell object to the listeners for implementation-specific handling.

fireParserEvent() - Method in class com.extentech.ExtenXLS.CellHandle

this method will be fired as each record is parsed from an input Spreadsheet Dec 15, 2010

fireParserEvent() - Method in class com.extentech.ExtenXLS.SimpleCellValue

this method will be fired as each record is parsed from an input Spreadsheet Dec 15, 2010

fireParserEvent() - Method in class com.extentech.ExtenXLS.WorkBookParser

notify the registered listeners of a parse event

fireTableChanged(TableModelEvent) - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

FONTCOLOR - Variable in class com.extentech.ExtenXLS.ui.jchart.JChart

fontNames - Static variable in class com.extentech.ExtenXLS.ui.jchart.AdvancedFontChooser

fontSizes - Static variable in class com.extentech.ExtenXLS.ui.jchart.AdvancedFontChooser

FORMAT_NATIVE - Static variable in class com.extentech.ExtenXLS.DocumentHandle

Format constant for the most appropriate format for this document.

FORMAT_XLS - Static variable in class com.extentech.ExtenXLS.WorkBookHandle

Format constant for BIFF8 (Excel '97-2007).

FORMAT_XLSM - Static variable in class com.extentech.ExtenXLS.WorkBookHandle

Format constant for macro-enabled OOXML (Excel 2007).

FORMAT_XLSX - Static variable in class com.extentech.ExtenXLS.WorkBookHandle

Format constant for normal OOXML (Excel 2007).

FORMAT_XLTM - Static variable in class com.extentech.ExtenXLS.WorkBookHandle

Format constant for macro-enabled OOXML template (Excel 2007).

FORMAT_XLTX - Static variable in class com.extentech.ExtenXLS.WorkBookHandle

Format constant for OOXML template (Excel 2007).

FormatCache - Class in com.extentech.ExtenXLS

Deprecated.

FormatCache() - Constructor for class com.extentech.ExtenXLS.FormatCache

Deprecated.

formatcells(Map) - Static method in class com.extentech.ExtenXLS.web.WorkBookUpdateBean

Formats the cells passed in with the formatting patterns passed in.

FormatHandle - Class in com.extentech.ExtenXLS

Provides methods for querying and changing cell formatting information.

FormatHandle() - Constructor for class com.extentech.ExtenXLS.FormatHandle

Nullary constructor for use in bean context.

FormatHandle(WorkBook, Xf) - Constructor for class com.extentech.ExtenXLS.FormatHandle

Constructs a FormatHandle for the given WorkBook and format record.

FormatHandle(WorkBook) - Constructor for class com.extentech.ExtenXLS.FormatHandle

Constructs a FormatHandle for the given WorkBook's default format.

FormatHandle(WorkBook, int) - Constructor for class com.extentech.ExtenXLS.FormatHandle

Constructs a FormatHandle for the given format ID and WorkBook.

FormatHandle(CellHandle) - Constructor for class com.extentech.ExtenXLS.FormatHandle

Creates a FormatHandle for the given cell.

FormatHandle(WorkBook, String, int, int) - Constructor for class com.extentech.ExtenXLS.FormatHandle

FormatHandle(WorkBook, int) - Constructor for class com.extentech.ExtenXLS.FormatHandle

Jan 27, 2011

formatLocation(int[]) - Static method in class com.extentech.ExtenXLS.ExcelTools

Takes an int array representing a row and column and formats it as a cell address.

formatLocation(int[], boolean, boolean) - Static method in class com.extentech.ExtenXLS.ExcelTools

Takes an int array representing a row and column and formats it as a cell address, taking into account relative or absolute refs The index is zero-based.

formatNumericNotation(String, int) - Static method in class com.extentech.ExtenXLS.ExcelTools

Formats a string representation of a numeric value as a string in the specified notation:

formatRange(int[]) - Static method in class com.extentech.ExtenXLS.ExcelTools

Takes an array of four shorts and formats it as a cell range.

formatRangeRowCol(int[]) - Static method in class com.extentech.ExtenXLS.ExcelTools

format a range as a string, range in format of [r][c][r1][c1]

formatRangeRowCol(int[], boolean[]) - Static method in class com.extentech.ExtenXLS.ExcelTools

format a range as a string, range in format of [r][c][r1][c1] including relative address state

FormulaHandle - Class in com.extentech.ExtenXLS

Formula Handle allows for manipulation of Formulas within a WorkBook.

foutpath - Variable in class com.extentech.ExtenXLS.ui.WorkBookPanel

freezeCol(int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

freezes the cols starting at the specified column and creating a scrollable sheet to the right

freezeRow(int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

freezes the rows starting at the specified row and creating a scrollable sheet below this row

fromA1(String) - Static method in class com.extentech.ExtenXLS.CellRangeRef

Parses a range in A1 notation and returns the equivalent CellRangeRef.

fromA1(String, WorkBookHandle) - Static method in class com.extentech.ExtenXLS.CellRangeRef

Convenience method combining CellRangeRef.fromA1(String) and CellRangeRef.resolve(WorkBookHandle).

G

GenerateRDF - Class in com.extentech.ExtenXLS.binder

GenerateRDF() - Constructor for class com.extentech.ExtenXLS.binder.GenerateRDF

GenerateRDF(String) - Constructor for class com.extentech.ExtenXLS.binder.GenerateRDF

GenerateRDF(String, int) - Constructor for class com.extentech.ExtenXLS.binder.GenerateRDF

generateReport(String, String, String) - Method in class com.extentech.ExtenXLS.bean.AXExtenBean

Generates a report from an Input Rdf, and optional Output Rdf and an output filename.

generateReport(String, String, String, HashMap) - Method in class com.extentech.ExtenXLS.binder.ExtenXLSReportFactory

Generates a report from an Input Rdf, and optional Output Rdf and an output filename.

generateReport(Map) - Method in class com.extentech.ExtenXLS.binder.ExtenXLSReportFactory

this method returns a byte array containing an XLS report populated with values from the CellBinder.

generateWorkBookHandle(Map, boolean) - Method in class com.extentech.ExtenXLS.binder.ExtenXLSReportFactory

this method returns a WorkBookHandle populated with values from the CellBinder.

generateWorkBookHandle(Map) - Method in class com.extentech.ExtenXLS.binder.ExtenXLSReportFactory

this method returns a WorkBookHandle populated with values from the CellBinder.

generateXMLReport(Map, String) - Method in class com.extentech.ExtenXLS.binder.XMLCellBinder

Generate Report and convert the output to XML

GenericDataObject - Class in com.extentech.ExtenBean

A basic DataObject implementation.

GenericDataObject() - Constructor for class com.extentech.ExtenBean.GenericDataObject

GenericDataObject(String) - Constructor for class com.extentech.ExtenBean.GenericDataObject

get(Object) - Method in class com.extentech.ExtenBean.ExtenDataObject

implementation of Input Validation interface

get(Object) - Method in class com.extentech.ExtenXLS.binder.NamedRangeDataObject

get(FormatHandle) - Method in class com.extentech.ExtenXLS.FormatCache

Deprecated.

get(String) - Method in class com.extentech.ExtenXLS.FormatCache

Deprecated.

get2DSheetName() - Method in class com.extentech.ExtenXLS.NameHandle

return the sheetname for a 2D named range NOTE: Does not work for 3D ranges

getAbsolutePage() - Method in class com.extentech.ExtenBean.ExtenDataObject

getAbsolutePage() - Method in interface com.extentech.ExtenBean.PageableDataObject

getActiveCell() - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

Returns the current active cell.

getActiveColumn() - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

getActiveRow() - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

getActiveSheet() - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

Returns the current active sheet.

getAddedRows() - Method in class com.extentech.ExtenXLS.binder.DataBoundCellRange

getAddedrows() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

getAddress() - Method in class com.extentech.ExtenXLS.CommentHandle

Returns the address this Note (Comment) is attached to

getAllAffectedRanges() - Method in class com.extentech.ExtenXLS.ConditionalFormatHandle

Return a string representing all ranges that this conditional format handle can affect

getAllBorderColors() - Method in class com.extentech.ExtenXLS.FormatHandle

return the 5 border line colors (l, r, t, b, diag)

getAllBorderLineStyles() - Method in class com.extentech.ExtenXLS.FormatHandle

return the 5 border lines styles (l, r, t, b, diag)

getAllChartSeriesHandles() - Method in class com.extentech.ExtenXLS.ChartHandle

Returns an array of ChartSeriesHandle Objects, one for each bar, line or wedge of data.

getAllChartSeriesHandles(int) - Method in class com.extentech.ExtenXLS.ChartHandle

Returns an array of ChartSeriesHandle Objects for the desired chart, one for each bar, line or wedge of data.

getAllChildrenInHeirarchy() - Method in class com.extentech.ExtenBean.DataObjectImpl

returns a vector containing all of the children of this object, as well as all of the children of the children objects, their children's children, and any other children hanging about.

getAllChildrenInHeirarchy() - Method in interface com.extentech.ExtenBean.RelationalObject

getAllChildrenInHeirarchy() - Method in class com.extentech.ExtenBean.RelationalObjectImpl

returns a vector containing all of the children of this object, as well as all of the children of the children objects.

getAllDiffs(int) - Method in class com.extentech.ExtenXLS.web.MemeDocument

retrieves ordered list of all differences for this meme_id

getAllowsChildren() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

getAllParamString() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenDataObjectPanel

return all of the parameters for this report -- YES ALL OF THEM!

getAllParamString() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenDataObjectPanel

return all of the parameters for this report -- YES ALL OF THEM!

getAllSeriesDataJSON() - Method in class com.extentech.ExtenXLS.ChartHandle

returns a JSON representation of all Series Data (Legend, Categogies, Series Values) for the chart
This is an internal method that is not useful to the end user.

getAllStrings() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getAllStrings() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Returns all strings that are in the SharedStringTable for this workbook.

getAllStrings() - Method in class com.extentech.ExtenXLS.WorkBookParser

getAllStringsInDocument() - Method in class com.extentech.ExtenXLS.web.MemeDoc

getAllStringsInDocument() - Method in class com.extentech.ExtenXLS.web.MemeDocument

getAllStringsInDocument() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

Get all strings in the SST separated by crlf

getAllText() - Method in class com.extentech.ExtenXLS.web.MemeDoc

getAllValidationHandles() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Return all validation handles that refer to this worksheet

getAlphaVal(int) - Static method in class com.extentech.ExtenXLS.ExcelTools

get the Excel-style Column alphabetical representation of an integer (0-based).

getAspectRatio() - Method in class com.extentech.ExtenXLS.ImageHandle

returns width divided by height for the aspect ratio

getAttributes() - Method in class com.extentech.ExtenXLS.ui.jchart.AdvancedFontChooser

getAuthor() - Method in class com.extentech.ExtenXLS.CommentHandle

returns the author of this Note (Comment) if set

getAutoAlign() - Method in class com.extentech.ExtenXLS.PivotTableHandle

get whether Alignment Autoformat is applied

getAutoBorder() - Method in class com.extentech.ExtenXLS.PivotTableHandle

get whether Border Autoformat is applied

getAutoFilterHandles() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Returns a list of all AutoFilterHandles on this sheet
An AutoFilterHandle allows access and manipulation of AutoFilters on the sheet

getAutoFont() - Method in class com.extentech.ExtenXLS.PivotTableHandle

get whether Font Autoformat is applied

getAutoFormatId() - Method in class com.extentech.ExtenXLS.PivotTableHandle

get the auto format for the Table

getAutoNumber() - Method in class com.extentech.ExtenXLS.PivotTableHandle

get whether Number Autoformat is applied

getAutoPattern() - Method in class com.extentech.ExtenXLS.PivotTableHandle

get whether Pattern Autoformat is applied

getAutoWidthHeight() - Method in class com.extentech.ExtenXLS.PivotTableHandle

get whether Width/Height Autoformat is applied

getAwtFont() - Method in class com.extentech.ExtenXLS.CellHandle

convert the ExtenXLS font used by this Cell to java.awt.Font

getAxis(int) - Method in class com.extentech.ExtenXLS.ChartHandle

returns the desired axis (creates if doesn't exist)

getAxisAutomaticScale(int) - Method in class com.extentech.ExtenXLS.ChartHandle

Returns true if the desired Value axis is set to automatic scale

getAxisAutomaticScale() - Method in class com.extentech.ExtenXLS.ChartHandle

Returns true if the Y Axis (Value axis) is set to automatic scale

getAxisFont() - Method in class com.extentech.ExtenXLS.ChartHandle

return the Font associated with the Chart Axes

getAxisMajorUnit(int) - Method in class com.extentech.ExtenXLS.ChartHandle

Returns the major tick unit of the desired Value axis

getAxisMajorUnit() - Method in class com.extentech.ExtenXLS.ChartHandle

Returns the major tick unit of the Y Axis (Value Axis)

getAxisMaxScale(int) - Method in class com.extentech.ExtenXLS.ChartHandle

Returns the maximum scale value of the desired Value axis

getAxisMaxScale() - Method in class com.extentech.ExtenXLS.ChartHandle

Returns the maximum value of the Y Axis (Value Axis) scale

getAxisMinorUnit(int) - Method in class com.extentech.ExtenXLS.ChartHandle

Returns the minor tick unit of the desired Value axis

getAxisMinorUnit() - Method in class com.extentech.ExtenXLS.ChartHandle

Returns the minor tick unit of the Y Axis (Value Axis)

getAxisMinScale(int) - Method in class com.extentech.ExtenXLS.ChartHandle

Returns the minimum scale value of the the desired Value axis

getAxisMinScale() - Method in class com.extentech.ExtenXLS.ChartHandle

Returns the minimum value of the Y Axis (Value Axis) scale

getAxisOptions(int) - Method in class com.extentech.ExtenXLS.ChartHandle

getAxisPlacement(int) - Method in class com.extentech.ExtenXLS.ChartHandle

Returns the Axis Label Placement or position as an int

getBackgroundColor() - Method in class com.extentech.ExtenXLS.CellHandle

get the Color of the Cell Background by this Cell and all other cells sharing this FormatId.

getBackgroundColor() - Method in class com.extentech.ExtenXLS.FormatHandle

get the Pattern Background Color for this Format Pattern

getBackgroundColor() - Method in class com.extentech.ExtenXLS.web.CellHandlingBean

getBackgroundPattern() - Method in class com.extentech.ExtenXLS.CellHandle

get the Background Pattern for this cell

getBeanLoader() - Static method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

getBeanPanel() - Method in class com.extentech.ExtenXLS.eventui.swing.XMLEditorPanel

getBeanPanel() - Method in class com.extentech.ExtenXLS.ui.swing.XMLEditorPanel

getBOF() - Method in class com.extentech.ExtenBean.ExtenDataObject

getBOF() - Method in interface com.extentech.ExtenBean.PageableDataObject

getBold() - Method in class com.extentech.ExtenXLS.FormatHandle

Get if the font is bold

getBook(int) - Method in class com.extentech.ExtenXLS.web.MemeDocument

Deprecated.

getBook() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

get the underlying WorkBookHandle delegate

getBooleanVal() - Method in class com.extentech.ExtenXLS.CellHandle

returns the value of this Cell as a boolean
If the Cell is not of type Boolean, returns false

getBorder(CellHandle) - Static method in class com.extentech.ExtenXLS.eventui.ExtenXLSCellRenderer

getBorder(CellHandle) - Static method in class com.extentech.ExtenXLS.ui.ExtenXLSCellRenderer

getBorderBottomColor() - Method in class com.extentech.ExtenXLS.FormatHandle

Get the Right border color

getBorderColors() - Method in class com.extentech.ExtenXLS.CellHandle

returns Border Colors of Cell in: top, left, bottom, right order
returns null or a java.awt.Color object for each of 4 sides

getBorderColors() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

retrieves the border colors for the current Conditional Format

getBorderColors() - Method in class com.extentech.ExtenXLS.FormatHandle

returns Border Colors of Cell ie: top, left, bottom, right returns null or 1 color for each of 4 sides 1,1,1,1 represents a border all around the cell 1,1,0,0 represents on the top left edge of the cell

getBorderLeftColor() - Method in class com.extentech.ExtenXLS.FormatHandle

Get the Left border color

getBorderLineColorBottom() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

returns the bottom border line color for the current Conditional Format

getBorderLineColorLeft() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

returns the left border line color for the current Conditional Format

getBorderLineColorRight() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

returns the right border line color for the current Conditional Format

getBorderLineColorTop() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

returns the top border line color for the current Conditional Format

getBorderLineStylesBottom() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

returns the bottom border line style for the current Conditional Format

getBorderLineStylesLeft() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getBorderLineStylesRight() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getBorderLineStylesTop() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getBorderRightColor() - Method in class com.extentech.ExtenXLS.FormatHandle

Get the Right border color

getBorderSizes() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getBorderStyles() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getBorderTopColor() - Method in class com.extentech.ExtenXLS.FormatHandle

Get the Top border color

getBottomBorderLineStyle() - Method in class com.extentech.ExtenXLS.FormatHandle

Get the border line style

getBottomMargin() - Method in class com.extentech.ExtenXLS.PrinterSettingsHandle

Gets the bottom print margin.

getBounds() - Method in class com.extentech.ExtenXLS.ChartHandle

returns the coordinates or bounds (position, width and height) of this chart in pixels

getBounds() - Method in class com.extentech.ExtenXLS.ImageHandle

return the image bounds images bounds are as follows: bounds[0]= column # of top left position (0-based) of the shape bounds[1]= x offset within the top-left column (0-1023) bounds[2]= row # for top left corner bounds[3]= y offset within the top-left corner (0-1023) bounds[4]= column # of the bottom right corner of the shape bounds[5]= x offset within the cell for the bottom-right corner (0-1023) bounds[6]= row # for bottom-right corner of the shape bounds[7]= y offset within the cell for the bottom-right corner (0-1023)

getBrowser() - Method in class com.extentech.ExtenXLS.eventui.WorkBookPanel

Deprecated. No longer used internally. Should not have been public.

getBrowser() - Method in class com.extentech.ExtenXLS.ui.WorkBookPanel

getBubbleSizes() - Method in class com.extentech.ExtenXLS.ChartSeriesHandle

returns the Cell Range String representing Bubble Size for this Series (Bubble Charts only)

getButtonPanel() - Method in class com.extentech.ExtenXLS.eventui.swing.XMLEditorPanel

getButtonPanel() - Method in class com.extentech.ExtenXLS.ui.swing.XMLEditorPanel

getByName(Container, String) - Static method in class com.extentech.ExtenXLS.eventui.swing.StandAloneDebugger

getByName(Container, String) - Static method in class com.extentech.ExtenXLS.ui.swing.StandAloneDebugger

getBytes() - Method in class com.extentech.ExtenBean.XMLDataObjectFactory

output the DOM to file

getBytes() - Method in class com.extentech.ExtenXLS.CellHandle

returns the low-level bytes for the underlying BIFF8 record.

getBytes() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

Deprecated.

getBytes() - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. Returns a byte Array containing the valid file containing this WorkBook and associated Storages (such as VB files and PivotTables.) This is the actual file data and that can be read from and written to FileOutputStreams and ServletOutputStreams.

getBytes() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Deprecated. Writing the spreadsheet to a byte array uses a great deal of memory and generally provides no benefit over streaming output. Use the WorkBookHandle.write(java.lang.String) family of methods instead. If you need a byte array use ByteArrayOutputStream.

getBytes() - Method in class com.extentech.ExtenXLS.WorkBookParser

Deprecated.

getCalcAlways() - Method in class com.extentech.ExtenXLS.FormulaHandle

return the "Calculate Always" setting for this formula used for formulas that always need calculating such as TODAY

getCalculatedValue() - Method in class com.extentech.ExtenXLS.NameHandle

return the calculated value of this Name if it contains a parsed Expression (Formula)

getCalendar() - Static method in class com.extentech.ExtenXLS.DateConverter

Gets a clone of the calendar used for date calculation.

getCalendarFromCell(Cell) - Static method in class com.extentech.ExtenXLS.DateConverter

Gets the Calendar for the given cell.

getCalendarFromCellWithPrecision(Cell, int) - Static method in class com.extentech.ExtenXLS.DateConverter

returns a Java Calendar from a CellHandle containing an Excel-formatted Date The Excel date format does not map 100% accurately to Java dates, due to the limitation of the precision of the Excel floating-point value record.

getCalendarFromNumber(double) - Static method in class com.extentech.ExtenXLS.DateConverter

Gets the Calendar for the given Excel serial date.

getCalendarFromNumber(Object) - Static method in class com.extentech.ExtenXLS.DateConverter

Deprecated. Use DateConverter.getCalendarFromNumber(double) instead.

getCascadeUpdates() - Method in interface com.extentech.ExtenBean.DataObject

get whether or not to cascade the updates to child dataobjects

getCascadeUpdates() - Method in class com.extentech.ExtenBean.DataObjectImpl

get whether or not to cascade the updates to child dataobjects

getCategories() - Method in class com.extentech.ExtenXLS.ChartHandle

Returns an ordered array of strings representing all the category ranges in the chart.

getCategoryDataType() - Method in class com.extentech.ExtenXLS.ChartSeriesHandle

gets the Chart Category Data Type

getCategoryNode(PersistenceEngine, String) - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

pass a factory and a node type this method will look up node values in properties file and populate TreeNode particulars such as icons etc.

getCategoryRange() - Method in class com.extentech.ExtenXLS.ChartSeriesHandle

returns the Cell Range String representing the Categories (usually the X Axis) for the Chart
Note that Category typically stays constant for all Series in the Chart

getCell() - Method in class com.extentech.ExtenXLS.CellHandle

return the underlying cell record
for internal API use only

getCell() - Method in class com.extentech.ExtenXLS.eventui.event.EditStartEvent

Gets the address of the cell being edited.

getCell(String) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getCell(String) - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. Returns the Cell at the specified Location

getCell(String) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Returns the Cell at the specified Location

getCell(String) - Method in class com.extentech.ExtenXLS.WorkBookParser

getCell(String) - Method in interface com.extentech.ExtenXLS.WorkSheet

Returns a CellHandle for working with the value of a Cell on a WorkSheet.

getCell(int, int) - Method in interface com.extentech.ExtenXLS.WorkSheet

Returns a CellHandle for working with the value of a Cell on a WorkSheet.

getCell(String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Returns a CellHandle for working with the value of a Cell on a WorkSheet.

getCell(int, int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Returns a CellHandle for working with the value of a Cell on a WorkSheet.

getCell(int, int, boolean) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Returns a CellHandle for working with the value of a Cell on a WorkSheet.

getCellAddress() - Method in interface com.extentech.ExtenXLS.Cell

Returns the Address of this Cell as a String.

getCellAddress() - Method in class com.extentech.ExtenXLS.CellHandle

Returns the Address of this Cell as a String.

getCellAddress() - Method in class com.extentech.ExtenXLS.FormulaHandle

Returns the cell Address of the formula

getCellAddress() - Method in class com.extentech.ExtenXLS.SimpleCellValue

getCellAt(int, int) - Method in interface com.extentech.ExtenXLS.ui.ExtenXLSTableModel

getCellAt(int, int) - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

nice caching cell lookup

getCellAttribute() - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

getCellBackgroundColor() - Method in class com.extentech.ExtenXLS.CellHandle

Return the cell background color i.e.

getCellBackgroundColor() - Method in class com.extentech.ExtenXLS.FormatHandle

get the Pattern Background Color for this Formatted Cell This method handles display of conditional formats for the cell checks for conditional format, then applies it if conditions are true.

getCellEditor(int, int) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

Returns an appropriate editor for the specified cell.

getcellhandles(Map) - Static method in class com.extentech.ExtenXLS.web.WorkBookUpdateBean

Primarily set up for testing purposes, but I figure there's got to be some sort of useful thing to do with this.

getCellHandlesFromSheet(String, WorkSheetHandle) - Static method in class com.extentech.ExtenXLS.ExcelTools

Return an array of cell handles specified from the string passed in.

getCellList() - Method in class com.extentech.ExtenXLS.CellRange

Return a list of the cells in this cell range

getCellRange() - Method in class com.extentech.ExtenXLS.PivotTableHandle

getCellRange() - Method in class com.extentech.ExtenXLS.web.CellHandlingBean

getCellRanges() - Method in class com.extentech.ExtenXLS.FormulaHandle

Initialize CellRanges referenced by this formula

getCellRanges() - Method in class com.extentech.ExtenXLS.NameHandle

Get an Array of CellRanges, one per referenced WorkSheet.

getCellRanges() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getCellRanges() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Returns an Array of the CellRanges existing in this WorkBook specifically the Ranges referenced in Formulas, Charts, and Named Ranges.

getCellRanges() - Method in class com.extentech.ExtenXLS.WorkBookParser

getCellRangeVector() - Method in class com.extentech.ExtenXLS.binder.CellRangeDataObject

getCellRangeXML(boolean) - Method in class com.extentech.ExtenXLS.CellRange

gets the array of Cells in this Name NOTE: this method variation also returns the Sheetname for the name record if not null.

getCellRangeXML(boolean) - Method in class com.extentech.ExtenXLS.NameHandle

gets the array of Cells in this Name NOTE: this method variation also returns the Sheetname for the name record if not null.

getCellRangeXML() - Method in class com.extentech.ExtenXLS.NameHandle

gets the array of Cells in this Name

getCellRecs() - Method in class com.extentech.ExtenXLS.CellRange

get the underlying Cell Records in this range
NOTE: Cell Records are not a part of the public API and are not intended for use in client applications.

getCellRect(int, int, boolean) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

getCellRect(int, int, boolean) - Method in class com.extentech.ExtenXLS.ui.ExtenXLSTable

getCellRenderer(int, int) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

Returns an appropriate renderer for the specified cell.

getCellRotation() - Method in class com.extentech.ExtenXLS.CellHandle

Get the rotation of this Cell in degrees.

getCellRotation() - Method in class com.extentech.ExtenXLS.FormatHandle

Get the rotation of the cell.

getCells() - Method in class com.extentech.ExtenXLS.CellRange

get the Cells in this cell range

getCells(String, WorkBookHandle) - Static method in class com.extentech.ExtenXLS.CellRange

returns the cells for a given range
static version

getCells() - Method in class com.extentech.ExtenXLS.ColHandle

returns the array of Cells in this Column

getCells() - Method in class com.extentech.ExtenXLS.FormatHandle

Get the List of Cells for this FormatHandle

getCells() - Method in class com.extentech.ExtenXLS.NameHandle

gets the array of Cells in this Name

getCells(boolean) - Method in class com.extentech.ExtenXLS.RowHandle

Returns the array of Cells in this Row

getCells() - Method in class com.extentech.ExtenXLS.RowHandle

Returns the array of Cells in this Row

getCells() - Method in class com.extentech.ExtenXLS.web.CellHandlingBean

Get all the cellHandles referenced in this CellInfo.

getCells() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getCells() - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. Returns all of the Cells contained in the WorkBook

getCells() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Returns an array containing all cells in the WorkBook

getCells() - Method in class com.extentech.ExtenXLS.WorkBookParser

getCells() - Method in interface com.extentech.ExtenXLS.WorkSheet

Returns all CellHandles defined on this WorkSheet.

getCells() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Returns all CellHandles defined on this WorkSheet.

getCellTextField() - Method in class com.extentech.ExtenXLS.eventui.WorkBookPanel

Deprecated. No longer used internally. Should not have been public.

getCellTextField() - Method in class com.extentech.ExtenXLS.ui.WorkBookPanel

getCellType() - Method in interface com.extentech.ExtenXLS.Cell

getCellType() - Method in class com.extentech.ExtenXLS.CellHandle

Returns the type of the Cell as an int
TYPE_STRING = 0, TYPE_FP = 1, TYPE_INT = 2, TYPE_FORMULA = 3, TYPE_BOOLEAN = 4, TYPE_DOUBLE = 5;

getCellType() - Method in class com.extentech.ExtenXLS.SimpleCellValue

getCellTypeName() - Method in class com.extentech.ExtenXLS.CellHandle

returns the java Type string of the Cell
One of: "String" "Float" "Integer" "Formula" "Double"

getChangedRowCount() - Method in interface com.extentech.ExtenBean.DataObject

getChangedRowCount() - Method in class com.extentech.ExtenBean.DataObjectImpl

getChangedRowCount() - Method in class com.extentech.ExtenBean.ExtenDataObject

getChangedRows() - Method in interface com.extentech.ExtenBean.DataObject

getChangedRows() - Method in class com.extentech.ExtenBean.DataObjectImpl

getChangedRows() - Method in class com.extentech.ExtenBean.ExtenDataObject

getChart(String) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getChart(String) - Method in class com.extentech.ExtenXLS.web.WebDoc

May 16, 2010

getChart(String) - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. Returns a Chart Handle

getChart(String) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Returns a Chart Handle

getChart(String) - Method in class com.extentech.ExtenXLS.WorkBookParser

getChartById(int) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getChartById(int) - Method in class com.extentech.ExtenXLS.WorkBookHandle

retrieve a ChartHandle via id

getChartById(int) - Method in class com.extentech.ExtenXLS.WorkBookParser

getChartBytes() - Method in class com.extentech.ExtenXLS.ChartHandle

Get the Chart's bytes This is an internal method that is not useful to the end user.

getChartDrawingOOXML(int) - Method in class com.extentech.ExtenXLS.ChartHandle

generates the OOXML specific for DrawingML, specifying offsets and identifying the chart object.

getChartEmbeds() - Method in class com.extentech.ExtenXLS.ChartHandle

returns the drawingml file name which defines the userShape (if any)
a userShape is a drawing or shape ontop of a chart associated with this chart

getChartFontRecsXML() - Method in class com.extentech.ExtenXLS.ChartHandle

returns Chart-specific Font Records in XML form

getChartFontsXML() - Method in class com.extentech.ExtenXLS.ChartHandle

Return non-axis Chart font ids in XML form

getCharts() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getCharts() - Method in class com.extentech.ExtenXLS.web.WebDoc

May 16, 2010

getCharts() - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. Returns all Chart Handles contained in the WorkBook

getCharts() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Returns all Chart Handles contained in the WorkBook

getCharts() - Method in class com.extentech.ExtenXLS.WorkBookParser

getChartSeriesAddition() - Method in class com.extentech.ExtenXLS.binder.DataBoundCellRange

getChartSeriesBase() - Method in class com.extentech.ExtenXLS.binder.DataBoundCellRange

getChartSeriesHandle(String) - Method in class com.extentech.ExtenXLS.ChartHandle

Get the ChartSeriesHandle representing Chart Series Data (Series and Categories) for the specified Series range

getChartSeriesHandle(int) - Method in class com.extentech.ExtenXLS.ChartHandle

Get the ChartSeriesHandle representing Chart Series Data (Series and Categories) for the specified Series index

getChartSeriesHandleByName(String) - Method in class com.extentech.ExtenXLS.ChartHandle

Get the ChartSeriesHandle representing Chart Series Data (Series and Categories) for the Series specified by label (legend)

getChartType() - Method in class com.extentech.ExtenXLS.ChartHandle

Return an int corresponding to this ChartHandle's Chart Type for the default chart
To see possible Chart Types, view the public static int's in ChartHandle.

getChartType(int) - Method in class com.extentech.ExtenXLS.ChartHandle

Return an int corresponding to this ChartHandle's Chart Type for the specified chart
To see possible Chart Types, view the public static int's in ChartHandle.

getChildAt(int) - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

getChildByName(String) - Method in interface com.extentech.ExtenBean.DataObject

getChildByName(String) - Method in class com.extentech.ExtenBean.DataObjectImpl

Find a child DataObject

getChildCount() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

getChildNodeType() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

getChildObjects() - Method in class com.extentech.ExtenBean.DataObjectImpl

getChildObjects() - Method in class com.extentech.ExtenBean.ExtenDataObject

getChildObjects() - Method in interface com.extentech.ExtenBean.RelationalObject

return a Listof all Child Objects

getChildObjects() - Method in class com.extentech.ExtenBean.RelationalObjectImpl

getChildrenByName(String) - Method in class com.extentech.ExtenBean.DataObjectImpl

Find all child DataObjects by name

getCol() - Method in class com.extentech.ExtenXLS.AutoFilterHandle

returns the column this AutoFilter is applied to
NOTE: this may not be 100% exact

getCol() - Method in class com.extentech.ExtenXLS.CellHandle

Returns the ColHandle for the Cell.

getCol() - Method in class com.extentech.ExtenXLS.ImageHandle

return the leftmost column of the image

getCol(int) - Method in interface com.extentech.ExtenXLS.WorkSheet

returns the Column at the index position

getCol(String) - Method in interface com.extentech.ExtenXLS.WorkSheet

returns the Column at the named position

getCol(int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

returns the ColHandle for the column at index position the column index is zero based ie: column A = 0

getCol(String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

returns the Column at the named position

getCol1() - Method in class com.extentech.ExtenXLS.ImageHandle

return the rightmost column of the image

getColAndOffset() - Method in class com.extentech.ExtenXLS.ImageHandle

get the position of the top left corner of the image in the sheet

getColDelim() - Method in class com.extentech.ExtenBean.colinfo

getColDimensions() - Method in class com.extentech.ExtenXLS.RowHandle

return the min/max columns defined for this row

getColFirst() - Method in class com.extentech.ExtenXLS.ColHandle

returns the first Column referenced by this column handle
NOTE: A Column handle may in some circumstances refer to a range of columns

getColFirst() - Method in class com.extentech.ExtenXLS.PivotTableHandle

get the first Column in the PivotTable

getColFirstData() - Method in class com.extentech.ExtenXLS.PivotTableHandle

get the first Column containing data

getColinfo() - Method in interface com.extentech.ExtenBean.DataObject

Returns the column metadata for this row of data.

getColinfo() - Method in class com.extentech.ExtenBean.DataObjectImpl

getColinfo() - Method in class com.extentech.ExtenBean.ExtenDataObject

getColinfo() - Method in class com.extentech.ExtenBean.JSONDataObject

getColinfo() - Method in interface com.extentech.ExtenBean.SimpleDataObject

Returns the column metadata for this row of data.

getColinfo() - Method in class com.extentech.ExtenXLS.binder.NamedRangeDataObject

getColinfoByName(String) - Method in interface com.extentech.ExtenBean.DataObject

getColinfoByName(String) - Method in class com.extentech.ExtenBean.DataObjectImpl

getColinfoByName(String) - Method in class com.extentech.ExtenBean.ExtenDataObject

getColinfoByName(String) - Method in class com.extentech.ExtenBean.JSONDataObject

getColinfoByName(String) - Method in interface com.extentech.ExtenBean.SimpleDataObject

getColinfoByName(String) - Method in class com.extentech.ExtenXLS.binder.NamedRangeDataObject

getColInts() - Method in class com.extentech.ExtenXLS.CellRange

returns an array of column numbers referenced by this CellRange

getColLabel(int) - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

Returns the label for the given column.

getCollapsedIcon() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

getColLast() - Method in class com.extentech.ExtenXLS.ColHandle

returns the last Column referenced by this column handle
NOTE: A Column handle may in some circumstances refer to a range of columns

getColLast() - Method in class com.extentech.ExtenXLS.PivotTableHandle

get the last Column in the PivotTable

getColnames() - Method in interface com.extentech.ExtenBean.DataObject

getColNames() - Method in class com.extentech.ExtenBean.DataObjectImpl

getColnames() - Method in class com.extentech.ExtenBean.DataObjectImpl

getColNames() - Method in class com.extentech.ExtenBean.JSONDataObject

return the JSON Array Ojbect field names

getColNames() - Method in interface com.extentech.ExtenBean.SimpleDataObject

returns a list of the colnames

getColNames() - Method in interface com.extentech.ExtenXLS.WorkSheet

returns a Vector of Column names

getColNames() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

returns a List of Column names

getColNum() - Method in class com.extentech.ExtenBean.colinfo

getColNum() - Method in interface com.extentech.ExtenXLS.Cell

Returns the column number of this Cell.

getColNum() - Method in class com.extentech.ExtenXLS.CellHandle

Returns the column number of this Cell.

getColNum() - Method in class com.extentech.ExtenXLS.CommentHandle

return the Column this note is attached to

getColNum() - Method in class com.extentech.ExtenXLS.SimpleCellValue

getColNumByName(String) - Method in interface com.extentech.ExtenBean.DataObject

Find the column number in the data array which contains the column represented by this columnname.

getColNumByName(String) - Method in class com.extentech.ExtenBean.DataObjectImpl

Find the column number in the data array which contains the column represented by this columnname.

getColNumByName(String) - Method in class com.extentech.ExtenBean.ExtenDataObject

Find the column number in the data array which contains the column represented by this columnname.

getColNumByName(String) - Method in class com.extentech.ExtenXLS.binder.NamedRangeDataObject

Return the column number by name

getColor() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

Returns the color used to draw the text.

getColor(int) - Static method in class com.extentech.ExtenXLS.FormatHandle

returns the index of the Color within the Colortable

getColor() - Method in class com.extentech.ExtenXLS.web.CellHandlingBean

getColorInt(Color) - Static method in class com.extentech.ExtenXLS.FormatHandle

returns the index of the Color within the Colortable

getCols() - Method in class com.extentech.ExtenXLS.CellRange

Returns an array of Columns (ColHandles) referenced by this CellRange

getColsHaveGrandTotals() - Method in class com.extentech.ExtenXLS.PivotTableHandle

get whether table displays a column grand total

getColumn() - Method in class com.extentech.ExtenXLS.eventui.event.EditStartEvent

Gets the column of the cell being edited.

getColumnCount() - Method in class com.extentech.ExtenBean.swing.ExtenDataObjectTableModel

getColumnCount() - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

getColumnName() - Method in class com.extentech.ExtenBean.colinfo

getColumnName(int) - Method in class com.extentech.ExtenBean.swing.ExtenDataObjectTableModel

getColumnName(int) - Method in class com.extentech.ExtenXLS.ui.WorkSheetTableModel

getColumns() - Method in interface com.extentech.ExtenXLS.WorkSheet

returns all of the Columns in this WorkSheet

getColumns() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

returns all of the Columns in this WorkSheet

getColWidthInTableUnits(int) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

getColWidthInTableUnits(int) - Method in class com.extentech.ExtenXLS.ui.ExtenXLSTable

getColWidthInXLSUnits(int) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

getColWidthInXLSUnits(int) - Method in class com.extentech.ExtenXLS.ui.ExtenXLSTable

getComment() - Method in class com.extentech.ExtenXLS.CellHandle

Get a CommentHandle to the note attached to this cell

getCommentHandles() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

returns an array of all CommentHandles that exist in the sheet

getCommentText() - Method in class com.extentech.ExtenXLS.CommentHandle

Returns the text of the Note (Comment)

getComponentPanel() - Method in class com.extentech.ExtenXLS.eventui.swing.PropertiesPanel

getComponentPanel() - Method in class com.extentech.ExtenXLS.ui.swing.PropertiesPanel

getCon() - Method in class com.extentech.ExtenXLS.binder.CellBinder

returns initialized DB Factory connection

getConcurrentUsers() - Method in class com.extentech.ExtenXLS.web.MemeDocument

getConditionalFormatHandles() - Method in class com.extentech.ExtenXLS.CellHandle

return all the ConditionalFormatHandles for this Cell, if any

getConditionalFormatHandles() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

returns an array of FormatHandles for the ConditionalFormats applied to this cell

getConditionalFormatId() - Method in class com.extentech.ExtenXLS.CellHandle

get the conditional formatting record ID (FormatId)
returns the normal FormatId if the condition(s) in the conditional format have not been met

getConditionalFormats() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getConditionalFormats() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Returns an array of all Conditional Formats in the workbook these are formats referenced and used by the conditionally formatted ranges in the workbook.

getConditionalFormats() - Method in class com.extentech.ExtenXLS.WorkBookParser

getConditionalFormatType() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getConditionallyFormattedHandles() - Method in class com.extentech.ExtenXLS.CellHandle

returns an array of FormatHandles for the Cell that have the current conditional format applied to them.

getConditionNumber(String) - Static method in class com.extentech.ExtenXLS.ConditionalFormatRule

Get the byte representing the condition type string passed in.

getConditionNumber(String) - Static method in class com.extentech.ExtenXLS.ValidationHandle

Get the byte representing the condition type string passed in.

getConn() - Method in class com.extentech.ExtenBean.ExtenBeanFactory

getConnection() - Method in class com.extentech.ExtenXLS.binder.CellBinder

Returns connection DataObject for this cellbinder

getConnection() - Method in class com.extentech.ExtenXLS.web.MemeDocument

getConnectionName() - Method in class com.extentech.ExtenXLS.eventui.swing.DataObjectTableControllerPanel

getConnectionName() - Method in class com.extentech.ExtenXLS.ui.swing.DataObjectTableControllerPanel

getConnections() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapPanel

getConnections() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapPanel

getConnectionVector() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapPanel

getConnectionVector() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapPanel

getCoords() - Method in class com.extentech.ExtenXLS.ChartHandle

returns the coordinates (position, width and height) of this chart in pixels

getCoords() - Method in class com.extentech.ExtenXLS.ImageHandle

return the image bounds in x, y, width, height format in pixels

getCopies() - Method in class com.extentech.ExtenXLS.PrinterSettingsHandle

get the number of copies to print

getCreateBlanks() - Method in class com.extentech.ExtenXLS.CellRange

gets whether this CellRange will add blank records to the WorkBook for any missing Cells contained within the range.

getCryptPass() - Method in class com.extentech.ExtenXLS.web.MemeDocument

getCurrdir() - Method in class com.extentech.ExtenXLS.eventui.swing.XMLEditorPanel

getCurrdir() - Method in class com.extentech.ExtenXLS.ui.swing.XMLEditorPanel

getCurrentDataObject() - Method in class com.extentech.ExtenXLS.eventui.swing.DataObjectTableControllerPanel

returns the active dataobject shown in the grid

getCurrentDataObject() - Method in class com.extentech.ExtenXLS.ui.swing.DataObjectTableControllerPanel

returns the active dataobject shown in the grid

getCurrentNode() - Method in class com.extentech.ExtenXLS.eventui.swing.DataObjectTableControllerPanel

getCurrentNode() - Method in class com.extentech.ExtenXLS.ui.swing.DataObjectTableControllerPanel

getCurrentSeries() - Method in class com.extentech.ExtenXLS.ChartHandle

retrieves current series and axis scale info in JSONObject form used upon chart updating
This is an internal method that is not useful to the end user.

getData() - Method in interface com.extentech.ExtenBean.DataObject

getData() - Method in class com.extentech.ExtenBean.DataObjectImpl

getData() - Method in class com.extentech.ExtenBean.ExtenDataObject

getDataArray() - Method in class com.extentech.ExtenBean.DataObjectImpl

This returns only the first row of the data array as an array of objects.

getDataArray() - Method in class com.extentech.ExtenBean.ExtenDataObject

This returns only the first row of the data array as an array of objects.

getDataFactory() - Method in class com.extentech.ExtenXLS.web.MemeDocument

getDatamapping() - Method in class com.extentech.ExtenXLS.web.MemeDocument

getDataMarkers(WorkBookHandle, String) - Static method in class com.extentech.ExtenXLS.binder.CellBinderUtils

create 2 List objects from workbook - a list of ranges and a list of mappings This is used with OfficeWriter-style mappings

getDataObject(int) - Method in class com.extentech.ExtenBean.ExtenDataObject

get a new DataObject from this collection of Data.

getDataObject(int) - Method in class com.extentech.ExtenBean.GenericDataObject

get a new DataObject from this collection of Data.

getDataObject(int) - Method in class com.extentech.ExtenBean.JSONDataObject

get a new DataObject from this one

getDataObject(int) - Method in interface com.extentech.ExtenBean.SimpleDataObject

Poplulate a new Singular DataObject from this multi-row DataObject.

getDataObject() - Method in class com.extentech.ExtenBean.swing.ExtenBeanComboBoxModel

getDataObject() - Method in class com.extentech.ExtenBean.swing.ExtenBeanListModel

getDataObject(int) - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

get a new DataObject from this collection of Data.

getDataObject(int) - Method in class com.extentech.ExtenBean.XMLDataObject

get a new DataObject from this one

getDataObject(int) - Method in class com.extentech.ExtenXLS.binder.NamedRangeDataObject

getDataObject() - Method in class com.extentech.ExtenXLS.eventui.swing.DataObjectTablePanel

getDataObject() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenBeanComponentPanel

getDataObject() - Method in class com.extentech.ExtenXLS.ui.swing.DataObjectTablePanel

getDataObject() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenBeanComponentPanel

getDataObjectActionListeners() - Method in interface com.extentech.ExtenBean.DataObject

retrurns all of the DataObjectActionListeners for this DataObject

getDataObjectActionListeners() - Method in class com.extentech.ExtenBean.DataObjectImpl

getDataObjectPanel() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapperFrame

getDataObjectPanel() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapperFrame

getDataObjects() - Method in class com.extentech.ExtenXLS.binder.ExtenXLSReportFactory

getDataObjectVals(Object, String, String[], int) - Method in class com.extentech.ExtenXLS.binder.XMLBeanObjectValueAdapter

getDataRow(int) - Method in interface com.extentech.ExtenBean.DataObject

Get the data fields as an array of objects.

getDataRow(int) - Method in class com.extentech.ExtenBean.DataObjectImpl

get the data Object Array at the specified index.

getDataRow(int) - Method in class com.extentech.ExtenBean.ExtenDataObject

get the data Object Array at the specified index.

getDataRow(int) - Method in class com.extentech.ExtenBean.JSONDataObject

getDataRow(int) - Method in interface com.extentech.ExtenBean.SimpleDataObject

Get the data fields as an array of objects.

getDataRow(int) - Method in class com.extentech.ExtenXLS.binder.NamedRangeDataObject

getDateFormat() - Method in class com.extentech.ExtenBean.ExtenBeanFactory

getDateFromCell(CellHandle) - Static method in class com.extentech.ExtenXLS.DateConverter

Gets the Date for the given cell.

getDateFromNumber(double) - Static method in class com.extentech.ExtenXLS.DateConverter

Gets the Date for the given Excel serial date.

getDateFromNumber(Object) - Static method in class com.extentech.ExtenXLS.DateConverter

Deprecated. Use DateConverter.getDateFromNumber(double) instead.

getDBConnectionCellBinders() - Method in class com.extentech.ExtenXLS.binder.ExtenXLSReportFactory

getDEBUG() - Method in class com.extentech.ExtenXLS.bean.AXExtenBean

getDefaultEditor(Class) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

Returns the default editor for the specified class.

getDefaultFileString(int) - Method in class com.extentech.ExtenXLS.web.MemeDocument

Deprecated. use Storage

getDefaultIcon() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

getDefaultRenderer(Class) - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

Returns the default renderer for the specified class.

getDefaultURL() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

Display a default web page or other URL for this DataObject.

getDefaultVal() - Method in class com.extentech.ExtenXLS.CellHandle

Get the default "empty" data value for this CellHandle

getDelegate() - Method in class com.extentech.ExtenBean.JSONDataObject

getDelim() - Method in class com.extentech.ExtenBean.colinfo

getDiff(Document, Document) - Method in class com.extentech.ExtenXLS.web.WebWorkBook

getDiffs() - Method in class com.extentech.ExtenXLS.web.WebWorkBook

return an Iterator of diff history -- list[0] is the most current changes, applying list[0] to the current document brings it back 1 version.

getDLbls() - Method in class com.extentech.ExtenXLS.ChartSeriesHandle

returns the OOXML (Open Office XML) Data Label Properties Object for this Series

getDocument() - Method in class com.extentech.ExtenBean.XMLDataObjectFactory

return the underlying XML document

getDocumentBytes(Document) - Static method in class com.extentech.ExtenXLS.ExtenXLS

output the DOM to ByteArrayOutputStream

getDOLookupField() - Method in interface com.extentech.ExtenBean.DataObject

getDOLookupField() - Method in class com.extentech.ExtenBean.DataObjectImpl

getDOLookupField() - Method in class com.extentech.ExtenBean.ExtenDataObject

getDOPanel() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapperFrame

getDOPanel() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapperFrame

getDoubleVal() - Method in class com.extentech.ExtenXLS.CellHandle

returns the value of this Cell as a double, if possible, or NaN if Cell value cannot be converted to double

getDoubleVal() - Method in class com.extentech.ExtenXLS.FormulaHandle

If the Formula evaluates to a double, return the value as an double.

getDPt() - Method in class com.extentech.ExtenXLS.ChartSeriesHandle

returns an array of OOXML (Open Office XML) Data Point Properties Objects defining this Series

getDraft() - Method in class com.extentech.ExtenXLS.PrinterSettingsHandle

get the draft quality setting

getEdgePositions(CellHandle, int) - Method in class com.extentech.ExtenXLS.CellRange

returns edge status of the desired CellHandle within this CellRange ie: top, left, bottom, right
returns 0 or 1 for 4 sides
1,1,1,1 is a single cell in a range 1,1,0,0 is on the top left edge of the range

getEditCols() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

get the fields to display in the console determines which fields are editable through the interface

getEditComponents() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenBeanComponentPanel

getEditComponents() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenBeanComponentPanel

getElement() - Method in class com.extentech.ExtenBean.swing.XMLBeanNode

getElementAt(int) - Method in class com.extentech.ExtenBean.swing.ExtenBeanComboBoxModel

getElementAt(int) - Method in class com.extentech.ExtenBean.swing.ExtenBeanListModel

getEncompassingRange() - Method in class com.extentech.ExtenXLS.ConditionalFormatHandle

Return the range of data this ConditionalFormatHandle refers to as a string This location is the largest bounding rectangle that all cells utilized in this conditional format can be contained in.

getEnhancedProtection(int) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

returns true if the indicated Enhanced Protection Setting is turned on

getEOF() - Method in class com.extentech.ExtenBean.ExtenDataObject

getEOF() - Method in interface com.extentech.ExtenBean.PageableDataObject

getErrorBoxText() - Method in class com.extentech.ExtenXLS.ValidationHandle

Get the text from the error box.

getErrorBoxTitle() - Method in class com.extentech.ExtenXLS.ValidationHandle

Get the title from the error box

getErrorStyle() - Method in class com.extentech.ExtenXLS.ValidationHandle

Return a byte representing the error style for this ValidationHandle These map to the static final ints ERROR_* in ValidationHandle

getExpandedIcon() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

getExpandedXML() - Method in class com.extentech.ExtenXLS.NameHandle

getExpressionString() - Method in class com.extentech.ExtenXLS.NameHandle

returns the name's formula String for the range definition

getExtenBeanTreeNode(int) - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

getExtenXLSCellRenderer() - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

getExtenXLSCellRenderer() - Method in interface com.extentech.ExtenXLS.eventui.SheetTable

getExtenXLSCellRenderer() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSRowTable

getExtenXLSCellRenderer() - Method in class com.extentech.ExtenXLS.ui.ExtenXLSTable

getExtenXLSCellRenderer() - Method in interface com.extentech.ExtenXLS.ui.SheetTable

getExtenXLSCellRenderer() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSRowTable

getFactory() - Method in interface com.extentech.ExtenBean.DataObject

getFactory() - Method in class com.extentech.ExtenBean.DataObjectImpl

provide a handle to the factory for EJB-style persistence.

getFactory() - Method in class com.extentech.ExtenXLS.eventui.swing.DataObjectTableControllerPanel

getFactory() - Method in class com.extentech.ExtenXLS.eventui.swing.XMLBeanEditorPanel

getFactory() - Method in class com.extentech.ExtenXLS.eventui.swing.XMLEditorPanel

getFactory() - Method in class com.extentech.ExtenXLS.ui.swing.DataObjectTableControllerPanel

getFactory() - Method in class com.extentech.ExtenXLS.ui.swing.XMLBeanEditorPanel

getFactory() - Method in class com.extentech.ExtenXLS.ui.swing.XMLEditorPanel

getFactory() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getFactory() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Gets the internal Factory object.

getFactory() - Method in class com.extentech.ExtenXLS.WorkBookParser

getFastCellAdds() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Get the current fast add cell mode for this worksheet

getFile() - Method in class com.extentech.ExtenXLS.DocumentHandle

Gets the file associated with this document.

getFile() - Method in class com.extentech.ExtenXLS.web.MemeDocument

------------------------------------------------------------

getFileExtension() - Method in class com.extentech.ExtenXLS.DocumentHandle

Gets the file name extension for this document's native format.

getFileExtension() - Method in class com.extentech.ExtenXLS.web.MemeDoc

getFileExtension() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getFileExtension() - Method in class com.extentech.ExtenXLS.WorkBookHandle

getFileName() - Method in class com.extentech.ExtenXLS.DocumentHandle

Deprecated. Use DocumentHandle.getFile() instead.

getFileName() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

Gets the file associated with this document.

getFillPattern() - Method in class com.extentech.ExtenXLS.CellHandle

get the fill pattern for this cell
Same as getBackgroundPattern

getFillPattern() - Method in class com.extentech.ExtenXLS.FormatHandle

get the fill pattern for this format

getFirstCol() - Method in interface com.extentech.ExtenXLS.WorkSheet

Get the first column on the Worksheet

getFirstCol() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Get the first column on the Worksheet

getFirstColumn() - Method in class com.extentech.ExtenXLS.CellRangeRef

Returns the lowest-indexed column in this range.

getFirstCondition() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

Get the first condition of the ConditionalFormat as a string representation

getFirstCondition() - Method in class com.extentech.ExtenXLS.ValidationHandle

Get the first condition of the validation as a string representation

getFirstRow() - Method in class com.extentech.ExtenXLS.CellRangeRef

Returns the lowest-indexed row in this range.

getFirstRow() - Method in interface com.extentech.ExtenXLS.WorkSheet

Get the first row on the Worksheet

getFirstRow() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Get the first row on the Worksheet

getFirstSheet() - Method in class com.extentech.ExtenXLS.CellRangeRef

Returns the first sheet in this range.

getFirstSheetName() - Method in class com.extentech.ExtenXLS.CellRangeRef

Returns the name of the first sheet in this range.

getFitHeight() - Method in class com.extentech.ExtenXLS.PrinterSettingsHandle

get the number of pages to fit the printout to height

getFitWidth() - Method in class com.extentech.ExtenXLS.PrinterSettingsHandle

get the number of pages to fit the printout to width

getFloatVal() - Method in class com.extentech.ExtenXLS.CellHandle

returns the value of this Cell as a float, if possible, or NaN if Cell value cannot be converted to float

getFloatVal() - Method in class com.extentech.ExtenXLS.FormulaHandle

If the Formula evaluates to a float, return the value as an float.

getFname() - Method in class com.extentech.ExtenXLS.eventui.swing.XMLEditorPanel

getFname() - Method in class com.extentech.ExtenXLS.ui.swing.XMLEditorPanel

getFont() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

Returns the Font used to represent this object.

getFont() - Method in class com.extentech.ExtenXLS.CellHandle

Get the ExtenXLS Font for this Cell, which roughly matches the functionality of the java.awt.Font class.

getFont() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getFont() - Method in class com.extentech.ExtenXLS.FormatHandle

returns the existing font record for this Format Font is an internal record and should not be accessed by end users

getFontColor() - Method in class com.extentech.ExtenXLS.CellHandle

get the Color of the Font used by this Cell.

getFontColor() - Method in class com.extentech.ExtenXLS.FormatHandle

Get the Font foreground (text) color

getFontColorIndex() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getFontEscapement() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getFontFace() - Method in class com.extentech.ExtenXLS.CellHandle

get the Font face used by this Cell.

getFontFamily() - Method in class com.extentech.ExtenXLS.web.CellHandlingBean

getFontHeight() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getFontHeight() - Method in class com.extentech.ExtenXLS.FormatHandle

Returns the Font's height in 1/20th point increment

getFontHeightInPoints() - Method in class com.extentech.ExtenXLS.FormatHandle

Get the font height in points

getFontName() - Method in class com.extentech.ExtenXLS.FormatHandle

Returns the Font's name

getFontOptsCancellation() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getFontOptsPosture() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getFontSize() - Method in class com.extentech.ExtenXLS.CellHandle

get the size in points of the Font used by this Cell

getFontSize() - Method in class com.extentech.ExtenXLS.web.CellHandlingBean

getFontUnderlineStyle() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getFontWeight() - Method in class com.extentech.ExtenXLS.CellHandle

get the weight (boldness) of the Font used by this Cell.

getFontWeight() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getFontWeight() - Method in class com.extentech.ExtenXLS.FormatHandle

Get the font weight

getFontWeight() - Method in class com.extentech.ExtenXLS.web.CellHandlingBean

getFooterMargin() - Method in class com.extentech.ExtenXLS.PrinterSettingsHandle

get the footer margin size in inches

getFooterText() - Method in interface com.extentech.ExtenXLS.WorkSheet

Get the text for the Footer printed at the bottom of the Worksheet

getFooterText() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Get the text for the Footer printed at the bottom of the Worksheet

getForegroundColor() - Method in class com.extentech.ExtenXLS.CellHandle

get the Color of the Cell Foreground of this Cell and all other cells sharing this FormatId.

getForegroundColor() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getForegroundColor() - Method in class com.extentech.ExtenXLS.FormatHandle

get the Background Color for this Format NOTE: Foreground color = the CELL BACKGROUND color color for all patterns and Background color= the PATTERN color for all patterns != Solid For PATTERN_SOLID, Foreground color=CELL BACKGROUND color and Background Color=64 (white).

getFormat() - Method in class com.extentech.ExtenXLS.DocumentHandle

Gets the constant representing this document's native format.

getFormat() - Method in class com.extentech.ExtenXLS.web.MemeDoc

getFormat() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getFormat() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Gets the constant representing this document's native format.

getFormatHandle() - Method in class com.extentech.ExtenXLS.CellHandle

Gets the FormatHandle (a Format Object describing the formats for this Cell) for this Cell.

getFormatHandle() - Method in class com.extentech.ExtenXLS.ColHandle

returns the FormatHandle (a Format Object describing visual properties) for this Column
NOTE: The Column format record describes the default formatting for each cell contained within the column

getFormatHandle() - Method in class com.extentech.ExtenXLS.RowHandle

Gets the FormatHandle for this Row.

getFormatHandle() - Method in class com.extentech.ExtenXLS.SimpleCellValue

getFormatId() - Method in interface com.extentech.ExtenXLS.Cell

Returns the Formatting record ID (FormatId) for this Cell
This can be used with 'setFormatId(int i)' to copy the formatting from one Cell to another (e.g.

getFormatId() - Method in class com.extentech.ExtenXLS.CellHandle

Returns the Formatting record ID (FormatId) for this Cell
This can be used with 'setFormatId(int i)' to copy the formatting from one Cell to another (e.g.

getFormatId() - Method in class com.extentech.ExtenXLS.ColHandle

returns the format ID (the index to the format record) for this Column
The Column format is the default formatting for each cell contained within the column

getFormatId() - Method in class com.extentech.ExtenXLS.FormatHandle

The format ID allows setting of the format for a Cell without adding it to the Format's Cell Collection.

getFormatId() - Method in class com.extentech.ExtenXLS.RowHandle

gets the current default row format id.

getFormatId() - Method in class com.extentech.ExtenXLS.SimpleCellValue

getFormatPattern() - Method in class com.extentech.ExtenXLS.CellHandle

Gets the number format pattern for this cell, if set.

getFormatPattern() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getFormatPattern() - Method in class com.extentech.ExtenXLS.FormatHandle

Gets the number format pattern for this format, if set.

getFormatPattern() - Method in class com.extentech.ExtenXLS.web.CellHandlingBean

getFormatPatternId() - Method in class com.extentech.ExtenXLS.FormatHandle

Gets the Excel format ID for this format's number format pattern.

getFormats() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getFormats() - Method in class com.extentech.ExtenXLS.web.WebDoc

May 16, 2010

getFormats() - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated. Returns an Array of all the FormatHandles present in the workbook

getFormats() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Returns an array of all FormatHandles in the workbook

getFormats() - Method in class com.extentech.ExtenXLS.WorkBookParser

getFormattedDateVal(CellHandle) - Static method in class com.extentech.ExtenXLS.DateConverter

Deprecated. The date format handling in this method is wildly incorrect. It is retained only to provide compatibility with legacy ExtenXLS XML files.

getFormattedStringVal() - Method in interface com.extentech.ExtenXLS.Cell

Returns the value of the Cell as a String with formatting pattern applied..

getFormattedStringVal() - Method in class com.extentech.ExtenXLS.CellHandle

Gets the value of the cell as a String with the number format applied.

getFormattedStringVal() - Method in class com.extentech.ExtenXLS.SimpleCellValue

Gets the value of the cell as a String with the number format applied.

getFormattedStringValue() - Method in class com.extentech.ExtenXLS.SimpleCellValue

getFormula(String) - Method in interface com.extentech.ExtenXLS.WorkSheet

Returns a FormulaHandle for working with the ranges of a formula on a WorkSheet.

getFormula(String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Returns a FormulaHandle for working with the ranges of a formula on a WorkSheet.

getFormula1() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getFormula2() - Method in class com.extentech.ExtenXLS.ConditionalFormatRule

getFormulaCalculationMode() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getFormulaCalculationMode() - Method in interface com.extentech.ExtenXLS.WorkBook

Deprecated.

getFormulaCalculationMode() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Get the calculation mode for the workbook.

getformulafromcell(Map) - Static method in class com.extentech.ExtenXLS.web.WorkBookUpdateBean

Get an XMLResponse string representing a formula for a cell

getFormulaHandle() - Method in class com.extentech.ExtenXLS.CellHandle

Returns the Formula Handle (an Object describing a Formula) for this Cell, if it contains a formula

getFormulaHandle(String) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getFormulaHandle(String) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Returns a Formula Handle

getFormulaHandle(String) - Method in class com.extentech.ExtenXLS.WorkBookParser

getFormulaRec() - Method in class com.extentech.ExtenXLS.FormulaHandle

returns the low-level formula rec for this Formulahandle

getFormulaString() - Method in class com.extentech.ExtenXLS.FormulaHandle

Returns the Human-Readable Formula String

getfPersisted() - Method in class com.extentech.ExtenBean.XMLDataObjectFactory

return the previous persisted filename

getGlobalVariableList() - Method in class com.extentech.ExtenXLS.binder.SimpleCellBinder

getGridLinesPref() - Method in class com.extentech.ExtenXLS.ui.jchart.JChart

getGUIBuilderInstance() - Static method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSXMLEditorPanel

This method should return an instance of this class which does NOT initialize it's GUI elements.

getGUIBuilderInstance() - Static method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSXMLEditorPanel

This method should return an instance of this class which does NOT initialize it's GUI elements.

getHasChildren() - Method in class com.extentech.ExtenBean.ExtenDataObject

getHashedProtectionPassword() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Gets the hash of the sheet protection password.

getHeaderHeight() - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

Gets the height of the column headers.

getHeaderMargin() - Method in class com.extentech.ExtenXLS.PrinterSettingsHandle

get the header margin size in inches

getHeaderText() - Method in interface com.extentech.ExtenXLS.WorkSheet

Get the text for the Header printed at the top of the Worksheet

getHeaderText() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Get the text for the Header printed at the top of the Worksheet

getHeaderWidth() - Method in class com.extentech.ExtenXLS.eventui.WorkBookModel

Gets the width of the row headers.

getHeight() - Method in class com.extentech.ExtenXLS.CellRange

Gets the number of rows in the range.

getHeight() - Method in class com.extentech.ExtenXLS.ImageHandle

return the height of the image in pixels

getHeight() - Method in class com.extentech.ExtenXLS.RowHandle

Return the row height of an existing row.

getHeight(Boundsheet, int) - Static method in class com.extentech.ExtenXLS.RowHandle

Return the row height of an existing row.

getHeightInChars() - Method in class com.extentech.ExtenXLS.RowHandle

returns the row height in Excel units

getHidden() - Method in interface com.extentech.ExtenXLS.WorkSheet

get whether this sheet is hidden from the user opening the file.

getHidden() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

get whether this sheet is hidden from the user opening the file.

getHiID(DataObject) - Method in class com.extentech.ExtenBean.ExtenBeanFactory

Get the current HI-ID for a numeric index field.

getHiID(PageableDataObject) - Method in class com.extentech.ExtenBean.ExtenBeanFactory

This version of getHiID() checks for support for an Oracle sequece to use for the next id

getHlink(DataObject, int) - Method in class com.extentech.ExtenXLS.binder.DataBoundCellRange

Get the Hyperlink for the DataBoundCellRange

getHorizontalAlignment() - Method in class com.extentech.ExtenXLS.CellHandle

Returns an int representing the current horizontal alignment in this Cell.

getHorizontalAlignment() - Method in class com.extentech.ExtenXLS.FormatHandle

Returns an int representing the current horizontal alignment in this FormatHandle.

getHtmlViewer() - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSCellRenderer

Deprecated. No longer used internally. Should not have been public.

getHtmlViewer() - Method in class com.extentech.ExtenXLS.ui.ExtenXLSCellRenderer

getId() - Method in interface com.extentech.ExtenBean.DataObject

getId() - Method in class com.extentech.ExtenBean.DataObjectImpl

getId() - Method in class com.extentech.ExtenBean.ExtenDataObject

getId() - Method in class com.extentech.ExtenXLS.ChartHandle

returns the ordinal id associated with the underlying Chart Object

getImage(String) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getImage(String, int, int, int, int) - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getImage(String) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Returns an ImageHandle for manipulating images in the WorkBook

getImage(String, int, int, int, int) - Method in class com.extentech.ExtenXLS.WorkBookHandle

Generate a thumbnail JPEG image of the first worksheet in the workbook Feb 8, 2011

getImage(String, int, int, int, int) - Method in class com.extentech.ExtenXLS.WorkBookParser

getImage(String) - Method in class com.extentech.ExtenXLS.WorkBookParser

getImage(String) - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Get a handle to all of the images in this worksheet

getImageBytes() - Method in class com.extentech.ExtenXLS.ImageHandle

getImageFormat(InputStream) - Method in class com.extentech.ExtenXLS.ImageHandle

returns the format name of the image data Jan 22, 2010

getImageIndex() - Method in class com.extentech.ExtenXLS.ImageHandle

Internal method that converts the image bounds appropriate for saving by Excel in the MsofbtOPT record.

getImageName() - Method in class com.extentech.ExtenXLS.ImageHandle

return the imageName (= original file name, I believe)

getImages() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getImages() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Returns all ImageHandles in the workbook

getImages() - Method in class com.extentech.ExtenXLS.WorkBookParser

getImages() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Get a handle to all of the images in this worksheet

getImageType() - Method in class com.extentech.ExtenXLS.ImageHandle

getIMEMode() - Method in class com.extentech.ExtenXLS.ValidationHandle

Get the IME mode for this validation

getIndent() - Method in class com.extentech.ExtenXLS.FormatHandle

return indent (1 = 3 spaces)

getIndex() - Method in class com.extentech.ExtenBean.ExtenDataObject

getIndex() - Method in interface com.extentech.ExtenBean.PageableDataObject

getIndex(TreeNode) - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

getInfo() - Method in class com.extentech.ExtenBean.colinfo

GetInfo - Class in com.extentech.ExtenXLS

Prints various bits of information about this build.

GetInfo() - Constructor for class com.extentech.ExtenXLS.GetInfo

getInfoBeansFromWorkBook(WorkBookHandle, ExtenXLSReportFactory) - Method in class com.extentech.ExtenXLS.WorkBookBeanFactory

This method retrieves values from WorkBookHandles and instantiates an DataObject from the Cell contents.

getInstance(InputStream) - Static method in class com.extentech.ExtenXLS.DocumentHandle

Looks for magic numbers in the given input data and attempts to parse it with an appropriate DocumentHandle subclass.

getInt(String) - Method in class com.extentech.ExtenXLS.FormatCache

Deprecated.

getInternalNoteRec() - Method in class com.extentech.ExtenXLS.CommentHandle

Returns the internal note record for this CommentHandle.

getIntVal() - Method in class com.extentech.ExtenXLS.CellHandle

returns the value of this Cell as a int, if possible, or NaN if Cell value cannot be converted to int

getIntVal(String) - Static method in class com.extentech.ExtenXLS.ExcelTools

get the int value of the Excel-style Column alpha representation.

getIntVal() - Method in class com.extentech.ExtenXLS.FormulaHandle

If the Formula evaluates to an int, return the value as an int.

getIsBLOB() - Method in class com.extentech.ExtenBean.colinfo

getIsBold() - Method in class com.extentech.ExtenXLS.FormatHandle

Get if this format is bold or not

getIsBoolean() - Method in class com.extentech.ExtenBean.colinfo

getIsCLOB() - Method in class com.extentech.ExtenBean.colinfo

getIsDate() - Method in class com.extentech.ExtenBean.colinfo

getIsExcel2007() - Method in class com.extentech.ExtenXLS.web.MemeWorkBook

getIsExcel2007() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Returns whether the underlying spreadsheet is in Excel 2007 format by default.

getIsFloat() - Method in class com.extentech.ExtenBean.colinfo

getIsHidden() - Method in class com.extentech.ExtenXLS.CommentHandle

Returns true if this Note (Comment) is hidden until focus

getIsLastPage() - Method in class com.extentech.ExtenBean.ExtenDataObject

getIsLastPage() - Method in interface com.extentech.ExtenBean.PageableDataObject

getIsMultiKey() - Method in class com.extentech.ExtenBean.DataObjectImpl

getIsMultiKey() - Method in class com.extentech.ExtenBean.ExtenDataObject

getIsMultiple() - Method in interface com.extentech.ExtenBean.DataObject

getIsMultiple() - Method in class com.extentech.ExtenBean.DataObjectImpl

getIsMultiple() - Method in class com.extentech.ExtenBean.ExtenDataObject

getIsMultiple() - Method in class com.extentech.ExtenBean.JSONDataObject

getIsMultiple() - Method in interface com.extentech.ExtenBean.SimpleDataObject

getIsNew() - Method in interface com.extentech.ExtenBean.DataObject

getIsNew() - Method in class com.extentech.ExtenBean.DataObjectImpl

getIsNumeric() - Method in class com.extentech.ExtenBean.colinfo

getIsTimestamp() - Method in class com.extentech.ExtenBean.colinfo

getIsUnderlined() - Method in class com.extentech.ExtenXLS.CellHandle

returns whether the Font for this Cell is underlined

getIsUpdateable() - Method in class com.extentech.ExtenBean.DataObjectImpl

getIsUpdateable() - Method in interface com.extentech.ExtenBean.SQLObject

getItalic() - Method in class com.extentech.ExtenXLS.FormatHandle

Get if the font is italic

getJavaFormatString() - Method in class com.extentech.ExtenXLS.FormatHandle

provides a mapping between Excel formats and Java formats
see: http://java.sun.com/docs/books/tutorial/i18n/format/decimalFormat.html

getJavaType() - Method in class com.extentech.ExtenBean.colinfo

getJDBCPanel() - Method in class com.extentech.ExtenXLS.eventui.swing.DataObjectPanel

getJDBCPanel() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenDataObjectPanel

getJDBCPanel() - Method in class com.extentech.ExtenXLS.ui.swing.DataObjectPanel

getJDBCPanel() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenDataObjectPanel

getJMenu1() - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSWorkBookViewer

getJMenu1() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapperFrame

getJMenu1() - Method in class com.extentech.ExtenXLS.ui.ExtenXLSWorkBookViewer

getJMenu1() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapperFrame

getJMenuBar1() - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSWorkBookViewer

getJMenuBar1() - Method in class com.extentech.ExtenXLS.eventui.swing.ExtenXLSMapperFrame

getJMenuBar1() - Method in class com.extentech.ExtenXLS.ui.ExtenXLSWorkBookViewer

getJMenuBar1() - Method in class com.extentech.ExtenXLS.ui.swing.ExtenXLSMapperFrame

getJSON() - Method in class com.extentech.ExtenXLS.CellHandle

Get the JSON object for this cell.

getJSON() - Method in class com.extentech.ExtenXLS.CellRange

returns a JSON representation of this CellRange

getJSON(String, WorkBook) - Static method in class com.extentech.ExtenXLS.CellRange

return a JSON array of cell values for the given range
static version

getJSON() - Method in class com.extentech.ExtenXLS.ChartHandle

returs the JSON representation of this chart, based upon Dojo-charting-specifics

getJSON(ImageHandle) - Static method in class com.extentech.ExtenXLS.ExtenXLS

Get a JSON representation of an Image

getJSON(NameHandle) - Static method in class com.extentech.ExtenXLS.ExtenXLS

Get a JSON representation of a NamedRange

getJSON(RowHandle) - Static method in class com.extentech.ExtenXLS.ExtenXLS

Get a JSON representation of a row

getJSON(CellRange) - Static method in class com.extentech.ExtenXLS.ExtenXLS

Get a JSON representation of a cellRange

getJSON(CellHandle) - Static method in class com.extentech.ExtenXLS.ExtenXLS

Get a JSON representation of a cell utilizing a merged range identifier

getJSON(CellHandle, int[]) - Static method in class com.extentech.ExtenXLS.ExtenXLS

Get a JSON representation of a cell utilizing a merged range identifier

getJSON(int) - Method in class com.extentech.ExtenXLS.FormatHandle

Get a JSON representation of the format

getJSON() - Method in class com.extentech.ExtenXLS.ImageHandle

Get a JSON representation of the format

getJSON() - Method in class com.extentech.ExtenXLS.NameHandle

Return a JSON object representing this name Handle.

getJSON(boolean) - Method in class com.extentech.ExtenXLS.NameHandle

Return a JSON object representing this name Handle.

getJSON() - Method in class com.extentech.ExtenXLS.PivotTableHandle

returns the JSON representation of this PivotTable

getJSON() - Method in class com.extentech.ExtenXLS.RowHandle

Get the JSON object for this row.

getJSONObject(NameHandle) - Static method in class com.extentech.ExtenXLS.ExtenXLS

Get a JSON representation of a NamedRange

getJSONObject(RowHandle, int) - Static method in class com.extentech.ExtenXLS.ExtenXLS

Get a org.JSON object representation of a row, limit number of cols of data

getJSONObject(RowHandle) - Static method in class com.extentech.ExtenXLS.ExtenXLS

Get a org.JSON object representation of a row

getJSONObject(CellHandle) - Static method in class com.extentech.ExtenXLS.ExtenXLS

Get a JSON representation of a cell utilizing a merged range identifier

getJSONObject(CellHandle, int[]) - Static method in class com.extentech.ExtenXLS.ExtenXLS

Get a JSON Object representation of a cell utilizing a merged range identifier

getJSONObject(int) - Method in class com.extentech.ExtenXLS.FormatHandle

Get a JSON representation of the format font height is represented as HTML pt size

getKeyCol() - Method in class com.extentech.ExtenBean.DataObjectImpl

getKeyCol() - Method in class com.extentech.ExtenBean.ExtenDataObject

getKeyCol() - Method in interface com.extentech.ExtenBean.SQLObject

getKeyColName() - Method in class com.extentech.ExtenBean.DataObjectImpl

get the key column name for this dataobject

getKeyColName() - Method in class com.extentech.ExtenBean.ExtenDataObject

get the key column name for this dataobject

getKeyColName() - Method in interface com.extentech.ExtenBean.SQLObject

getLandscape() - Method in class com.extentech.ExtenXLS.PrinterSettingsHandle

get the landscape orientation

getLastCol() - Method in interface com.extentech.ExtenXLS.WorkSheet

Get the last column on the Worksheet

getLastCol() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Get the last column on the Worksheet

getLastColumn() - Method in class com.extentech.ExtenXLS.CellRangeRef

Returns the highest-indexed column in this range.

getLastRow() - Method in class com.extentech.ExtenXLS.CellRangeRef

Returns the highest-indexed row in this range.

getLastRow() - Method in interface com.extentech.ExtenXLS.WorkSheet

Get the last row on the Worksheet

getLastRow() - Method in class com.extentech.ExtenXLS.WorkSheetHandle

Get the last row on the Worksheet

getLastSheet() - Method in class com.extentech.ExtenXLS.CellRangeRef

Returns the last sheet in this range.

getLastSheetName() - Method in class com.extentech.ExtenXLS.CellRangeRef

Returns the name of the last sheet in this range.

getLatestDiff(int) - Method in class com.extentech.ExtenXLS.web.MemeDocument

retrieves most current String difference for database record ID

getLatestXML() - Method in class com.extentech.ExtenXLS.web.WebWorkBook

retrieve the lastest XML stream from the conurl URL and format into a Document object

getLeftBorderLineStyle() - Method in class com.extentech.ExtenXLS.FormatHandle

Get the border line style

getLeftCol() - Method in class com.extentech.ExtenXLS.eventui.ExtenXLSTable

getLeftMargin() - Method in class com.extentech.ExtenXLS.PrinterSettingsHandle

Gets the left print margin.

getLeftToRight() - Method in class com.extentech.ExtenXLS.PrinterSettingsHandle

get the left-to-right print orientation

getLegendLabels() - Method in class com.extentech.ExtenXLS.ui.jchart.JChart

getLEOFile() - Method in class com.extentech.ExtenXLS.WorkBookHandle

Gets the internal LEOFile object.

getLEOFile() - Method in class com.extentech.ExtenXLS.WorkBookParser

getLevel() - Method in class com.extentech.ExtenBean.DataObjectImpl

getLevel() - Method in class com.extentech.ExtenBean.ExtenDataObject

getLevel() - Method in interface com.extentech.ExtenBean.RelationalObject

getLevel() - Method in class com.extentech.ExtenBean.RelationalObjectImpl

getLevel() - Method in class com.extentech.ExtenBean.swing.ExtenBeanTreeNode

getLink() - Method in class com.extentech.ExtenXLS.web.CellHandlingBean

getListeners() - Method in class com.extentech.ExtenXLS.WorkBookParser

getLocation() - Method in class com.extentech.ExtenXLS.NameHandle

get the referenced named cell range as string in standard excel syntax including sheetname, for instance "Sheet1!A1:Z255"

getLogDate() - Static method in class com.extentech.ExtenXLS.ExcelTools

get recordy byte def as a String public static String getRecordByteDef(XLSRecord rec){ byte[] b = rec.read(); StringBuffer sb = new StringBuffer("byte[] rbytes = {"); for(int t = 0;tgetManualGridLineColor()