Options
All
  • Public
  • Public/Protected
  • All
Menu

OpenFin Excel Integration API Reference

Index

Type aliases

ExcelApplicationEventListener

ExcelApplicationEventListener: WorkbookCreatedEventListener

Application-level event listeners.

ExcelCalculationMode

ExcelCalculationMode: "Automatic" | "Manual" | "Semiautomatic"

Available Excel calculation modes which determine when a workbook or worksheet is calculated.

In Excel, these options can be viewed in the ribbon "Formulas" tab, "Calculation" group, "Calculation Options" menu. The SemiAutomatic value maps to the "Automatic Except for Data Tables" option.

ExcelWorkbookEventListener

Workbook-level event listeners.

ExcelWorksheetEventListener

Worksheet-level event listeners.

WorkbookActivatedEventListener

WorkbookActivatedEventListener: () => void

Type declaration

    • (): void
    • Function type for the event listener that is called when a workbook is activated.

      Returns void

WorkbookClosedEventListener

WorkbookClosedEventListener: () => void

Type declaration

    • (): void
    • Function type for the event listener that is called when a workbook is closed.

      Returns void

WorkbookCreatedEventListener

WorkbookCreatedEventListener: (workbook: ExcelWorkbook) => void

Type declaration

    • Function type for the event listener that is called when a workbook is created.

      Parameters

      Returns void

WorkbookDeactivatedEventListener

WorkbookDeactivatedEventListener: () => void

Type declaration

    • (): void
    • Function type for the event listener that is called when a workbook is deactivated.

      Returns void

WorksheetActivatedEventListener

WorksheetActivatedEventListener: () => void

Type declaration

    • (): void
    • Function type for the event listener that is called when a worksheet is activated.

      Returns void

WorksheetAddedEventListener

WorksheetAddedEventListener: (worksheet: ExcelWorksheet) => void

Type declaration

    • Function type for the event listener that is called when a worksheet is added.

      Parameters

      Returns void

WorksheetChangedEventListener

WorksheetChangedEventListener: (changedCells: Cell[]) => void

Type declaration

    • (changedCells: Cell[]): void
    • Function type for the event listener that is called when a worksheet is changed.

      Parameters

      • changedCells: Cell[]

      Returns void

WorksheetDeactivatedEventListener

WorksheetDeactivatedEventListener: () => void

Type declaration

    • (): void
    • Function type for the event listener that is called when a worksheet is deactivated.

      Returns void

WorksheetDeletedEventListener

WorksheetDeletedEventListener: (worksheet: ExcelWorksheet) => void

Type declaration

    • Function type for the event listener that is called when a worksheet is deleted.

      Parameters

      Returns void

Functions

Const disableLogging

  • disableLogging(): void
  • Disables module logging if it has been enabled by a call to enableLogging.

    Returns void

Const enableLogging

  • enableLogging(): void
  • Enables module logging to the console for debugging/troubleshooting purposes. This is off by default.

    Returns void

Const getExcelApplication

  • The entry point for using the Excel integration client-side API.

    When calling this function for the first time, it initializes a native adapter process for sole use by your application and connects to it via a channel. The adapter process exists as long as your application is running and connected, after which the adapter terminates automatically. Subsequent calls always reuse the connected adapter.

    Note: If your application's manifest does not have the appAssets and permissions objects properly configured the function will throw an error.

    throws

    InitializationError if unable to launch the native adapter process or some other error occurred during initialization.

    Returns Promise<ExcelApplication>

    An application object that enables control of Excel.

Generated using TypeDoc