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();