JavaScript Data Grid Referencing the Handsontable instance in Angular

Table of contents

• Overview
• Example

Overview

The following example is an implementation of @handsontable/angular, which shows you how to reference the Handsontable instance from the wrapper component.

Example

// app.component.ts import { Component } from '@angular/core'; import Handsontable from 'handsontable/base'; import { HotTableRegisterer } from '@handsontable/angular'; import { createSpreadsheetData } from './helpers'; @Component({ selector: 'app-root', template: ` <div> <hot-table [hotId]="id" [settings]="hotSettings"></hot-table> </div> <br> <button (click)="swapHotData()" class="controls">Load new data</button> `, }) class AppComponent { private hotRegisterer = new HotTableRegisterer(); id = 'hotInstance'; hotSettings: Handsontable.GridSettings = { data: createSpreadsheetData(4, 4), colHeaders: true, height: 'auto', licenseKey: 'non-commercial-and-evaluation' }; swapHotData() { this.hotRegisterer.getInstance(this.id).loadData([['new', 'data']]); } } // app.module.ts import { NgModule } from '@angular/core'; import { BrowserModule } from '@angular/platform-browser'; import { HotTableModule } from '@handsontable/angular'; import { registerAllModules } from 'handsontable/registry'; // register Handsontable's modules registerAllModules(); @NgModule({ imports: [ BrowserModule, HotTableModule.forRoot() ], declarations: [ AppComponent ], bootstrap: [ AppComponent ] }) class AppModule { } // bootstrap import { platformBrowserDynamic } from '@angular/platform-browser-dynamic'; platformBrowserDynamic().bootstrapModule(AppModule).catch(err => { console.error(err) }); <script src="https://cdn.jsdelivr.net/npm/handsontable@12.1/dist/handsontable.full.min.js"></script> <link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@12.1/dist/handsontable.full.min.css" /> <script src="https://handsontable.com/docs/12.1/scripts/fixer.js"></script> <script src="https://handsontable.com/docs/12.1/scripts/helpers.js"></script> <script src="https://cdn.jsdelivr.net/npm/rxjs@6/bundles/rxjs.umd.js"></script> <script src="https://cdn.jsdelivr.net/npm/core-js@2/client/core.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/zone.js@0.9/dist/zone.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@angular/compiler@8/bundles/compiler.umd.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@angular/core@8/bundles/core.umd.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@angular/common@8/bundles/common.umd.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@angular/platform-browser@8/bundles/platform-browser.umd.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@angular/platform-browser-dynamic@8/bundles/platform-browser-dynamic.umd.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@handsontable/angular@12.1/bundles/handsontable-angular.umd.min.js"></script> <app-root></app-root>

// app.component.ts
import { Component } from '@angular/core';
import Handsontable from 'handsontable/base';
import { HotTableRegisterer } from '@handsontable/angular';
import { createSpreadsheetData } from './helpers';

@Component({
  selector: 'app-root',
  template: `
  <div>
    <hot-table [hotId]="id" [settings]="hotSettings"></hot-table>
  </div>
  <br>
  <button (click)="swapHotData()" class="controls">Load new data</button>
  `,
})
class AppComponent {
  private hotRegisterer = new HotTableRegisterer();
  id = 'hotInstance';
  hotSettings: Handsontable.GridSettings = {
    data: createSpreadsheetData(4, 4),
    colHeaders: true,
    height: 'auto',
    licenseKey: 'non-commercial-and-evaluation'
  };

  swapHotData() {
    this.hotRegisterer.getInstance(this.id).loadData([['new', 'data']]);
  }
}

// app.module.ts
import { NgModule } from '@angular/core';
import { BrowserModule } from '@angular/platform-browser';
import { HotTableModule } from '@handsontable/angular';
import { registerAllModules } from 'handsontable/registry';

// register Handsontable's modules
registerAllModules();

@NgModule({
  imports:      [ BrowserModule, HotTableModule.forRoot() ],
  declarations: [ AppComponent ],
  bootstrap:    [ AppComponent ]
})
class AppModule { }

// bootstrap
import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';

platformBrowserDynamic().bootstrapModule(AppModule).catch(err => { console.error(err) });

<app-root></app-root>