ExcelWorkbook | OpenFin Excel Integration API Reference

An object that represents an open workbook in Excel.

Hierarchy

ExcelWorkbook

Index

Methods

activate

activate(): Promise<void>

Activates the first window associated with the workbook, bringing it in to focus.

Note: activating a workbook deactivates the currently activated workbook.

Returns Promise<void>

addEventListener

addEventListener(eventName: string, listener: ExcelWorkbookEventListener): Promise<void>
addEventListener(eventName: "activate", listener: WorkbookActivatedEventListener): Promise<void>
addEventListener(eventName: "addWorksheet", listener: WorksheetAddedEventListener): Promise<void>
addEventListener(eventName: "close", listener: WorkbookClosedEventListener): Promise<void>
addEventListener(eventName: "deactivate", listener: WorkbookDeactivatedEventListener): Promise<void>
addEventListener(eventName: "deleteWorksheet", listener: WorksheetDeletedEventListener): Promise<void>

Adds a listener for the specified workbook-level event.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

throws
EventError if specified event is not supported.

Parameters
- eventName: string
  
  Type of the workbook-level event to listen for.
- listener: ExcelWorkbookEventListener
  
  Function called when the specified event occurs.
Returns Promise<void>
Adds a listener that is called when the workbook is activated.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Parameters
- eventName: "activate"
  
  Name of the event fired when the workbook is activated.
- listener: WorkbookActivatedEventListener
  
  Listener function called when the event occurs.
Returns Promise<void>
Adds a listener that is called when a worksheet is added to the workbook.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Parameters
- eventName: "addWorksheet"
  
  Name of the event fired when a worksheet is added to the workbook.
- listener: WorksheetAddedEventListener
  
  Listener function called when the event occurs.
Returns Promise<void>
Adds a listener that is called when the workbook is closed.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Parameters
- eventName: "close"
  
  Name of the event fired when the workbook is closed.
- listener: WorkbookClosedEventListener
  
  Listener function called when the event occurs.
Returns Promise<void>
Adds a listener that is called when the workbook is deactivated (i.e. another workbook is activated).

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Parameters
- eventName: "deactivate"
  
  Name of the event fired when the workbook is deactivated.
- listener: WorkbookDeactivatedEventListener
  
  Listener function called when the event occurs.
Returns Promise<void>
Adds a listener that is called when a worksheet is deleted from the workbook.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Parameters
- eventName: "deleteWorksheet"
  
  Name of the event fired when a worksheet is deleted from the workbook.
- listener: WorksheetDeletedEventListener
  
  Listener function called when the event occurs.
Returns Promise<void>

addWorksheet

addWorksheet(): Promise<ExcelWorksheet>

Adds a new worksheet to the workbook.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Returns Promise<ExcelWorksheet>
The worksheet that was created.

calculate

calculate(): Promise<void>

Triggers calculation for the entire workbook.

Note: Only necessary when automatic calculation is turned off.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Returns Promise<void>

close

close(): Promise<void>

Closes the workbook.

If the workbook has any unsaved changes, Excel displays a "Save" prompt before closing the workbook.

Note: After calling this function, do not attempt to use this workbook or any child worksheet objects. Doing so will likely result in an AdapterError since the underlying object/file is no longer available.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Returns Promise<void>

getCalculationMode

getCalculationMode(): Promise<ExcelCalculationMode>

Get the current calculation mode which determines when the workbook is re-calculated.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Returns Promise<ExcelCalculationMode>
The name of the current calculation mode.

getName

getName(): Promise<string>

Gets the name of the workbook.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Returns Promise<string>
The workbook name.

getWorksheetByName

getWorksheetByName(worksheetName: string): Promise<null | ExcelWorksheet>

Gets a worksheet with a given name.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Parameters
- worksheetName: string
  
  The name of the worksheet to get.
Returns Promise<null | ExcelWorksheet>
The worksheet matching the provided name, or null if no matching worksheet was found.

getWorksheets

getWorksheets(): Promise<ExcelWorksheet[]>

Gets all worksheets belonging to the workbook.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Returns Promise<ExcelWorksheet[]>
All worksheets belonging to the workbook.

removeEventListener

removeEventListener(listener: ExcelWorkbookEventListener): Promise<void>

Removes a previously added listener for the specified workbook-level event.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

throws
EventError if provided listener function does not match any added event listener.

Parameters
- listener: ExcelWorkbookEventListener
  
  Function that was provided as the listener when addEventListener was called.
Returns Promise<void>

save

save(): Promise<string>

Saves the workbook to disk.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Returns Promise<string>
The full path the workbook was saved to.

saveAs

saveAs(filePath: string): Promise<string>

Saves the workbook to the file path provided.

throws
AdapterError if an exception is thrown by the adapter process, typically by the Excel PIA.

Parameters
- filePath: string
  
  Full path (including file name) where the workbook should be saved.
Returns Promise<string>
The full path the workbook was saved to.

Hierarchy

Index

Methods

Methods

activate

Returns Promise<void>

addEventListener

Parameters

eventName: string

listener: ExcelWorkbookEventListener

Returns Promise<void>

Parameters

eventName: "activate"

listener: WorkbookActivatedEventListener

Returns Promise<void>

Parameters

eventName: "addWorksheet"

listener: WorksheetAddedEventListener

Returns Promise<void>

Parameters

eventName: "close"

listener: WorkbookClosedEventListener

Returns Promise<void>

Parameters

eventName: "deactivate"

listener: WorkbookDeactivatedEventListener

Returns Promise<void>

Parameters

eventName: "deleteWorksheet"

listener: WorksheetDeletedEventListener

Returns Promise<void>

addWorksheet

Returns Promise<ExcelWorksheet>

calculate

Returns Promise<void>

close

Returns Promise<void>

getCalculationMode

Returns Promise<ExcelCalculationMode>

getName

Returns Promise<string>

getWorksheetByName

Parameters

worksheetName: string

Returns Promise<null | ExcelWorksheet>

getWorksheets

Returns Promise<ExcelWorksheet[]>

removeEventListener

Parameters

listener: ExcelWorkbookEventListener

Returns Promise<void>

save

Returns Promise<string>

saveAs

Parameters

filePath: string

Returns Promise<string>