Handsontable example

by handsoncode

HTML

<script src="https://cdn.jsdelivr.net/npm/handsontable@13.1/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@13.1/dist/handsontable.full.min.css" /> 
<script src="https://handsontable.com/docs/scripts/fixer.js"></script>

<div id="example1" class="hot "></div>

Babel + JSX

import Handsontable from 'handsontable';
import HyperFormula from 'hyperformula';
import 'handsontable/dist/handsontable.full.min.css';

const container = document.querySelector('#example1');
const data = [
        {
          one: 1,
          two: 2,
          three: 'C',
          four: '=A1+B1',
        },
      ];
      
      
const columns = [
  	{
    data: 'one',
    }, {
    data: 'two',
    }, {
    data: 'three',
    }, {
    data: 'four'
    }
  ];

const hyperformulaInstance = HyperFormula.buildEmpty({
  licenseKey: 'internal-use-in-handsontable',
});

const hot = new Handsontable(container, {
  data,
  colHeaders: true,
  manualColumnMove: true,
  licenseKey: 'non-commercial-and-evaluation',
  formulas: {
    engine: hyperformulaInstance,
    sheetName: 'Sheet1',
  },
});

const movePlugin = hot.getPlugin("manualColumnMove");
movePlugin.moveColumn(2, 0);
hot.render();