Handsontable example

HTML

<script src="https://cdn.jsdelivr.net/npm/handsontable@9.0.2/dist/handsontable.full.min.js"></script>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@9.0.2/dist/handsontable.full.min.css">
<div class="example"></div>

JavaScript

document.addEventListener("DOMContentLoaded", function() {

  var container = document.querySelector('.example'),
    hot;

  hot = new Handsontable(container, {
    data: Handsontable.helper.createSpreadsheetData(10, 10),
    filters: true,
    height: 400,
    dropdownMenu: true,
    colHeaders: true,
    beforeFilter: function(conditionsStack) {
      console.log('amount of filters: ' + conditionsStack.length);
      console.log('Last changed column index: ' + conditionsStack[0].column);
      console.log('amount of filters added to this column: ' + conditionsStack[0].conditions.length);
      //list of conditions
      console.log(conditionsStack[0].conditions);
      
      console.log(this.rowIndexMapper);
    }
  });



});