Handsontable example

by Andrey Gershun

HTML

<h3>SQL for Handsontable with Alasql</h3>

<div id="example" class="handsontable"></div>

CSS

</style><!-- Ugly Hack due to jsFiddle issue: http://goo.gl/BUfGZ -->

<script src="https://code.jquery.com/jquery-1.11.1.min.js"></script>

<script src="http://handsontable.com/dist/handsontable.full.js"></script>
<script src="http://alasql.org/console/alasql.min.js"></script>
<link rel="stylesheet" media="screen" href="http://handsontable.com/dist/handsontable.full.css">
<link rel="stylesheet" media="screen" href="http://handsontable.com/demo/css/samples.css">
<link rel="stylesheet" media="screen" href="http://handsontable.com/demo/css/samples.css">
<link rel="stylesheet" media="screen" href="http://handsontable.com/demo/css/samples.css">

<style type="text/css">
body {background: white; margin: 20px;}
h2 {margin: 20px 0;}

JavaScript

$(document).ready(function () {

  var data = [
    ["2009", 0, 2941, 4303, 354, 5814],
    ["2010", 5, 2905, 2867, 412, 5284],
    ["2011", 4, 2517, 4822, 552, 6127],
    ["2012", 2, 2422, 5399, 776, 4151]
  ];
    
  var sortedData = alasql('SELECT MATRIX * FROM ? ORDER BY [5]',[data]);
  
  var container = document.getElementById('example');
  var hot = new Handsontable(container,
  {
    data: sortedData,
    colHeaders:     ["Year", "Maserati", "Mazda", "Mercedes", "Mini", "Mitsubishi"],
    contextMenu: true
  });
  
  
  
});