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;
or like this
(ExcelIO as any).LicenseKey = license;