Angular Data Grid Referencing a Handsontable instance in Angular

Reference a Handsontable instance from an Angular component to programmatically perform actions such as reloading the data in your data grid.

In this article

• Example

Example

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

/* file: app.component.ts */ import { Component } from '@angular/core'; import Handsontable from 'handsontable/base'; import { HotTableRegisterer } from '@handsontable/angular'; @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> `, }) export class AppComponent { private hotRegisterer = new HotTableRegisterer(); id = 'hotInstance'; hotSettings: Handsontable.GridSettings = { data: [ ['A1', 'B1', 'C1', 'D1'], ['A2', 'B2', 'C2', 'D2'], ['A3', 'B3', 'C3', 'D3'], ['A4', 'B4', 'C4', 'D4'], ], colHeaders: true, height: 'auto', autoWrapRow: true, autoWrapCol: true, licenseKey: 'non-commercial-and-evaluation' }; swapHotData() { this.hotRegisterer.getInstance(this.id).loadData([['new', 'data']]); } } /* file: 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 ] }) export class AppModule { } import { platformBrowserDynamic } from '@angular/platform-browser-dynamic'; platformBrowserDynamic() .bootstrapModule(AppModule) .catch(err => { console.error(err) }); <script src="https://cdn.jsdelivr.net/npm/handsontable@14.1/dist/handsontable.full.min.js"></script> <link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@14.1/dist/handsontable.full.min.css" /> <script src="https://handsontable.com/docs/14.1/scripts/fixer.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.11.4/dist/zone.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@angular/compiler@12/bundles/compiler.umd.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@angular/core@12/bundles/core.umd.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@angular/common@12/bundles/common.umd.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@angular/platform-browser@12/bundles/platform-browser.umd.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@angular/platform-browser-dynamic@12/bundles/platform-browser-dynamic.umd.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@handsontable/angular@14.1/bundles/handsontable-angular.umd.js"></script> <app-root></app-root>

/* file: app.component.ts */
import { Component } from '@angular/core';
import Handsontable from 'handsontable/base';
import { HotTableRegisterer } from '@handsontable/angular';

@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>
  `,
})
export class AppComponent {
  private hotRegisterer = new HotTableRegisterer();
  id = 'hotInstance';
  hotSettings: Handsontable.GridSettings = {
    data: [
      ['A1', 'B1', 'C1', 'D1'],
      ['A2', 'B2', 'C2', 'D2'],
      ['A3', 'B3', 'C3', 'D3'],
      ['A4', 'B4', 'C4', 'D4'],
    ],
    colHeaders: true,
    height: 'auto',
    autoWrapRow: true,
    autoWrapCol: true,
    licenseKey: 'non-commercial-and-evaluation'
  };

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

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

// register Handsontable's modules
registerAllModules();

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

<app-root></app-root>