Vue 2 Data Grid Referencing the Handsontable instance in Vue 2

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

In this article

• Example

Example

The following example implements the @handsontable/vue, showing how to reference the Handsontable instance from the wrapper component.

import { HotTable } from '@handsontable/vue'; import { registerAllModules } from 'handsontable/registry'; import 'handsontable/dist/handsontable.full.css'; // register Handsontable's modules registerAllModules(); const ExampleComponent = { data: function() { return { hotSettings: { 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' } } }, methods: { swapHotData: function() { // The Handsontable instance is stored under the `hotInstance` property of the wrapper component. this.$refs.hotTableComponent.hotInstance.loadData([['new', 'data']]); } }, components: { HotTable } } export default ExampleComponent; new Vue({ ...ExampleComponent, el: '#example1', }); <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://cdn.jsdelivr.net/npm/vue@2/dist/vue.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@handsontable/vue@14.1/dist/vue-handsontable.min.js"></script> <script src="https://handsontable.com/docs/14.1/scripts/fixer.js"></script> <div id="example1"> <hot-table ref="hotTableComponent" :settings="hotSettings"></hot-table><br/> <button v-on:click="swapHotData" class="controls">Load new data</button> </div>

import { HotTable } from '@handsontable/vue';
import { registerAllModules } from 'handsontable/registry';
import 'handsontable/dist/handsontable.full.css';

// register Handsontable's modules
registerAllModules();

const ExampleComponent = {
  data: function() {
    return {
      hotSettings: {
        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'
      }
    }
  },
  methods: {
    swapHotData: function() {
      // The Handsontable instance is stored under the `hotInstance` property of the wrapper component.
      this.$refs.hotTableComponent.hotInstance.loadData([['new', 'data']]);
    }
  },
  components: {
    HotTable
  }
}

export default ExampleComponent;

<div id="example1">
  <hot-table ref="hotTableComponent" :settings="hotSettings"></hot-table><br/>
  <button v-on:click="swapHotData" class="controls">Load new data</button>
</div>