Handsontable example
HTML
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/handsontable.full.min.css" />
<div id="example1" class="hot "></div>
JavaScript
const container = document.querySelector('#example1');
const hot = new Handsontable(container, {
data: [
['Lorem', 'ipsum', 'dolor', 'sit', '12/1/2015', 23],
['adipiscing', 'elit', 'Ut', 'imperdiet', '5/12/2015', 6],
['Pellentesque', 'vulputate', 'leo', 'semper', '10/23/2015', 26],
['diam', 'et', 'malesuada', 'libero', '12/1/2014', 98],
['orci', 'et', 'dignissim', 'hendrerit', '12/1/2016', 8.5]
],
columns: [
{ type: 'text' },
{ type: 'text' },
{ type: 'text' },
{ type: 'text' },
{ type: 'date', dateFormat: 'M/D/YYYY' },
{ type: 'numeric' }
],
colHeaders: true,
rowHeaders: true,
dropdownMenu: true,
contextMenu: true,
comments: true,
cell: [
{ row: 0, col: 1, comment: { value: 'A read-only comment.', readOnly: true } },
{ row: 1, col: 3, comment: { value: 'You can edit this comment' } }
],
filters: true,
height: 'auto',
licenseKey: 'non-commercial-and-evaluation'
});