GrapeCity Knowledge Base

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;