Skip to content

Handsontable.js

Jump to bottom
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.

© 2014-2024, Andrey Gershun & Mathias Rangel Wulff

Please help improve the documentation by opening a PR on the wiki repo

Quick links

Clone this wiki locally