Handsontable example

by handsoncode

HTML

<div>
  <div id="example1" class="hot handsontable htRowHeaders htColumnHeaders"></div>
</div>

CSS

</style><script src="https://cdn.jsdelivr.net/npm/handsontable-pro@6.0.0/dist/handsontable.full.min.js"></script><link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable-pro@6.0.0/dist/handsontable.full.min.css">

JavaScript

var data = [
    ['=SUM(A2:A4)', "Maserati", "Mazda", "Mercedes", "Mini", "=A$1"],
    [2009, 0, 2941, 4303, 354, 5814],
    [2010, 5, 2905, 2867, '=SUM(A4,2,3)', '=$B1'],
    [2011, 4, 2517, 4822, 552, 6127],
    [2012, '=SUM(A2:A5)', '=SUM(B5,E3)', '=A2/B2', 12, 4151]
  ];
  var example1 = document.getElementById('example1');

  var hot1 = new Handsontable(example1, {
    data: data,
    colHeaders: true,
    dropdownMenu: true,
    formulas: true,
    filters: true,
    rowHeaders: true,
    contextMenu: true,
    columns: [{}]
  });