How to set the ExcelIO LicenseKey in Angular

Can't find what you're looking for?

Author:

Mackenzie Albitz

Updated:

25 March 2020, 7:14 am

Product:

SpreadJS

Technology:

HTML/JavaScript, Angular

Background:

When working in Angular and using the ExcelIO namespace, if when importing or exporting an xlsx file there is an additional Evaluation Sheet that is being generated, this is because the ExcelIO namespace must be set separately from the SpreadSheets namespace. Both will be set with the same distribution key.

Steps to Complete:

1. Import both namespaces

2. Set the LicenseKey for both namespaces

Note: For SpreadJS v12.2.0 or later users

Getting Started:

Import namespaces

import * as GC from "@grapecity/spread-sheets";
import * as ExcelIO from "@grapecity/spread-excelio";

Set LicenseKey properties for the namespace

const license = "MyLicense";
GC.Spread.Sheets.LicenseKey = license;
ExcelIO.LicenseKey = license;

Note: For SpreadJS v12.2.0 or later users

You will see an error saying: Property ‘LicenseKey’ does not exist on type 'typeOf’ Excel.

This is due to a current typescript definition

To fix this, change the ExcelIO type to ‘any’ like below:

(ExcelIO).LicenseKey = license;