All Packages  Class Hierarchy

Index of all Fields and Methods

A

actionPerformed(ActionEvent). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

Handles the pressing of the Apply and the Browse buttons.

addExcelCellErrorListener(ExcelCellErrorListener). Method in class com.ibm.excelaccessor.ExcelCell

Adds the specified ExcelCellErrorListener to receive ExcelCellError events from the ExcelCell bean.

addExcelCellListener(ExcelCellListener). Method in class com.ibm.excelaccessor.ExcelCell

Adds the specified ExcelCellListener to receive ExcelCell events from the ExcelCell bean.

addExcelRangeErrorListener(ExcelRangeErrorListener). Method in class com.ibm.excelaccessor.ExcelRange

Adds the specified ExcelRangeErrorListener to receive ExcelRangeError events from the ExcelRange bean.

addExcelRangeListener(ExcelRangeListener). Method in class com.ibm.excelaccessor.ExcelRange

Adds the specified ExcelRangeListener to receive ExcelRange events from the ExcelRange bean.

addExcelSheetListener(ExcelSheetListener). Method in class com.ibm.excelaccessor.ExcelCell

Adds the specified ExcelSheetListener to receive ExcelSheet events from the ExcelRange bean.

addExcelSheetListener(ExcelSheetListener). Method in class com.ibm.excelaccessor.ExcelRange

Adds the specified ExcelSheetListener to receive ExcelSheet events from the ExcelRange bean.

addExcelWorkbookErrorListener(ExcelWorkbookErrorListener). Method in class com.ibm.excelaccessor.ExcelWorkbook

Add the specified ExcelWorkbookError listener to receive ExcelWorkbookError events from the ExcelWorkbook bean.

addExcelWorkbookListener(ExcelWorkbookListener). Method in class com.ibm.excelaccessor.ExcelWorkbook

Adds the specified ExcelWorkbook listener to receive ExcelWorkbook events from the ExcelWorkbook bean.

addFetchArgumentsListener(FetchArgumentsListener). Method in class com.ibm.excelaccessor.ExcelCell

Adds the specified FetchArgumentsListener to receive FetchArguments events from the ExcelRange bean.

addFetchArgumentsListener(FetchArgumentsListener). Method in class com.ibm.excelaccessor.ExcelRange

Adds the specified FetchArgumentsListener to receive FetchArguments events from the ExcelRange bean.

addFetchArgumentsListener(FetchArgumentsListener). Method in class com.ibm.excelaccessor.ExcelWorkbook

Adds the specified FetchArguments listener to receive FetchArgument events from the ExcelWorkbook bean.

addFetchPasswordListener(FetchPasswordListener). Method in class com.ibm.excelaccessor.ExcelCell

Adds the specified FetchPasswordListener to receive FetchPassword events from the ExcelRange bean.

addFetchPasswordListener(FetchPasswordListener). Method in class com.ibm.excelaccessor.ExcelRange

Adds the specified FetchPasswordListener to receive FetchPassword events from the ExcelRange bean.

addFetchPasswordListener(FetchPasswordListener). Method in class com.ibm.excelaccessor.ExcelWorkbook

Adds the specified FetchPassword listener to receive FetchPassword events from the ExcelWorkbook bean.

addFileSavingListener(FileSavingListener). Method in class com.ibm.excelaccessor.ExcelWorkbook

Adds the specified FileSaving listener to receive FileSaving events from the ExcelWorkbook bean.

addPropertyChangeListener(PropertyChangeListener). Method in class com.ibm.excelaccessor.ExcelCell

Adds the specified PropertyChangeListener to receive PropertyChange events from the ExcelRange bean.

addPropertyChangeListener(PropertyChangeListener). Method in class com.ibm.excelaccessor.ExcelRange

Adds the specified PropertyChangeListener to receive PropertyChange events from the ExcelRange bean.

addPropertyChangeListener(PropertyChangeListener). Method in class com.ibm.excelaccessor.ExcelWorkbook

Adds the specified PropertyChange listener to receive PropertyChange events from the ExcelWorkbook bean.

addPropertyChangeListener(PropertyChangeListener). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

Register a listener for the PropertyChange event.

C

CELL_INITIALIZED. Static variable in class com.ibm.excelaccessor.event.ExcelCellEvent

The id for the CELL_INITIALIZED type of event.

CELL_UNINITIALIZED. Static variable in class com.ibm.excelaccessor.event.ExcelCellEvent

The id for the CELL_UNINITIALIZED type of event.

cellInitialized(ExcelCellEvent). Method in interface com.ibm.excelaccessor.event.ExcelCellListener

Invoked when the initCell() method is called to initialize a cell and that cell is successfully initialized.

cellUninitialized(ExcelCellEvent). Method in interface com.ibm.excelaccessor.event.ExcelCellListener

Invoked when the cell gets uninitialized.

clear(). Method in class com.ibm.excelaccessor.ExcelCell

Clears all the cell properties (value, formula, format, text and noteText) for this Cell.

clear(). Method in class com.ibm.excelaccessor.ExcelRange

Clears all the cell properties (value, formula, format, text and noteText) for this Range.

clearContents(). Method in class com.ibm.excelaccessor.ExcelCell

Clears the cell contents (value and formula, if any) for this Cell.

clearContents(). Method in class com.ibm.excelaccessor.ExcelRange

Clears the cell contents (values and formulae, if any) for this Range.

clearFormats(). Method in class com.ibm.excelaccessor.ExcelCell

Clears all cell formatting information for this cell, the value, noteText and formula are retained.

clearFormats(). Method in class com.ibm.excelaccessor.ExcelRange

Clears all cell formatting information for all the cells in the range, the values, noteText and formulae are retained.

clearNotes(). Method in class com.ibm.excelaccessor.ExcelCell

Clears notetext for this cell, the value, formula and format information are retained.

clearNotes(). Method in class com.ibm.excelaccessor.ExcelRange

Clears all the notes for all the cells in the range, the value, formula and format information are retained.

closeWorkbook(). Method in class com.ibm.excelaccessor.ExcelWorkbook

The method to close the workbook.

createNamedCell(String). Method in class com.ibm.excelaccessor.ExcelCell

Assigns a name to the current cell.

createNamedRange(String). Method in class com.ibm.excelaccessor.ExcelRange

Assigns a name to the current range.

E

EXCEL_ERROR. Static variable in class com.ibm.excelaccessor.event.ExcelAccessorErrorEvent

The flag indicating the event to be fired

ExcelAccessorException(). Constructor for class com.ibm.excelaccessor.ExcelAccessorException

Constructs an ExcelAccessorException with no detail message.

ExcelAccessorException(String). Constructor for class com.ibm.excelaccessor.ExcelAccessorException

Constructs an ExcelAccessorException with the specified detail message.

ExcelCell(). Constructor for class com.ibm.excelaccessor.ExcelCell

Constructs an ExcelCell object with properties autoCreateSheet and autoUnprotectSheet set to false.

ExcelCellBeanInfo(). Constructor for class com.ibm.excelaccessor.ExcelCellBeanInfo

ExcelCellErrorEvent(Object, int, Exception, String, int, int, int, int, String, String, String). Constructor for class com.ibm.excelaccessor.event.ExcelCellErrorEvent

Constructs a ExcelCellErrorEvent object with the specified source object.

ExcelCellEvent(Object, int, String, String, String, int, int, int, int). Constructor for class com.ibm.excelaccessor.event.ExcelCellEvent

Constructs an ExcelCellEvent object with the specified source object, the name of the concerned workbook, sheet and range.

excelError(ExcelCellErrorEvent). Method in interface com.ibm.excelaccessor.event.ExcelCellErrorListener

This method is called when an error occurs on the ExcelCell bean.

excelError(ExcelRangeErrorEvent). Method in interface com.ibm.excelaccessor.event.ExcelRangeErrorListener

This method is called when an error occurs on the ExcelRange bean.

excelError(ExcelWorkbookErrorEvent). Method in interface com.ibm.excelaccessor.event.ExcelWorkbookErrorListener

This method is called when an error occurs on the Excel workbook, when a call has been made to Excel.

ExcelRange(). Constructor for class com.ibm.excelaccessor.ExcelRange

Constructs an ExcelRange object with properties autoCreateSheet and autoUnprotectSheet set to false.

ExcelRangeBeanInfo(). Constructor for class com.ibm.excelaccessor.ExcelRangeBeanInfo

ExcelRangeErrorEvent(Object, int, Exception, String, int, int, int, int, String, String, String). Constructor for class com.ibm.excelaccessor.event.ExcelRangeErrorEvent

Constructs a ExcelRangeErrorEvent object with the specified source object.

ExcelRangeEvent(Object, int, String, String, String, int, int, int, int). Constructor for class com.ibm.excelaccessor.event.ExcelRangeEvent

Constructs an ExcelRangeEvent object with the specified source object, the name of the concerned workbook, sheet and range.

ExcelSheetEvent(Object, int, String, String). Constructor for class com.ibm.excelaccessor.event.ExcelSheetEvent

Constructs an ExcelSheetEvent object with the specified source object, the name of the concerned sheet and the name of the affected workbook.

ExcelWorkbook(). Constructor for class com.ibm.excelaccessor.ExcelWorkbook

Constructs an ExcelWorkbook with the readOnly and the saveOnClose flags set to true.

ExcelWorkbookBeanInfo(). Constructor for class com.ibm.excelaccessor.ExcelWorkbookBeanInfo

ExcelWorkbookErrorEvent(Object, int, Exception, String, String). Constructor for class com.ibm.excelaccessor.event.ExcelWorkbookErrorEvent

Constructs a ExcelWorkbookErrorEvent object with the specified source object.

ExcelWorkbookEvent(Object, int, String, boolean). Constructor for class com.ibm.excelaccessor.event.ExcelWorkbookEvent

Constructs a ExcelWorkbookEvent object with the specified source object, the name of the concerned workbook and the appropriate flag depending upon the type of event.

F

fetchArgumentsCalled(FetchArgumentsEvent). Method in interface com.ibm.excelaccessor.event.FetchArgumentsListener

Invoked when input arguments are required by the following methods initRange, insertWorksheet, removeWorksheet, openWorkbook.

FetchArgumentsEvent(Object). Constructor for class com.ibm.excelaccessor.event.FetchArgumentsEvent

Constructs a FetchArgumentsEvent object with the specified source object.

FetchPasswordEvent(Object, int). Constructor for class com.ibm.excelaccessor.event.FetchPasswordEvent

Constructs a FetchPasswordEvent object with the specified source object and the type of FetchPasswordEvent.

fetchWkbkProtectionPasswd(FetchPasswordEvent). Method in interface com.ibm.excelaccessor.event.FetchPasswordListener

Invoked when the workbook is being opened and a protection password is required.

fetchWkbkStructureProtectionPasswd(FetchPasswordEvent). Method in interface com.ibm.excelaccessor.event.FetchPasswordListener

Invoked when the workbook structure (password protected) is being unprotected.

fetchWkbkWriteReservationPasswd(FetchPasswordEvent). Method in interface com.ibm.excelaccessor.event.FetchPasswordListener

Invoked when the workbook is being opened in the write mode and a write reservation password is required.

fetchWorkSheetProtectionPassword(FetchPasswordEvent). Method in interface com.ibm.excelaccessor.event.FetchPasswordListener

Invoked when a worksheet (password protected) is being unprotected.

FileNamePropertyEditor(). Constructor for class com.ibm.excelaccessor.FileNamePropertyEditor

Constructs the required file name editor.

FileSavingEvent(Object, String). Constructor for class com.ibm.excelaccessor.event.FileSavingEvent

Constructs a FileSavingEvent object with the specified source object and the name of the modified workbook file that is being closed.

finalize(). Method in class com.ibm.excelaccessor.ExcelWorkbook

The method is called by the garbage collector on an object when garbage collection determines that there are no more references to the object.

firePropertyChange(). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

This method is used to fire PropertyChangeEvents to all registered listeners.

G

getAsText(). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

Returns the file name property as a human editable string.

getBeanDescriptor(). Method in class com.ibm.excelaccessor.ExcelCellBeanInfo

Returns the information about the bean class.

getBeanDescriptor(). Method in class com.ibm.excelaccessor.ExcelRangeBeanInfo

Returns the information about the bean class.

getBeanDescriptor(). Method in class com.ibm.excelaccessor.ExcelWorkbookBeanInfo

Returns the information about the bean class.

getColumnHeaders(). Method in class com.ibm.excelaccessor.ExcelCell

Returns a Vector of Strings, which represents the headers of the columns of the range (as integers).

getColumnHeaders(). Method in class com.ibm.excelaccessor.ExcelRange

Returns a Vector of Strings, which represents the headers of the columns of the range (as integers).

getCurrentException(). Method in class com.ibm.excelaccessor.event.ExcelAccessorErrorEvent

Returns the exception that caused this event to be fired.

getCustomEditor(). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

This method returns the custom property editor.

getCustomEditor(). Method in class com.ibm.excelaccessor.NotEditableEditor

Returns a custom editor which displays that this property is not editable.

getDefaultText(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the text property of the range as returned by Excel.

getEndCol(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the column number for the bottom right cell of the range.

getEndCol(). Method in class com.ibm.excelaccessor.event.ExcelCellErrorEvent

Returns the ending column number for the range.

getEndCol(). Method in class com.ibm.excelaccessor.event.ExcelCellEvent

Returns the ending column number for the range.

getEndCol(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the column number for the bottom right cell of the range.

getEndCol(). Method in class com.ibm.excelaccessor.event.ExcelRangeErrorEvent

Returns the ending column number for the range.

getEndCol(). Method in class com.ibm.excelaccessor.event.ExcelRangeEvent

Returns the ending column number for the range.

getEndRow(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the row number for the bottom right cell of the range.

getEndRow(). Method in class com.ibm.excelaccessor.event.ExcelCellErrorEvent

Returns the ending row number for the range.

getEndRow(). Method in class com.ibm.excelaccessor.event.ExcelCellEvent

Returns the ending row number for the range.

getEndRow(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the row number for the bottom right cell of the range.

getEndRow(). Method in class com.ibm.excelaccessor.event.ExcelRangeErrorEvent

Returns the ending row number for the range.

getEndRow(). Method in class com.ibm.excelaccessor.event.ExcelRangeEvent

Returns the ending row number for the range.

getEventSetDescriptors(). Method in class com.ibm.excelaccessor.ExcelCellBeanInfo

Returns information about the events fired by this bean.

getEventSetDescriptors(). Method in class com.ibm.excelaccessor.ExcelRangeBeanInfo

Returns information about the events fired by this bean.

getEventSetDescriptors(). Method in class com.ibm.excelaccessor.ExcelWorkbookBeanInfo

Returns information about the events fired by this bean.

getFormat(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the Format property of the cell as a String.

getFormat(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the Format property of the range as a String.

getFormula(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the Formula property for the Cell as a String.

getFormula(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the Formula property for the Range as a Vector of Vectors.

getFormulaAsArray(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the formula property as a 2-Dimensional array of objects.

getIcon(int). Method in class com.ibm.excelaccessor.ExcelCellBeanInfo

Returns the icons for this bean.

getIcon(int). Method in class com.ibm.excelaccessor.ExcelRangeBeanInfo

Returns the icons for this bean.

getIcon(int). Method in class com.ibm.excelaccessor.ExcelWorkbookBeanInfo

Returns the icons for this bean.

getId(). Method in class com.ibm.excelaccessor.event.ExcelCellEvent

Returns an id indicating the type of event.

getId(). Method in class com.ibm.excelaccessor.event.ExcelRangeEvent

Returns an id indicating the type of event.

getId(). Method in class com.ibm.excelaccessor.event.ExcelSheetEvent

Returns an id indicating the type of event.

getId(). Method in class com.ibm.excelaccessor.event.ExcelWorkbookEvent

Returns an id indicating the type of event.

getId(). Method in class com.ibm.excelaccessor.event.FetchPasswordEvent

Returns an event-id indicating the type of event.

getJavaInitializationString(). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

This method returns a fragment of Java code that can be used to initialize a variable with the current property value.

getJavaInitializationString(). Method in class com.ibm.excelaccessor.NotEditableEditor

Returns null as the editor is to be used for properties which are not editable.

getMessage(). Method in class com.ibm.excelaccessor.event.ExcelAccessorErrorEvent

Returns the error message.

getMessageCode(). Method in class com.ibm.excelaccessor.event.ExcelAccessorErrorEvent

Returns the error code representing the error message.

getMethodDescriptors(). Method in class com.ibm.excelaccessor.ExcelCellBeanInfo

Returns information about the methods of this bean.

getMethodDescriptors(). Method in class com.ibm.excelaccessor.ExcelRangeBeanInfo

Returns information about the methods of this bean.

getMethodDescriptors(). Method in class com.ibm.excelaccessor.ExcelWorkbookBeanInfo

Returns information about the methods of this bean.

getNCols(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the number of columns present in the range.

getNCols(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the number of columns present in the range.

getNoteText(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the noteText for the cell.

getNoteText(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the noteText for the top-left cell of the range.

getNRows(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the number of rows present in the range.

getNRows(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the number of rows present in the range.

getPrefferedSize(). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

Returns the preferred size for this property editor.

getPropertyDescriptors(). Method in class com.ibm.excelaccessor.ExcelCellBeanInfo

Returns information about the properties of this bean.

getPropertyDescriptors(). Method in class com.ibm.excelaccessor.ExcelRangeBeanInfo

Returns information about the properties of this bean.

getPropertyDescriptors(). Method in class com.ibm.excelaccessor.ExcelWorkbookBeanInfo

Returns information about the properties of this bean.

getRangeName(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the name of the range if the range has been selected using rangeName.

getRangeName(). Method in class com.ibm.excelaccessor.event.ExcelCellErrorEvent

Returns the name of the range on which the error has occurred.

getRangeName(). Method in class com.ibm.excelaccessor.event.ExcelCellEvent

Returns the name of the range that has been initialized.

getRangeName(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the name of the range if the range has been selected using rangeName.

getRangeName(). Method in class com.ibm.excelaccessor.event.ExcelRangeErrorEvent

Returns the name of the range on which the error has occurred.

getRangeName(). Method in class com.ibm.excelaccessor.event.ExcelRangeEvent

Returns the name of the range that has been initialized.

getRowHeaders(). Method in class com.ibm.excelaccessor.ExcelCell

Returns a Vector of Strings, which represents the headers of the rows of the range (as integers).

getRowHeaders(). Method in class com.ibm.excelaccessor.ExcelRange

Returns a Vector of Strings, which represents the headers of the rows of the range (as integers).

getSheetName(). Method in class com.ibm.excelaccessor.event.ExcelSheetEvent

Returns the name of the sheet concerned with this event.

getStartCol(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the column number for the top left cell of the range.

getStartCol(). Method in class com.ibm.excelaccessor.event.ExcelCellErrorEvent

Returns the starting column number for the range.

getStartCol(). Method in class com.ibm.excelaccessor.event.ExcelCellEvent

Returns the starting column number for the range.

getStartCol(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the column number for the top left cell of the range.

getStartCol(). Method in class com.ibm.excelaccessor.event.ExcelRangeErrorEvent

Returns the starting column number for the range.

getStartCol(). Method in class com.ibm.excelaccessor.event.ExcelRangeEvent

Returns the starting column number for the range.

getStartRow(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the row number for the top left cell of the range.

getStartRow(). Method in class com.ibm.excelaccessor.event.ExcelCellErrorEvent

Returns the starting row number for the range.

getStartRow(). Method in class com.ibm.excelaccessor.event.ExcelCellEvent

Returns the starting row number for the range.

getStartRow(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the row number for the top left cell of the range.

getStartRow(). Method in class com.ibm.excelaccessor.event.ExcelRangeErrorEvent

Returns the starting row number for the range.

getStartRow(). Method in class com.ibm.excelaccessor.event.ExcelRangeEvent

Returns the starting row number for the range.

getTags(). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

This method returns null since this property cannot be represented as a tagged value.

getText(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the Text property for the Range.

getText(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the Text property for the Range.

getThisWorkbook(). Method in class com.ibm.excelaccessor.ExcelWorkbook

Returns the reference to this workbook.

getValue(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the Value property for the Range.

getValue(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the Value property for the Range.

getValue(). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

Returns the file name property as a String.

getValue(). Method in class com.ibm.excelaccessor.NotEditableEditor

Returns null as the editor is to be used for properties which are not editable.

getValueAsArray(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the value property as a 2-Dimensional array of objects.

getWorkbookName(). Method in class com.ibm.excelaccessor.event.ExcelAccessorErrorEvent

Returns the workbook that caused this event to be fired.

getWorkbookName(). Method in class com.ibm.excelaccessor.event.ExcelCellEvent

Returns the name of the workbook containing the range.

getWorkbookName(). Method in class com.ibm.excelaccessor.event.ExcelRangeEvent

Returns the name of the workbook containing the range.

getWorkbookName(). Method in class com.ibm.excelaccessor.event.ExcelSheetEvent

Returns the name of the affected workbook.

getWorkbookName(). Method in class com.ibm.excelaccessor.ExcelWorkbook

Returns the workbook name

getWorkbookName(). Method in class com.ibm.excelaccessor.event.ExcelWorkbookEvent

Returns the name of the affected workbook.

getWorkbookName(). Method in class com.ibm.excelaccessor.event.FileSavingEvent

Returns the name of the workbook.

getWorksheetName(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the name of the worksheet.

getWorksheetName(). Method in class com.ibm.excelaccessor.event.ExcelCellErrorEvent

Returns the name of the worksheet in which the range is present

getWorksheetName(). Method in class com.ibm.excelaccessor.event.ExcelCellEvent

Returns the name of the worksheet in which the range was initialized.

getWorksheetName(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the name of the worksheet.

getWorksheetName(). Method in class com.ibm.excelaccessor.event.ExcelRangeErrorEvent

Returns the name of the worksheet in which the range is present

getWorksheetName(). Method in class com.ibm.excelaccessor.event.ExcelRangeEvent

Returns the name of the worksheet in which the range was initialized.

getWorksheets(). Method in class com.ibm.excelaccessor.ExcelWorkbook

Returns the worksheets in the current workbook.

H

hasArray(). Method in class com.ibm.excelaccessor.ExcelCell

Method to check whether the cell is part of an array.

hasArray(). Method in class com.ibm.excelaccessor.ExcelRange

Method to check whether the range is part of an array.

hasFormula(). Method in class com.ibm.excelaccessor.ExcelCell

Method to check whether the cell contains a formula.

hasFormula(). Method in class com.ibm.excelaccessor.ExcelRange

Method to check whether the cells in the range contain formulae.

I

inaccessibleWorkbook(ExcelWorkbookErrorEvent). Method in interface com.ibm.excelaccessor.event.ExcelWorkbookErrorListener

This method is called when an attempt to write to a workbook file opened in the read mode

initCell(). Method in class com.ibm.excelaccessor.ExcelCell

A call to this method initializes the cell bean and essentially turns it on for further use.

initRange(). Method in class com.ibm.excelaccessor.ExcelRange

A call to this method initializes the range and essentially turns it on for further use.

insertWorksheet(). Method in class com.ibm.excelaccessor.ExcelCell

Inserts a new worksheet in the workbook and renames it to the worksheetName of this range.

insertWorksheet(). Method in class com.ibm.excelaccessor.ExcelRange

Inserts a new worksheet in the workbook and renames it to the worksheetName of this range.

isAutoCreateSheet(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the value of the autoCreateSheet property.

isAutoCreateSheet(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the value of the autoCreateSheet property.

isAutoUnprotectSheet(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the value of the autoUnprotectSheet property.

isAutoUnprotectSheet(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the value of the autoUnprotectSheet property.

isInitialized(). Method in class com.ibm.excelaccessor.ExcelCell

Returns the status of the initialization of the cell bean.

isInitialized(). Method in class com.ibm.excelaccessor.ExcelRange

Returns the status of the initialization of the range bean.

isOpened(). Method in class com.ibm.excelaccessor.ExcelWorkbook

Returns the status of the workbook

isPaintable(). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

Returns true as this editor honors the paintValue method.

isPaintable(). Method in class com.ibm.excelaccessor.NotEditableEditor

Returns true as this editor honors the paintValue method.

isReadOnly(). Method in class com.ibm.excelaccessor.ExcelWorkbook

Returns the flag indicating the workbook access mode.

isReadOnly(). Method in class com.ibm.excelaccessor.event.ExcelWorkbookEvent

Returns whether the file has been opened in the read only mode or not.

isSaveOnClose(). Method in class com.ibm.excelaccessor.ExcelWorkbook

Returns the flag indicating whether the workbook should be saved or not.

isSaveOnClose(). Method in class com.ibm.excelaccessor.event.ExcelWorkbookEvent

Returns whether the file has been saved before being closed.

N

NotEditableEditor(). Constructor for class com.ibm.excelaccessor.NotEditableEditor

Constructs the required NotEditableEditor.

O

openWorkbook(). Method in class com.ibm.excelaccessor.ExcelWorkbook

This method is called to open the Workbook.

P

paintValue(Graphics, Rectangle). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

Paint a representation of the file name into a given area of screen real estate.

paintValue(Graphics, Rectangle). Method in class com.ibm.excelaccessor.NotEditableEditor

Paints that the property is not editable into a given area of screen real estate.

propertyChange(PropertyChangeEvent). Method in class com.ibm.excelaccessor.ExcelCell

The listener method for property change events.

propertyChange(PropertyChangeEvent). Method in class com.ibm.excelaccessor.ExcelRange

The listener method for property change events.

R

RANGE_INITIALIZED. Static variable in class com.ibm.excelaccessor.event.ExcelRangeEvent

The id for the RANGE_INITIALIZED type of event.

RANGE_UNINITIALIZED. Static variable in class com.ibm.excelaccessor.event.ExcelRangeEvent

The id for the RANGE_UNINITIALIZED type of event.

rangeInitialized(ExcelRangeEvent). Method in interface com.ibm.excelaccessor.event.ExcelRangeListener

Invoked when the initRange() method is called to initialize a range and that range is successfully initialized.

rangeUninitialized(ExcelRangeEvent). Method in interface com.ibm.excelaccessor.event.ExcelRangeListener

Invoked when the range gets uninitialized.

removeExcelCellErrorListener(ExcelCellErrorListener). Method in class com.ibm.excelaccessor.ExcelCell

Removes the specified ExcelCellErrorListener so that it no longer receives ExcelCellErrorEvents from this bean.

removeExcelCellListener(ExcelCellListener). Method in class com.ibm.excelaccessor.ExcelCell

Removes the specified ExcelCellListener so that it no longer receives ExcelCellEvents from this bean.

removeExcelRangeErrorListener(ExcelRangeErrorListener). Method in class com.ibm.excelaccessor.ExcelRange

Removes the specified ExcelRangeErrorListener so that it no longer receives ExcelRangeErrorEvents from this bean.

removeExcelRangeListener(ExcelRangeListener). Method in class com.ibm.excelaccessor.ExcelRange

Removes the specified ExcelRangeListener so that it no longer receives ExcelRangeEvents from this bean.

removeExcelSheetListener(ExcelSheetListener). Method in class com.ibm.excelaccessor.ExcelCell

Removes the specified ExcelSheetListener so that it no longer receives ExcelSheetEvents from this bean.

removeExcelSheetListener(ExcelSheetListener). Method in class com.ibm.excelaccessor.ExcelRange

Removes the specified ExcelSheetListener so that it no longer receives ExcelSheetEvents from this bean.

removeExcelWorkbookErrorListener(ExcelWorkbookErrorListener). Method in class com.ibm.excelaccessor.ExcelWorkbook

Removes the specified ExcelWorkbookError listener so that it no longer receives ExcelWorkbookError events from this bean.

removeExcelWorkbookListener(ExcelWorkbookListener). Method in class com.ibm.excelaccessor.ExcelWorkbook

Removes the specified ExcelWorkbook listener so that it no longer receives ExcelWorkbook events from this bean.

removeFetchArgumentsListener(FetchArgumentsListener). Method in class com.ibm.excelaccessor.ExcelCell

Removes the specified FetchArgumentsListener so that it no longer receives FetchArgumentsEvents from this bean.

removeFetchArgumentsListener(FetchArgumentsListener). Method in class com.ibm.excelaccessor.ExcelRange

Removes the specified FetchArgumentsListener so that it no longer receives FetchArgumentsEvents from this bean.

removeFetchArgumentsListener(FetchArgumentsListener). Method in class com.ibm.excelaccessor.ExcelWorkbook

Removes the specified FetchArguments listener so that it no longer receives FetchArguments events from this bean.

removeFetchPasswordListener(FetchPasswordListener). Method in class com.ibm.excelaccessor.ExcelCell

Removes the specified FetchPasswordListener so that it no longer receives FetchPasswordEvents from this bean.

removeFetchPasswordListener(FetchPasswordListener). Method in class com.ibm.excelaccessor.ExcelRange

Removes the specified FetchPasswordListener so that it no longer receives FetchPasswordEvents from this bean.

removeFetchPasswordListener(FetchPasswordListener). Method in class com.ibm.excelaccessor.ExcelWorkbook

Removes the specified FetchPassword listener so that it no longer receives FetchPassword events from this bean.

removeFileSavingListener(FileSavingListener). Method in class com.ibm.excelaccessor.ExcelWorkbook

Removes the specified FileSaving listener so that it no longer receives FileSaving events from this bean.

removePropertyChangeListener(PropertyChangeListener). Method in class com.ibm.excelaccessor.ExcelCell

Removes the specified PropertyChangeListener so that it no longer receives PropertyChangeEvents from this bean.

removePropertyChangeListener(PropertyChangeListener). Method in class com.ibm.excelaccessor.ExcelRange

Removes the specified PropertyChangeListener so that it no longer receives PropertyChangeEvents from this bean.

removePropertyChangeListener(PropertyChangeListener). Method in class com.ibm.excelaccessor.ExcelWorkbook

Removes the specified PropertyChange listener so that it no longer receives PropertyChange events from this bean.

removePropertyChangeListener(PropertyChangeListener). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

Remove a listener for the PropertyChange event.

removeWorksheet(). Method in class com.ibm.excelaccessor.ExcelCell

Removes a worksheet from the workbook.

removeWorksheet(). Method in class com.ibm.excelaccessor.ExcelRange

Removes a worksheet from the workbook.

S

savingFile(FileSavingEvent). Method in interface com.ibm.excelaccessor.event.FileSavingListener

Invoked when a modified file is being closed and a decision is being made whether or not to save that file, depending upon the saveOnClose flag in the ExcelWorkbook class.

setAsText(String). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

Set the file name as the given String.

setAutoCreateSheet(boolean). Method in class com.ibm.excelaccessor.ExcelCell

Sets the value of the autoCreateSheet property.

setAutoCreateSheet(boolean). Method in class com.ibm.excelaccessor.ExcelRange

Sets the value of the autoCreateSheet property.

setAutoUnprotectSheet(boolean). Method in class com.ibm.excelaccessor.ExcelCell

Sets the value of the autoUnprotectSheet property.

setAutoUnprotectSheet(boolean). Method in class com.ibm.excelaccessor.ExcelRange

Sets the value of the autoUnprotectSheet property.

setCellR1C1(int, int). Method in class com.ibm.excelaccessor.ExcelCell

This method can be used to identify a single cell as the range to be accessed using the cell row and column numbers.

setCellR1C1(int, int). Method in class com.ibm.excelaccessor.ExcelRange

This method can be used to identify a single cell as the range to be accessed using the cell row and column numbers.

setFormat(String). Method in class com.ibm.excelaccessor.ExcelCell

Sets the format property of this cell.

setFormat(String). Method in class com.ibm.excelaccessor.ExcelRange

Sets the format property of this Range.

setFormula(String). Method in class com.ibm.excelaccessor.ExcelCell

Sets the formula property of the cell.

setFormula(Vector). Method in class com.ibm.excelaccessor.ExcelRange

Sets the formula property of this Range.

setFormulaAsObject(Object). Method in class com.ibm.excelaccessor.ExcelRange

Sets the formula for this range.

setNoteText(String). Method in class com.ibm.excelaccessor.ExcelCell

Sets the noteText for the cell.

setNoteText(String). Method in class com.ibm.excelaccessor.ExcelRange

Sets the noteText for the top-left cell of this range.

setRangeName(String). Method in class com.ibm.excelaccessor.ExcelCell

Sets the name of the Range to be accessed.

setRangeName(String). Method in class com.ibm.excelaccessor.ExcelRange

Sets the name of the Range to be accessed.

setRangeR1C1(int, int, int, int). Method in class com.ibm.excelaccessor.ExcelCell

This method can be used to identify the range to be accessed using the positions of the top-left and bottom-right cells.

setRangeR1C1(int, int, int, int). Method in class com.ibm.excelaccessor.ExcelRange

This method can be used to identify the range to be accessed using the positions of the top-left and bottom-right cells

setReadOnly(boolean). Method in class com.ibm.excelaccessor.ExcelWorkbook

Sets the flag indicating the mode that the workbook should be opened in.

setSaveOnClose(boolean). Method in class com.ibm.excelaccessor.ExcelWorkbook

Sets the flag indicating whether the workbook should be saved before closing.

setValue(Object). Method in class com.ibm.excelaccessor.ExcelCell

Sets the value property of this cell.

setValue(Object). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

Sets the file name that is to be edited.

setValue(Object). Method in class com.ibm.excelaccessor.NotEditableEditor

Does not do anything, as the property is not editable.

setValue(Vector). Method in class com.ibm.excelaccessor.ExcelRange

Sets the value property of this Range.

setValueAsObject(Object). Method in class com.ibm.excelaccessor.ExcelRange

Sets the value for this range.

setWorkbookName(String). Method in class com.ibm.excelaccessor.ExcelWorkbook

Sets the name of the workbook.

setWorkbookProtectionPassword(String). Method in class com.ibm.excelaccessor.ExcelWorkbook

Sets the Workbook ProtectionPassword.

setWorkbookStructureProtectionPassword(String). Method in class com.ibm.excelaccessor.ExcelWorkbook

Stores the Workbook StructureProtectionPassword.

setWorkbookWriteReservationPassword(String). Method in class com.ibm.excelaccessor.ExcelWorkbook

Stores the Workbook WriteReservationPassword.

setWorksheetName(String). Method in class com.ibm.excelaccessor.ExcelCell

Sets the name of the worksheet to be accessed.

setWorksheetName(String). Method in class com.ibm.excelaccessor.ExcelRange

Sets the name of the worksheet to be accessed.

setWorksheetProtectionPassword(String). Method in class com.ibm.excelaccessor.ExcelCell

Sets the worksheet protection password to be used while unprotecting the worksheet.

setWorksheetProtectionPassword(String). Method in class com.ibm.excelaccessor.ExcelRange

Sets the worksheet protection password to be used while unprotecting the worksheet.

setXlWorkbook(ExcelWorkbook). Method in class com.ibm.excelaccessor.ExcelCell

Sets the reference to the ExcelWorkbook bean that this cell bean operates on.

setXlWorkbook(ExcelWorkbook). Method in class com.ibm.excelaccessor.ExcelRange

Sets the reference to the ExcelWorkbook bean that this Range bean operates on.

SHEET_INSERTED. Static variable in class com.ibm.excelaccessor.event.ExcelSheetEvent

The id for the SHEET_INSERTED type of event.

SHEET_REMOVED. Static variable in class com.ibm.excelaccessor.event.ExcelSheetEvent

The id for the SHEET_REMOVED type of event.

sheetInserted(ExcelSheetEvent). Method in interface com.ibm.excelaccessor.event.ExcelSheetListener

Invoked when a sheet has been inserted in a workbook.

sheetRemoved(ExcelSheetEvent). Method in interface com.ibm.excelaccessor.event.ExcelSheetListener

Invoked when a sheet has been removed from a workbook.

supportsCustomEditor(). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

Returns true as a custom editor is supported.

supportsCustomEditor(). Method in class com.ibm.excelaccessor.NotEditableEditor

Returns true as custom property editor is supported.

T

textValueChanged(TextEvent). Method in class com.ibm.excelaccessor.FileNamePropertyEditor

Handles changes made to the text in the textfield.

toString(). Method in class com.ibm.excelaccessor.event.ExcelAccessorErrorEvent

Overrides toString in Object

U

UnInitializedCellException(). Constructor for class com.ibm.excelaccessor.UnInitializedCellException

Constructs a UnInitializedCellException with no detail message.

UnInitializedCellException(String). Constructor for class com.ibm.excelaccessor.UnInitializedCellException

Constructs a UnInitializedCellException with the specified detail message.

UnInitializedRangeException(). Constructor for class com.ibm.excelaccessor.UnInitializedRangeException

Constructs a UnInitializedRangeException with no detail message.

UnInitializedRangeException(String). Constructor for class com.ibm.excelaccessor.UnInitializedRangeException

Constructs a UnInitializedRangeException with the specified detail message.

unprotectWorkbookStructure(). Method in class com.ibm.excelaccessor.ExcelWorkbook

This method unprotects the workbook structure/windows.

unprotectWorksheet(). Method in class com.ibm.excelaccessor.ExcelCell

Unprotects the worksheet.

unprotectWorksheet(). Method in class com.ibm.excelaccessor.ExcelRange

Unprotects the worksheet.

W

WKBK_PROTECTION_PASSWD_REQD. Static variable in class com.ibm.excelaccessor.event.FetchPasswordEvent

The type of event when the workbook protection password is required.

WKBK_STRUCTURE_PROTECTION_PASSWD_REQD. Static variable in class com.ibm.excelaccessor.event.FetchPasswordEvent

The type of event when the workbook structure protection password is required.

WKBK_WRITE_RESERVATION_PASSWD_REQD. Static variable in class com.ibm.excelaccessor.event.FetchPasswordEvent

The type of event when the workbook write reservation password is required.

WORKBOOK_CLOSED. Static variable in class com.ibm.excelaccessor.event.ExcelWorkbookEvent

The id for the WORKBOOK_CLOSED type of event.

WORKBOOK_INACCESSIBLE. Static variable in class com.ibm.excelaccessor.event.ExcelWorkbookErrorEvent

The flag to indicate the event to be fired

WORKBOOK_OPENED. Static variable in class com.ibm.excelaccessor.event.ExcelWorkbookEvent

The id for the WORKBOOK_OPENED type of event.

WORKBOOK_STRUCTURE_UNPROTECTED. Static variable in class com.ibm.excelaccessor.event.ExcelWorkbookEvent

The id for the WORKBOOK_STRUCTURE_UNPROTECTED type of event.

workbookClosed(ExcelWorkbookEvent). Method in interface com.ibm.excelaccessor.event.ExcelWorkbookListener

Invoked when a workbook has been closed.

workbookOpened(ExcelWorkbookEvent). Method in interface com.ibm.excelaccessor.event.ExcelWorkbookListener

Invoked when a workbook has been opened.

workbookStructureUnprotected(ExcelWorkbookEvent). Method in interface com.ibm.excelaccessor.event.ExcelWorkbookListener

Invoked when a workbook's structure has been unprotected.

WORKSHEET_PROTECTION_PASSWD_REQD. Static variable in class com.ibm.excelaccessor.event.FetchPasswordEvent

The type of event when the worksheet protection password is required.

WRITE_MODE_OPEN_FAIL. Static variable in class com.ibm.excelaccessor.event.ExcelWorkbookErrorEvent

The flag to indicate the event to be fired

writeModeOpenFailed(ExcelWorkbookErrorEvent). Method in interface com.ibm.excelaccessor.event.ExcelWorkbookErrorListener

This method is called when an attempt to open a workbook file in the write mode fails.