Skip to content

Latest commit

 

History

History

integration-excel

Integrate with Microsoft Excel

This repository demonstrates how to use OpenFin’s Excel integration in order to interact with the Microsoft Excel native client application. The Excel integration API is an ES module provided via the @openfin/excel NPM package.

For further information about the Excel integration, refer to the developer documentation.

How it Works

The excel.ts looks for a running version of Excel and will let you select an active workbook and worksheet. Then the application will monitor changes to the cells in Excel and display all of them. If at any point the application sees one of the known instruments it will broadcast it as an FDC3 instrument.

The secondary fdc3monitor.ts will monitor for the FDC3 instrument messages.

Get Started

Follow the instructions below to get up and running.

Set up the project

  1. Install dependencies. Note that these examples assume you are in the sub-directory for the example.
npm install
  1. Build the project.
npm run build
  1. Start the test server in a new window.
npm run start
  1. Start the Platform application.
npm run client

What you will see

A window that contains two views, the Excel integration and the FDC monitor.

Excel Integration

View in panel

An additional version of the view which is shown in a panel on the right of your screen, and is launched from a tray icon.

npm run secondclient

Excel Integration Panel

A note about this example

This is an example of how to use OpenFin APIs to configure OpenFin Container. Its purpose is to provide an example and suggestions. DO NOT assume that it contains production-ready code. Please use this as a guide and provide feedback. Thanks!