Handsontable Basic Example (100x10)

HTML

<script src="https://handsontable.com/bower_components/handsontable/dist/handsontable.full.js"></script>
<link rel="stylesheet" href="https://handsontable.com/bower_components/handsontable/dist/handsontable.full.css">
<h2>Handsontable Basic Example (100x10)</h2>
<p>
Head to <a href="https://handsontable.com" target="_blank">handsontable.com</a> to learn more about Handsontable.
</p>

<div id="example"></div>

CSS

body {
  margin: 20px 30px;
  font-size: 13px;
  font-family: 'Open Sans', Helvetica, Arial;
}

a {
  color: #34A9DC;
  text-decoration: none;
}

p {
  margin: 5px 0 20px;
}

h2 {
  margin: 20px 0 0;
  font-size: 18px;
  font-weight: normal;
}

JavaScript

var container = document.getElementById('example');

var hot = new Handsontable(container, {
 licenseKey: "non-commercial-and-evaluation",
  data: [["=100", "100"], ["=100", "100"], ["",""]],
  formulas: {
    engine: HyperFormula.buildEmpty({licenseKey: "non-commercial-and-evaluation"}),
    sheetName: 'Sheet1'
  },
  rowHeaders: true,
  colHeaders: true,
  columnSummary: [
    {
      destinationRow: 2,
      destinationColumn: 0,
      forceNumeric: true,
      type: 'sum'
    },
    {
      destinationRow: 2,
      destinationColumn: 1,
      forceNumeric: true,
      type: 'sum'
    }
  ]
});
console.log(Handsontable.version);