A C D E F G H I N O P R S T U W

A

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.

addExcelFormat(int, int, ExcelFormat) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Adds the argument ExcelFormat bean to the model to the specified position.

addExcelFormatListener(ExcelFormatListener) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Adds an eventlistener to the 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.ExcelRange

Adds the specified ExcelSheetListener to receive ExcelSheet 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.

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.ExcelRange

Adds the specified FetchArgumentsListener to receive FetchArguments events from the ExcelRange 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.ExcelWorkbook

Adds the specified FetchArguments listener to receive FetchArgument events from the ExcelWorkbook 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.ExcelCell

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.ExcelRange

Adds the specified PropertyChangeListener to receive PropertyChange events from the ExcelRange 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.ExcelFormat

The addPropertyChangeListener method was generated to support the propertyChange field.

addPropertyChangeListener(PropertyChangeListener) - Method in class com.ibm.excelaccessor.ExcelFormatModel

The addPropertyChangeListener method was generated to support the propertyChange field.

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

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

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

The addPropertyChangeListener method was generated to support the propertyChange field.

addPropertyChangeListener(String, PropertyChangeListener) - Method in class com.ibm.excelaccessor.ExcelFormat

The addPropertyChangeListener method was generated to support the propertyChange field.

addPropertyChangeListener(String, PropertyChangeListener) - Method in class com.ibm.excelaccessor.ExcelFormatModel

The addPropertyChangeListener method was generated to support the propertyChange field.

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.ExcelRange

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

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

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

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

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

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

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

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.

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

Clears all cell formatting information for this cell, the value, noteText and formula 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.

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

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

closeExcelApplication() - Method in class com.ibm.excelaccessor.ExcelWorkbook

The method to close the application.

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

The method to close the workbook.

com.ibm.excelaccessor - package com.ibm.excelaccessor

com.ibm.excelaccessor.event - package com.ibm.excelaccessor.event

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.

D

DOUBLE - Static variable in class com.ibm.excelaccessor.ExcelFormat

This ID can be used for setting the underline property to DOUBLE according to the Ms Excel.

DOUBLE_ACCOUNTING - Static variable in class com.ibm.excelaccessor.ExcelFormat

This ID can be used for setting the underline property to DOUBLE_ACCOUNTING according to the Ms Excel.

E

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

The flag indicating the event to be fired

ExcelAccessorErrorEvent - class com.ibm.excelaccessor.event.ExcelAccessorErrorEvent.

The ExcelAccessorErrorEvent is the abstract base class for events occurring in the ExcelAccessor suite of beans.

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

Constructs a ExcelAccessorErrorEvent object with the specified source object.

ExcelAccessorException - exception com.ibm.excelaccessor.ExcelAccessorException.

Signals that an exception occurred in the ExcelAccessor bean suite.

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 - class com.ibm.excelaccessor.ExcelCell.

This bean represents a cell in an Excel Worksheet.

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

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

ExcelCellErrorEvent - class com.ibm.excelaccessor.event.ExcelCellErrorEvent.

The ExcelCellErrorEvent is fired when an error occurs on the ExcelCell bean.

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.

ExcelCellErrorListener - interface com.ibm.excelaccessor.event.ExcelCellErrorListener.

This is the interface to be implemented to listen to errors occurring on the ExcelCell bean.

ExcelCellEvent - class com.ibm.excelaccessor.event.ExcelCellEvent.

This event is fired when a cell has been successfully initialized, or uninitialized

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.

ExcelCellListener - interface com.ibm.excelaccessor.event.ExcelCellListener.

The listener interface for receiving ExcelCellEvent

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.

ExcelFormat - class com.ibm.excelaccessor.ExcelFormat.

This bean represents some format-related properties of a cell.

ExcelFormat() - Constructor for class com.ibm.excelaccessor.ExcelFormat

ExcelFormat constructor.

ExcelFormatEvent - class com.ibm.excelaccessor.event.ExcelFormatEvent.

This is the event class to support the com.ibm.excelaccessor.ExcelFormatListener interface.

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

ExcelFormatEvent constructor

ExcelFormatListener - interface com.ibm.excelaccessor.event.ExcelFormatListener.

This is the interface to be implemented to listen to ExcelFormatEvent events.

ExcelFormatModel - class com.ibm.excelaccessor.ExcelFormatModel.

The ExcelFormatModel bean together with the ExcelFormat bean lets you to access and modify some of these properties from Java code.

ExcelFormatModel() - Constructor for class com.ibm.excelaccessor.ExcelFormatModel

ExcelFormatModel constructor comment.

ExcelRange - class com.ibm.excelaccessor.ExcelRange.

This bean represents an Excel range and is used to access that range from the ExcelWorkbook supplied to this range.

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

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

ExcelRangeErrorEvent - class com.ibm.excelaccessor.event.ExcelRangeErrorEvent.

The ExcelRangeErrorEvent is fired when an error occurs on the ExcelRange bean.

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.

ExcelRangeErrorListener - interface com.ibm.excelaccessor.event.ExcelRangeErrorListener.

This is the interface to be implemented to listen to errors occurring on the ExcelRange.

ExcelRangeEvent - class com.ibm.excelaccessor.event.ExcelRangeEvent.

This event is fired when a range has been successfully initialized, or uninitialized

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.

ExcelRangeListener - interface com.ibm.excelaccessor.event.ExcelRangeListener.

The listener interface for receiving ExcelRangeEvent

ExcelSheetEvent - class com.ibm.excelaccessor.event.ExcelSheetEvent.

This event is fired to signal the insertion or removal of a worksheet from an Excel file.

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.

ExcelSheetListener - interface com.ibm.excelaccessor.event.ExcelSheetListener.

The listener interface for receiving ExcelSheet events which occur on an ExcelRange bean.

ExcelWorkbook - class com.ibm.excelaccessor.ExcelWorkbook.

The ExcelWorkbook class is a bean belonging to the ExcelAccessor bean suite.

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

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

ExcelWorkbookErrorEvent - class com.ibm.excelaccessor.event.ExcelWorkbookErrorEvent.

The ExcelWorkbookErrorEvent is fired when an error occurs in the ExcelWorkbook bean.

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

Constructs a ExcelWorkbookErrorEvent object with the specified source object.

ExcelWorkbookErrorListener - interface com.ibm.excelaccessor.event.ExcelWorkbookErrorListener.

This is the interface to be implemented to listen to errors occurring on the ExcelWorkbook.

ExcelWorkbookEvent - class com.ibm.excelaccessor.event.ExcelWorkbookEvent.

This event is fired to signal the opening, closing or the unprotecting of the structure of the workbook.

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.

ExcelWorkbookListener - interface com.ibm.excelaccessor.event.ExcelWorkbookListener.

The listener interface for receiving ExcelWorkbookEvents.

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 - class com.ibm.excelaccessor.event.FetchArgumentsEvent.

This event is thrown when initRange(), insertWorksheet() or removeWorksheet() methods of com.ibm.excelaccessor.ExcelRange are called.

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

Constructs a FetchArgumentsEvent object with the specified source object.

FetchArgumentsListener - interface com.ibm.excelaccessor.event.FetchArgumentsListener.

The listener interface for receiving FetchArgumentsEvent

FetchPasswordEvent - class com.ibm.excelaccessor.event.FetchPasswordEvent.

This event is fired when an operation in Excel requires a password for successful completion.

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.

FetchPasswordListener - interface com.ibm.excelaccessor.event.FetchPasswordListener.

The listener interface for receiving FetchPasswordEvents.

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.

FileSavingEvent - class com.ibm.excelaccessor.event.FileSavingEvent.

This event is fired to signal that a modified workbook file is being closed and the status of the saveOnClose flag of the ExcelWorkbook will be used to determine whether it will be saved or not.

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.

FileSavingListener - interface com.ibm.excelaccessor.event.FileSavingListener.

The listener interface for receiving FileSavingEvent.

FILLED - Static variable in class com.ibm.excelaccessor.event.ExcelFormatEvent

The id for the FILLED type of event.

filledModel(ExcelFormatEvent) - Method in interface com.ibm.excelaccessor.event.ExcelFormatListener

This method is called when the ExcelFormatModel bean has been successfully filled from an Excel workbook.

fillExcelFormatModel() - Method in class com.ibm.excelaccessor.ExcelRange

Fills the ExcelFormatModel bean from the range.

fillExcelFormatModel() - Method in class com.ibm.excelaccessor.ExcelCell

Fills the ExcelFormatModel bean from the cell.

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.

fireFilledModel(ExcelFormatEvent) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Method to support listener events.

firePropertyChange(PropertyChangeEvent) - Method in class com.ibm.excelaccessor.ExcelCell

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(PropertyChangeEvent) - Method in class com.ibm.excelaccessor.ExcelFormat

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(PropertyChangeEvent) - Method in class com.ibm.excelaccessor.ExcelFormatModel

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(String, boolean, boolean) - Method in class com.ibm.excelaccessor.ExcelCell

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(String, boolean, boolean) - Method in class com.ibm.excelaccessor.ExcelFormat

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(String, boolean, boolean) - Method in class com.ibm.excelaccessor.ExcelFormatModel

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(String, int, int) - Method in class com.ibm.excelaccessor.ExcelCell

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(String, int, int) - Method in class com.ibm.excelaccessor.ExcelFormat

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(String, int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(String, Object, Object) - Method in class com.ibm.excelaccessor.ExcelRange

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(String, Object, Object) - Method in class com.ibm.excelaccessor.ExcelCell

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(String, Object, Object) - Method in class com.ibm.excelaccessor.ExcelFormat

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(String, Object, Object) - Method in class com.ibm.excelaccessor.ExcelFormatModel

The firePropertyChange method was generated to support the propertyChange field.

firePropertyChange(String, Object, Object) - Method in class com.ibm.excelaccessor.ExcelWorkbook

The firePropertyChange method was generated to support the propertyChange field.

fireSavedModel(ExcelFormatEvent) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Method to support listener events.

G

getAboutThisBean() - Method in class com.ibm.excelaccessor.ExcelRange

Gets the aboutThisBean property (java.lang.String) value.

getAboutThisBean() - Method in class com.ibm.excelaccessor.ExcelCell

Gets the aboutThisBean property (java.lang.String) value.

getAboutThisBean() - Method in class com.ibm.excelaccessor.ExcelFormat

Gets the aboutThisBean property (java.lang.String) value.

getAboutThisBean() - Method in class com.ibm.excelaccessor.ExcelFormatModel

Gets the aboutThisBean property (java.lang.String) value.

getAboutThisBean() - Method in class com.ibm.excelaccessor.ExcelWorkbook

getAutoGetUsedRange() - Method in class com.ibm.excelaccessor.ExcelRange

Gets the autoGetUsedRange property (boolean) value.

getColor() - Method in class com.ibm.excelaccessor.ExcelFormat

Gets the color property (java.awt.Color) value.

getColor(int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the getColor query to the ExcelFormat bean situated in the specified position.

getColorAsDouble() - Method in class com.ibm.excelaccessor.ExcelFormat

Gets the color property as a double value.

getColorAsDouble(int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the getColorAsDouble query to the ExcelFormat bean situated in the specified position.

getColumnCount() - Method in class com.ibm.excelaccessor.ExcelFormatModel

Gets the columncount property.

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

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

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

Returns the exception that caused this event to be fired.

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.ExcelRange

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

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.ExcelRangeEvent

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.event.ExcelRangeErrorEvent

Returns the ending column 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.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.ExcelRangeEvent

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.event.ExcelRangeErrorEvent

Returns the ending row number for the range.

getExcelFormat(int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Gets the ExcelFormat bean situated in the specified position.

getExcelFormatModel() - Method in class com.ibm.excelaccessor.ExcelRange

Gets the excelFormatModel property (com.ibm.excelaccessor.ExcelFormatModel) value.

getExcelFormatModel() - Method in class com.ibm.excelaccessor.ExcelCell

Gets the excelFormatModel property (com.ibm.excelaccessor.ExcelFormatModel) value.

getFontStyle() - Method in class com.ibm.excelaccessor.ExcelFormat

Gets the fontstyle property.

getFontStyle(int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the getFontStyle query to the ExcelFormat bean situated in the specified position.

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

Returns the Format property of the range as a String.

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

Returns the Format property of 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.

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

Returns the Formula property for the Cell as a String.

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

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

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.ExcelCellEvent

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.FetchPasswordEvent

Returns an event-id indicating the type of event.

getId() - Method in class com.ibm.excelaccessor.event.ExcelFormatEvent

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.

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.

getName() - Method in class com.ibm.excelaccessor.ExcelFormat

Gets the name property (java.lang.String) value.

getName(int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the getName query to the ExcelFormat bean situated in the specified position.

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

Returns the number of columns present in the range.

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

Returns the number of columns present in the range.

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

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

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

Returns the noteText for the cell.

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

Returns the number of rows present in the range.

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

Returns the number of rows present in the range.

getNumberFormat() - Method in class com.ibm.excelaccessor.ExcelFormat

Gets the numberformat property (java.lang.String) value.

getNumberFormat(int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the getNumberFormat query to the ExcelFormat bean situated in the specified position.

getPropertyChange() - Method in class com.ibm.excelaccessor.ExcelRange

Accessor for the propertyChange field.

getPropertyChange() - Method in class com.ibm.excelaccessor.ExcelCell

Accessor for the propertyChange field.

getPropertyChange() - Method in class com.ibm.excelaccessor.ExcelFormat

Accessor for the propertyChange field.

getPropertyChange() - Method in class com.ibm.excelaccessor.ExcelFormatModel

Accessor for the propertyChange field.

getPropertyChange() - Method in class com.ibm.excelaccessor.ExcelWorkbook

Accessor for the propertyChange field.

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.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.ExcelRangeEvent

Returns the name of the range that has been initialized.

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.event.ExcelRangeErrorEvent

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

getRowCount() - Method in class com.ibm.excelaccessor.ExcelFormatModel

Gets the rowcount property.

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

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

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

Returns the name of the sheet concerned with this event.

getSize() - Method in class com.ibm.excelaccessor.ExcelFormat

Gets the size property (int) value.

getSize(int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the getSize query to the ExcelFormat bean situated in the specified position.

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.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.ExcelRangeEvent

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.event.ExcelRangeErrorEvent

Returns the starting column 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.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.ExcelRangeEvent

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.event.ExcelRangeErrorEvent

Returns the starting row number for the range.

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

Returns the Text property for the Range.

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

Returns the Text property for the Range.

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

Returns the reference to this workbook.

getUnderline() - Method in class com.ibm.excelaccessor.ExcelFormat

Gets the underline property (int) value.

getUnderline(int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the getUnderline query to the ExcelFormat bean situated in the specified position.

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

Returns the Value property for the Range.

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

Returns the Value property for the Range.

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.ExcelWorkbook

Returns the workbook name

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.ExcelRangeEvent

Returns the name of the workbook containing the range.

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.FileSavingEvent

Returns the name of the workbook.

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

Returns the name of the affected workbook.

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

Returns the name of the affected workbook.

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

Returns the name of the worksheet.

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.ExcelRangeEvent

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

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.event.ExcelRangeErrorEvent

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

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

Returns the worksheets in the current workbook.

H

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

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

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

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

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

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

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

Method to check whether the cell contains a formula.

hasListeners(String) - Method in class com.ibm.excelaccessor.ExcelCell

The hasListeners method was generated to support the propertyChange field.

hasListeners(String) - Method in class com.ibm.excelaccessor.ExcelFormat

The hasListeners method was generated to support the propertyChange field.

hasListeners(String) - Method in class com.ibm.excelaccessor.ExcelFormatModel

The hasListeners method was generated to support the propertyChange field.

I

id - Variable in class com.ibm.excelaccessor.event.ExcelRangeEvent

The event-id indicating the type of event.

id - Variable in class com.ibm.excelaccessor.event.ExcelCellEvent

The event-id indicating the type of event.

id - Variable in class com.ibm.excelaccessor.event.ExcelSheetEvent

The event-id indicating the type of event.

id - Variable in class com.ibm.excelaccessor.event.FetchPasswordEvent

The event-id indicating the type of event.

id - Variable in class com.ibm.excelaccessor.event.ExcelWorkbookEvent

The event-id indicating the type of event.

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.

initialize() - Method in class com.ibm.excelaccessor.ExcelFormatModel

Initializes the model.

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.ExcelRange

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

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

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

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

Returns the value of the autoCreateSheet property.

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

Returns the value of the autoCreateSheet property.

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

Returns the value of the autoUnprotectSheet property.

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

Returns the value of the autoUnprotectSheet property.

isBold() - Method in class com.ibm.excelaccessor.ExcelFormat

Checks whether the font style of the appropriate cell is bold.

isBold(int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the isBold query to the ExcelFormat bean situated in the specified position.

isExcelfile(String) - Method in class com.ibm.excelaccessor.ExcelWorkbook

This method was created in VisualAge.

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

Returns the status of the initialization of the range bean.

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.ExcelFormatModel

Checks whether the model is in initialized state.

isItalic() - Method in class com.ibm.excelaccessor.ExcelFormat

Checks whether the font style of the appropriate cell is italic.

isItalic(int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the isItalic query to the ExcelFormat bean situated in the specified position.

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

Returns the status of the workbook

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

newWorkbook() - Method in class com.ibm.excelaccessor.ExcelWorkbook

This method is called to create the new Workbook.

NONE - Static variable in class com.ibm.excelaccessor.ExcelFormat

This ID can be used for setting the underline property to NONE according to the Ms Excel.

O

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

This method is called to open the Workbook.

P

propertyChange - Variable in class com.ibm.excelaccessor.ExcelRange

propertyChange - Variable in class com.ibm.excelaccessor.ExcelCell

propertyChange - Variable in class com.ibm.excelaccessor.ExcelFormat

propertyChange - Variable in class com.ibm.excelaccessor.ExcelFormatModel

propertyChange - Variable in class com.ibm.excelaccessor.ExcelWorkbook

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

The listener method for property change events.

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

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.

rangeName - Variable in class com.ibm.excelaccessor.event.ExcelRangeEvent

The name of the range which has been initialised or uninitialised.

rangeName - Variable in class com.ibm.excelaccessor.event.ExcelCellEvent

The name of the range which has been initialised or uninitialised.

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

Invoked when the range gets uninitialized.

readOnly - Variable in class com.ibm.excelaccessor.event.ExcelWorkbookEvent

Indicates whether the file was opened in the read-only mode.

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.

removeExcelFormatListener(ExcelFormatListener) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Removes a listener from the 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.ExcelRange

Removes the specified ExcelSheetListener so that it no longer receives ExcelSheetEvents 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.

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.ExcelRange

Removes the specified FetchArgumentsListener so that it no longer receives FetchArgumentsEvents 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.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.ExcelRange

Removes the specified FetchPasswordListener so that it no longer receives FetchPasswordEvents 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.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.ExcelRange

Removes the specified PropertyChangeListener so that it no longer receives PropertyChangeEvents 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.ExcelFormat

The removePropertyChangeListener method was generated to support the propertyChange field.

removePropertyChangeListener(PropertyChangeListener) - Method in class com.ibm.excelaccessor.ExcelFormatModel

The removePropertyChangeListener method was generated to support the propertyChange field.

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(String, PropertyChangeListener) - Method in class com.ibm.excelaccessor.ExcelCell

The removePropertyChangeListener method was generated to support the propertyChange field.

removePropertyChangeListener(String, PropertyChangeListener) - Method in class com.ibm.excelaccessor.ExcelFormat

The removePropertyChangeListener method was generated to support the propertyChange field.

removePropertyChangeListener(String, PropertyChangeListener) - Method in class com.ibm.excelaccessor.ExcelFormatModel

The removePropertyChangeListener method was generated to support the propertyChange field.

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

Removes a worksheet from the workbook.

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

Removes a worksheet from the workbook.

S

SAVED - Static variable in class com.ibm.excelaccessor.event.ExcelFormatEvent

The id for the SAVED type of event.

savedModel(ExcelFormatEvent) - Method in interface com.ibm.excelaccessor.event.ExcelFormatListener

This method is called when the contents of the ExcelFormatModel bean has been successfully saved to an Excel workbook.

saveExcelFormatModel() - Method in class com.ibm.excelaccessor.ExcelRange

Saves the content of the contained ExcelFormatModel bean to the range.

saveExcelFormatModel() - Method in class com.ibm.excelaccessor.ExcelCell

Saves the content of the contained ExcelFormatModel bean to the cell.

saveOnClose - Variable in class com.ibm.excelaccessor.event.ExcelWorkbookEvent

Indicates whether the file was saved before closing if it had been modified.

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.

setAboutThisBean(String) - Method in class com.ibm.excelaccessor.ExcelRange

Sets the aboutThisBean property (java.lang.String) value.

setAboutThisBean(String) - Method in class com.ibm.excelaccessor.ExcelCell

Sets the aboutThisBean property (java.lang.String) value.

setAboutThisBean(String) - Method in class com.ibm.excelaccessor.ExcelFormat

Sets the aboutThisBean property (java.lang.String) value.

setAboutThisBean(String) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Sets the aboutThisBean property (java.lang.String) value.

setAboutThisBean(String) - Method in class com.ibm.excelaccessor.ExcelWorkbook

setAllColor(Color) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Sets the color property for all the ExcelFormat beans contained by the model.

setAllColor(double) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Sets the color property for all the ExcelFormat beans contained by the model.

setAllFontStyle(int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Sets the fontstyle property for all the ExcelFormat beans contained by the model.

setAllName(String) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Sets the name property for all the ExcelFormat beans contained by the model.

setAllNumberFormat(String) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Sets the numberformat property for all the ExcelFormat beans contained by the model.

setAllSize(int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Sets the size property for all the ExcelFormat beans contained by the model.

setAllUnderline(int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Sets the underline property for all the ExcelFormat beans contained by the model.

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

Sets the value of the autoCreateSheet property.

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

Sets the value of the autoCreateSheet property.

setAutoGetUsedRange(boolean) - Method in class com.ibm.excelaccessor.ExcelRange

Sets the autoGetUsedRange property (boolean) value.

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

Sets the value of the autoUnprotectSheet property.

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

Sets the value of the autoUnprotectSheet property.

setBold(boolean) - Method in class com.ibm.excelaccessor.ExcelFormat

Sets the bold property (boolean) value of the font.

setBold(int, int, boolean) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the setBold query to the ExcelFormat bean situated in the specified position.

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.

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.

setColor(Color) - Method in class com.ibm.excelaccessor.ExcelFormat

Sets the color property (java.awt.Color) value.

setColor(double) - Method in class com.ibm.excelaccessor.ExcelFormat

Sets the color property of the bean as a double value.

setColor(int, int, Color) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the setColor query to the ExcelFormat bean situated in the specified position.

setColor(int, int, double) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the setColor query to the ExcelFormat bean situated in the specified position.

setColumnCount(int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Sets the columncount property.

setExcelFormatModel(ExcelFormatModel) - Method in class com.ibm.excelaccessor.ExcelRange

Sets the excelFormatModel property (com.ibm.excelaccessor.ExcelFormatModel) value.

setExcelFormatModel(ExcelFormatModel) - Method in class com.ibm.excelaccessor.ExcelCell

Sets the excelFormatModel property (com.ibm.excelaccessor.ExcelFormatModel) value.

setFontStyle(int) - Method in class com.ibm.excelaccessor.ExcelFormat

Sets the fontstyle property.

setFontStyle(int, int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the setFontStyle query to the ExcelFormat bean situated in the specified position.

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

Sets the format property of this Range.

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

Sets the format property of this cell.

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.

setId(int) - Method in class com.ibm.excelaccessor.event.ExcelFormatEvent

Sets the id indicating the type of event.

setItalic(boolean) - Method in class com.ibm.excelaccessor.ExcelFormat

Sets the italic property (boolean) value of the font.

setItalic(int, int, boolean) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the setItalic query to the ExcelFormat bean situated in the specified position.

setName(int, int, String) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the setName query to the ExcelFormat bean situated in the specified position.

setName(String) - Method in class com.ibm.excelaccessor.ExcelFormat

Sets the name property (java.lang.String) value.

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

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

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

Sets the noteText for the cell.

setNumberFormat(int, int, String) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the setNumberFormat query to the ExcelFormat bean situated in the specified position.

setNumberFormat(String) - Method in class com.ibm.excelaccessor.ExcelFormat

Sets the numberformat property.

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

Sets the name of the Range to be accessed.

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

Sets the name of the Range to be accessed.

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

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.

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

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

setRowCount(int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Sets the rowcount property.

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

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

setSize(int) - Method in class com.ibm.excelaccessor.ExcelFormat

Sets the size property (int) value.

setSize(int, int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the setSize query to the ExcelFormat bean situated in the specified position.

setUnderline(int) - Method in class com.ibm.excelaccessor.ExcelFormat

Sets the underline property (int) value.

setUnderline(int, int, int) - Method in class com.ibm.excelaccessor.ExcelFormatModel

Delegates the setUnderline query to the ExcelFormat bean situated in the specified position.

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

Sets the value property of this cell.

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.ExcelRange

Sets the name of the worksheet to be accessed.

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

Sets the name of the worksheet to be accessed.

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

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

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

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

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

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

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

Sets the reference to the ExcelWorkbook bean that this cell 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.

sheetName - Variable in class com.ibm.excelaccessor.event.ExcelRangeEvent

The name of the worksheet for the range.

sheetName - Variable in class com.ibm.excelaccessor.event.ExcelCellEvent

The name of the worksheet for the range.

sheetName - Variable in class com.ibm.excelaccessor.event.ExcelSheetEvent

The name of the worksheet added or removed.

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

Invoked when a sheet has been removed from a workbook.

SINGLE - Static variable in class com.ibm.excelaccessor.ExcelFormat

This ID can be used for setting the underline property to SINGLE according to the Ms Excel.

SINGLE_ACCOUNTING - Static variable in class com.ibm.excelaccessor.ExcelFormat

This ID can be used for setting the underline property to SINGLE_ACCOUNTING according to the Ms Excel.

T

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

Overrides toString in Object

U

UnInitializedCellException - exception com.ibm.excelaccessor.UnInitializedCellException.

Signals that the requested operation could not be performed as the range had not been Initialized yet.

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 - exception com.ibm.excelaccessor.UnInitializedRangeException.

Signals that the requested operation could not be performed as the range had not been Initialized yet.

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.ExcelRange

Unprotects the worksheet.

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

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.

workbookName - Variable in class com.ibm.excelaccessor.event.ExcelRangeEvent

The name of the workbook containing the range.

workbookName - Variable in class com.ibm.excelaccessor.event.ExcelCellEvent

The name of the workbook containing the range.

workbookName - Variable in class com.ibm.excelaccessor.event.FileSavingEvent

The name of the modified workbook file being closed.

workbookName - Variable in class com.ibm.excelaccessor.event.ExcelSheetEvent

The name of the workbook affected by the operation.

workbookName - Variable in class com.ibm.excelaccessor.event.ExcelWorkbookEvent

The name of the workbook affected by the operation.

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.

A C D E F G H I N O P R S T U W