Vue 2 Data Grid Vuex example in Vue 2

Use the Vuex state management pattern to maintain the data and configuration options of your Vue 2 data grid.

In this article

• Example - Vuex store dump

Example - Vuex store dump

The following example implements the @handsontable/vue component with a readOnly toggle switch and the Vuex state manager.

Toggle readOnly for the entire table.

import Vue from 'vue'; import Vuex from 'vuex'; import { HotTable } from '@handsontable/vue'; import { registerAllModules } from 'handsontable/registry'; import 'handsontable/dist/handsontable.full.css'; Vue.use(Vuex); // register Handsontable's modules registerAllModules(); const ExampleComponent = { data() { return { hotSettings: { data: [ ['A1', 'B1', 'C1', 'D1'], ['A2', 'B2', 'C2', 'D2'], ['A3', 'B3', 'C3', 'D3'], ['A4', 'B4', 'C4', 'D4'], ], colHeaders: true, rowHeaders: true, readOnly: true, height: 'auto', afterChange: () => { if (this.hotRef) { this.$store.commit('updateData', this.hotRef.getSourceData()); } }, licenseKey: 'non-commercial-and-evaluation' }, hotRef: null }; }, mounted() { this.hotRef = this.$refs.wrapper.hotInstance; this.$store.subscribe(() => this.updateVuexPreview()); this.$store.commit('updateData', this.hotRef.getSourceData()); }, methods: { toggleReadOnly(event) { this.hotSettings.readOnly = event.target.checked; this.$store.commit('updateSettings', {prop: 'readOnly', value: this.hotSettings.readOnly}); }, updateVuexPreview() { // This method serves only as a renderer for the Vuex's state dump. const previewTable = document.querySelector('#vuex-preview table'); let newInnerHtml = '<tbody>'; for (const [key, value] of Object.entries(this.$store.state)) { newInnerHtml += `<tr><td class="table-container">`; if (key === 'hotData' && Array.isArray(value)) { newInnerHtml += `<strong>hotData:</strong> <br><table><tbody>`; for (let row of value) { newInnerHtml += `<tr>`; for (let cell of row) { newInnerHtml += `<td>${cell}</td>`; } newInnerHtml += `</tr>`; } newInnerHtml += `</tbody></table>`; } else if (key === 'hotSettings') { newInnerHtml += `<strong>hotSettings:</strong> <ul>`; for (let settingsKey of Object.keys(value)) { newInnerHtml += `<li>${settingsKey}: ${this.$store.state.hotSettings[settingsKey]}</li>`; } newInnerHtml += `</ul>`; } newInnerHtml += `</td></tr>`; } newInnerHtml += `</tbody>`; previewTable.innerHTML = newInnerHtml; } }, components: { HotTable }, store: new Vuex.Store({ state: { hotData: null, hotSettings: { readOnly: false } }, mutations: { updateData(state, hotData) { state.hotData = hotData; }, updateSettings(state, updateObj) { state.hotSettings[updateObj.prop] = updateObj.value; } } }) } export default ExampleComponent; new Vue({ ...ExampleComponent, el: '#example1', }); <script src="https://cdn.jsdelivr.net/npm/handsontable@13.0/dist/handsontable.full.min.js"></script> <link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@13.0/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/vuex@3/dist/vuex.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/@handsontable/vue@13.0/dist/vue-handsontable.min.js"></script> <script src="https://handsontable.com/docs/13.0/scripts/fixer.js"></script> <div id="example1" class="dump-example-container"> <div id="example-preview"> <div id="toggle-boxes"> <br/> <input v-on:click="toggleReadOnly" checked id="readOnlyCheck" type="checkbox"/> <label for="readOnlyCheck"> Toggle <code>readOnly</code> for the entire table</label> </div> <br/> <hot-table ref="wrapper" :settings="hotSettings"></hot-table> </div> <div id="vuex-preview"> <h4>Vuex store dump:</h4> <table></table> </div> </div>

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

Vue.use(Vuex);

// register Handsontable's modules
registerAllModules();

const ExampleComponent = {
  data() {
    return {
      hotSettings: {
        data: [
          ['A1', 'B1', 'C1', 'D1'],
          ['A2', 'B2', 'C2', 'D2'],
          ['A3', 'B3', 'C3', 'D3'],
          ['A4', 'B4', 'C4', 'D4'],
        ],
        colHeaders: true,
        rowHeaders: true,
        readOnly: true,
        height: 'auto',
        afterChange: () => {
          if (this.hotRef) {
            this.$store.commit('updateData', this.hotRef.getSourceData());
          }
        },
        licenseKey: 'non-commercial-and-evaluation'
      },
      hotRef: null
    };
  },
  mounted() {
    this.hotRef = this.$refs.wrapper.hotInstance;
    this.$store.subscribe(() => this.updateVuexPreview());
    this.$store.commit('updateData', this.hotRef.getSourceData());
  },
  methods: {
    toggleReadOnly(event) {
      this.hotSettings.readOnly = event.target.checked;
      this.$store.commit('updateSettings', {prop: 'readOnly', value: this.hotSettings.readOnly});
    },
    updateVuexPreview() {
      // This method serves only as a renderer for the Vuex's state dump.

      const previewTable = document.querySelector('#vuex-preview table');
      let newInnerHtml = '<tbody>';

      for (const [key, value] of Object.entries(this.$store.state)) {
        newInnerHtml += `<tr><td class="table-container">`;

        if (key === 'hotData' && Array.isArray(value)) {
          newInnerHtml += `<strong>hotData:</strong> <br><table><tbody>`;

          for (let row of value) {
            newInnerHtml += `<tr>`;

            for (let cell of row) {
              newInnerHtml += `<td>${cell}</td>`;
            }

            newInnerHtml += `</tr>`;
          }
          newInnerHtml += `</tbody></table>`;

        } else if (key === 'hotSettings') {
          newInnerHtml += `<strong>hotSettings:</strong> <ul>`;

          for (let settingsKey of Object.keys(value)) {
            newInnerHtml += `<li>${settingsKey}: ${this.$store.state.hotSettings[settingsKey]}</li>`;
          }

          newInnerHtml += `</ul>`;
        }

        newInnerHtml += `</td></tr>`;
      }
      newInnerHtml += `</tbody>`;

      previewTable.innerHTML = newInnerHtml;
    }
  },
  components: {
    HotTable
  },
  store: new Vuex.Store({
    state: {
      hotData: null,
      hotSettings: {
        readOnly: false
      }
    },
    mutations: {
      updateData(state, hotData) {
        state.hotData = hotData;
      },
      updateSettings(state, updateObj) {
        state.hotSettings[updateObj.prop] = updateObj.value;
      }
    }
  })
}

export default ExampleComponent;

<div id="example1" class="dump-example-container">
  <div id="example-preview">
    <div id="toggle-boxes">
      <br/>
      <input v-on:click="toggleReadOnly" checked id="readOnlyCheck" type="checkbox"/>
      <label for="readOnlyCheck"> Toggle <code>readOnly</code> for the entire table</label>
    </div>
    <br/>
    <hot-table ref="wrapper" :settings="hotSettings"></hot-table>
  </div>
  <div id="vuex-preview">
    <h4>Vuex store dump:</h4>
    <table></table>
  </div>
</div>