Glue4Office

The Glue42 MS Office Connectors allow you to:

Use Excel with its familiar functionality, such as macros and pivot tables, to create sophisticated calculations, or continue using those that may have accumulated over the years, while being able to save all data edits to your web app in real time.

Edit and format a document in Word, including WordArt, tables and drawings, making use of the familiar and powerful capabilities of the most popular text processing tool in the world.

Send and receive emails and manage tasks from web applications using all the familiar capabilities of Outlook.

Referencing

The glue4office library is available both as an npm module and as a standalone transpiled JavaScript file in %LocalAppData%\Tick42\GlueSDK\Glue4OfficeJS\js\web.

Because the API evolves, we have chosen the following semantic version model:

BreakingChangesVersion.FeatureVersion.FixVersion

You can reference the library in a <script> tag:

<script type="text/javascript" src="glue4office-1.6.5.js"></script>

When deploying your application in production, we recommend that you always reference a specific minified version:

<script type="text/javascript" src="glue4office-1.6.5.min.js"></script>

The browserified JavaScript file is also a CommonJS module, which you can require/import.

CommonJS:

const Glue4Office = require("glue4office");

ES6:

import Glue4Office from "glue4office";

Initialization

When you reference the standalone JavaScript file, it will expose a global factory function called Glue4Office.

If you have imported or required the library, the function will be available with the name you specified in the import or require statement.

Assuming you stick to the default Glue4Office name, to initialize the library, you need to call the function Glue4Office and specify which MS Office apps you want to interoperate with. The function returns a Promise, which will resolve with an initialized instance of the library.

Example:

const g4oConfig = {
  application: "MS Office Interop",
  excel: true, // enable Excel interop
  word: true, // enable Word interop
  outlook: false // disable Outlook interop
};
Glue4Office(g4oConfig)
  .then(g4o => {
    // g4o is a reference to the Glue4Office API
    window.g4o = g4o; // expose g4o as a global variable
    // use g4o
  })
  .catch(console.error);

See also the Connectors documentation for more details.

Methods