Handsontable example

by handsoncode

HTML

<div id="example1" class="hot handsontable htColumnHeaders"></div>

CSS

</style>< !-- Ugly Hack due to jsFiddle issue --><script src="https://docs.handsontable.com/pro/1.18.1/bower_components/handsontable-pro/dist/handsontable.full.min.js"></script><link type="text/css" rel="stylesheet" href="https://docs.handsontable.com/pro/1.18.1/bower_components/handsontable-pro/dist/handsontable.full.min.css"><script src="https://docs.handsontable.com/pro/1.18.1/bower_components/numbro/dist/languages.min.js"></script>

JavaScript

var
  container = document.getElementById('example1'),
  hot = new Handsontable(container, {
    data: Handsontable.helper.createSpreadsheetData(10, 10),
    height: 396,
    stretchH: 'all',
    columnSorting: true,
    contextMenu: true,
    className: 'htCenter htMiddle',
    readOnly: false,
    rowHeaders: true,
    //manualRowMove: true,
    manualColumnMove: true,
    hiddenColumns: {
      columns: [3, 5, 9],
      indicators: true
    },
		afterRender: function(){
			console.log(Handsontable.version)
		}
  });