Excel IO Element

Using the Excel IO element in SpreadJS with Angular, you can quickly render and display the Excel sheets on the webpages while also executing the import and export operations without any hassle.

Install the Angular CLI globally
Open the Command Prompt window and type the following command:
```
npm install -g @angular/cli
```
Create a new project using Angular CLI
Create a new project using the following command and navigate to the project directory:
```
ng new spread-sheets-angular-cli
cd spread-sheets-angular-cli
```
Install SpreadJS NPM package
Install the SpreadJS Npm package using the following commands:
```
npm install @grapecity/spread-sheets
npm install @grapecity/spread-sheets-angular
```
Install Excel IO Angular Module and FileSaver Angular Module in the Project
Install the Excel I/O and file-saver modules in your project using the following commands:
```
npm install @grapecity/spread-excelio
npm install file-saver --save
```

Configure SpreadJS CSS

Configure the SpreadJS CSS in angular.json as shown below:

{
  ...
  "projects":{
    "spread-sheets-angular-cli":{
      ...
      "architect":{
        ...
        "build":{
          ...
          options:{
            ...
            "styles": [
              "node_modules/@grapecity/spread-sheets/styles/gc.spread.sheets.excel2016darkGray.css"
            ],
            ...
          }
          ...
        }
        ...
      }
      ...
    }
  }
  ...
}

Use Excel IO in an Angular application

Modify the app.module.ts for importing the SpreadJS module as shown below:

import { BrowserModule } from '@angular/platform-browser';
import { NgModule } from '@angular/core';
import { AppComponent } from './app.component';
import { SpreadSheetsModule } from "@grapecity/spread-sheets-angular";
@NgModule({
    declarations: [AppComponent],
    imports: [BrowserModule,SpreadSheetsModule],
    providers: [],
    bootstrap: [AppComponent]
})
export class AppModule { }

Modify the app.component.html for viewing the SpreadJS component as shown below:

<div class='maincontainer'>
  <gc-spread-sheets [hostStyle]="hostStyle" (workbookInitialized)="workbookInit($event)">
  </gc-spread-sheets>
  <div class='loadExcelInput'>
    <p>Open Excel File</p>
    <input type="file" name="files[]" multiple id="jsonFile" accept=".xlsx" (change)="onFileChange($event)" />
  </div>
  <div class='exportExcel'>
    <p>Save Excel File</p>
    <button (click)="onClickMe($event)">Save Excel!</button>
  </div>
</div>

Modify the app.component.ts for using Excel IO element and preparing data for SpreadJS component as shown below:

import { Component, ViewChild } from '@angular/core';
import * as GC from '@grapecity/spread-sheets';
import * as Excel from '@grapecity/spread-excelio';
import { saveAs } from 'file-saver';
// LICENSE INFORMATION
var SpreadJSKey = "xxxx";
GC.Spread.Sheets.LicenseKey = SpreadJSKey;
// NEED TO SET SpreadJS Key to EXCELIO also
(<any>Excel).LicenseKey = SpreadJSKey;
@Component({
  selector: 'app-root',
  templateUrl: './app.component.html',
  styleUrls: ['./app.component.css']
})
export class AppComponent {
  spreadBackColor = 'aliceblue';
  hostStyle = {
    width: '95vw',
    height: '80vh'
  };
  private spread!: GC.Spread.Sheets.Workbook;;
  private excelIO;
  constructor() {
    this.excelIO = new Excel.IO();
  }
  workbookInit(args: { spread: GC.Spread.Sheets.Workbook; }) {
    const self = this;
    self.spread = args.spread;
    const sheet = self.spread.getActiveSheet();
    sheet.getCell(0, 0).text('Test ExcelIO').foreColor('blue');
  }
  onFileChange(args: any) {
    const self = this, file = args.srcElement && args.srcElement.files && args.srcElement.files[0];
    if (self.spread && file) {
      self.excelIO.open(file, (json: Object) => {
        self.spread.fromJSON(json, {});
        setTimeout(() => {
          alert('Excel loaded successfully');
        }, 0);
      }, (error: any) => {
        alert('load fail');
      });
    }
  }
  onClickMe(args: any) {
    const self = this;
    const filename = 'ExportedExcel.xlsx';
    const json = JSON.stringify(self.spread.toJSON());
    self.excelIO.save(json, function (blob: any) {
      saveAs(blob, filename);
    }, function (e: any) {
      console.log(e);
    });
  }
}

Build and run the project
Build and run the new project using the following command:
```
ng serve
```