Search
Workbook Methods
 


 Public Methods

  Name Description

addPropertyChangedListener

Registers listener so that it will receive events from the workbook.

addWorkbookListener

Registers listener so that it will receive events from the workbook.

beginInit

 

cancelChangeOperation

Stops tracking changes by the specified command and reverts all changes done so far.

cancelCompositeOperation

Stops recording the most recently started composite operation and discards the records created so far.

commitChangeOperation

Stops tracking changes by the specified command and saves the command in the history queue.

commitCompositeOperation

Stops recording the most recently started composite operation and saves the composite in the history queue.

endInit

 

evaluateFormulas

Reevaluates all formulas containing custom and volatile functions and their dependent cells.

executeCommand

Executes the specified command on this workbook.

find

Performs a search for a cell containing the specified text, using the specified criteria.

findAll

Finds and returns all cells containing the specified text, using the specified criteria.

getCalculationMaxIterations

Gets the maximum number of iterations when calculating certain functions, such as IRR and RATE.

getCalculationPrecision

Gets the precision when calculating certain functions, such as IRR and RATE.

getCanRedo

Gets a value indicating whether there is a command in the undo history which can be redone.

getCanUndo

Gets a value indicating whether there is a command in the undo history which can be undone.

getCustomNumericFormats

Gets the workbook user defined custom numeric formats.

getDefaultNumericFormats

Gets the workbook defined default numeric formats.

getEnableFormulaEvaluation

Gets a value indicating whether formula evaluation is enabled.

getEnableTypeInference

Gets a value indicating whether cell data is automatically interpreted as a value of a specific type, or accepted as text.

getExtendedEvaluator

Gets a custom expression evaluator. Identifier and function calls that cannot be resolved by the core are delegated to this evaluator.

getExtendedInformationProvider

Gets an information provider for custom functions.

getLocale

Gets the workbook locale.

getLocalization

Gets the workbook localization object.

getNamedRanges

Gets an object that an be used to manage the named ranges in this workbook.

getPrintOptions

Returns a PrintOptions instance that allows customizing various aspects of printing and print-preview.

getShowLeadingApostrophes

Gets a value indicating whether cells should show their leading apostrophe.

getUndoEnabled

Gets a value indicating whether saving action records for later undo is enabled.

getWorksheets

Gets an object that can be used to create and manage the worksheets in this workbook.

loadFromXml

Overloaded.  

print

Overloaded. Prints the current workbook.

redo

Executes again an action saved in the command history.

removePropertyChangedListener

Unregisters listener so that it will no longer receive workbook events.

removeWorkbookListener

Unregisters listener so that it will no longer receive workbook events.

replace

Replaces the data of the specified cell if it matches the specified criteria and returns the next matching cell.

replaceAll

Replaces the data of all cells matching the specified criteria.

saveToXml

Overloaded. Saves the workbook.

setCalculationMaxIterations

Sets the maximum number of iterations when calculating certain functions, such as IRR and RATE.

setCalculationPrecision

Sets the precision when calculating certain functions, such as IRR and RATE.

setEnableFormulaEvaluation

Sets a value indicating whether formula evaluation is enabled.

setEnableTypeInference

Sets a value indicating whether cell data is automatically interpreted as a value of a specific type, or accepted as text.

setExtendedEvaluator

Sets a custom expression evaluator. Identifier and function calls that cannot be resolved by the core are delegated to this evaluator.

setExtendedInformationProvider

Sets an information provider for custom functions.

setLocale

Sets the workbook locale.

setLocalizationInfo

Localizes the UI elements that are related to this workbook with the strings contained in the specified XML file.

setShowLeadingApostrophes

Sets a value indicating whether cells should show their leading apostrophe.

setUndoEnabled

Sets a value indicating whether saving action records for later undo is enabled.

startChangeOperation

Creates a Command object to track subsequent changes on the specified target. The returned command will be automatically executed when disposed.

startCompositeOperation

Starts recording undo/redo commands into a CompositeCommand.

undo

Undoes an action saved in the command history.

 Protected Methods

  Name Description

onActionRedone

Raises the WorkbookListener.actionRedone event.

onActionUndone

Raises the WorkbookListener.actionUndone event.

onDeserializeColumnTag

Raises the WorkbookListener.deserializeColumnTag event.

onDeserializeData

Raises the WorkbookListener.deserializeData event.

onDeserializeRowTag

Raises the WorkbookListener.deserializeRowTag event.

onDeserializeTag

Raises the WorkbookListener.deserializeTag event.

onPropertyValueChanged

Raises the PropertyChangeListener.propertyChange event.

onSerializeColumnTag

Raises the WorkbookListener.serializeColumnTag event.

onSerializeData

Raises the WorkbookListener.serializeData event.

onSerializeRowTag

Raises the WorkbookListener.serializeRowTag event.

onSerializeTag

Raises the WorkbookListener.serializeTag event.

onWorksheetCellChanged

Raises the WorkbookListener.worksheetCellChanged event.

onWorksheetCellChangedPostCalc

Raises the WorkbookListener.worksheetCellChangedPostCalc event.

onWorksheetCellChangedPreCalc

Raises the WorkbookListener.worksheetCellChangedPreCalc event.

onWorksheetCellChanging

Raises the WorkbookListener.worksheetCellChanging event.

onWorksheetCellParsing

 

onWorksheetCellsCleared

Raises the WorkbookListener.worksheetCellsCleared event.

onWorksheetCellStyleChanged

Raises the WorkbookListener.worksheetCellStyleChanged event.

onWorksheetCellStyleChanging

Raises the WorkbookListener.worksheetCellStyleChanging event.

onWorksheetChanged

Raises the WorkbookListener.worksheetChanged event.

onWorksheetColumnChanged

Raises the WorkbookListener.worksheetColumnChanged event.

onWorksheetRowChanged

Raises the WorkbookListener.worksheetRowChanged event.

onWorksheetValidationFailed

Raises the WorkbookListener.worksheetValidationFailed event.

 See Also