Handsontable example

by TonyNguyen001

HTML

<div id="example1"></div>

CSS

</style><!-- Ugly Hack due to jsFiddle issue -->

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

JavaScript

var example = document.getElementById('example1');
  var hot = new Handsontable(example, {
    data: [
      [1, '10/02'],
      [2, '10/02/2020'],
      [8, '10/02/2020'],
      ['text', '10/02/2020'],
      [11, '10/02/2020'],
      [8, 5]
    ],
    columns: [{
      type: 'text',
      allowEmpty: false
    }, {
      type: 'date'
    }],
    colWidths: 150,
    // X collumn need not null, at least 5 character and folowing format: ABC_XXX
    colHeaders: ['X', 'Y'],
    afterValidate: function(isValid, value, row){
    
    }
  });

hot.validateColumns([0])