Handsontable example

HTML

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

<div id="example-data-grid" class="hot "></div>

JavaScript

const data = [
	['Fruit', 'Amount'],
  ['Oranges', '50'],
  ['Apples', '20'],
  ['', ''],
  ['Apples', '=VLOOKUP(A5, A1:B3, 2)'],
  ['Apples', '=VLOOKUP(A5, A1:B3, 2, FALSE)'],
  ['Apples', '=VLOOKUP(A5, A1:B3, 2, false)'],
  ['Apples', '=VLOOKUP(A5, A1:B3, 2, "false")'],
];

const container = document.getElementById('example-data-grid');
new Handsontable(container, {
  data: data,
  formulas: {
    engine: HyperFormula,
  },
  colHeaders: true,
  fixedRowsBottom: 2,
  stretchH: 'all',
  height: 500,
  licenseKey: 'non-commercial-and-evaluation'
});