Skip to content

Handsontable.js

Mathias Rangel Wulff edited this page Jun 13, 2015 · 2 revisions

SQL for Handsontable Grid

AlaSQL can be used as an SQL engine for Handsontable grid:

    var hot = new Handsontable(document.getElementById('example'), {
        data: alasql('SELECT MATRIX * FROM ? ORDER BY [5]',[data]),
        colHeaders:     ["Year", "Maserati", "Mazda", "Mercedes", "Mini", "Mitsubishi"],
    });

See the example in jsFiddle.

Clone this wiki locally