jacksontable
    TypeScript icon, indicating that this package has built-in type declarations

    6.2.2 • Public • Published
    JACKSONTABLE

    Jacksontable is an open source JavaScript/HTML5 data grid component with spreadsheet look & feel. It is forked from HandsonTable community edition 6.2.2 right before it was closed-sourced at version 7. It easily integrates with any data source and comes with a variety of useful features like data binding, validation, sorting or powerful context menu. It is available for Vue, React, Angular and Polymer.

    If you are looking for an extended version, try out Handsontable Pro.

    Build status npm npm npm


    Table of contents

    1. What to use it for?
    2. Installation
    3. Basic usage
    4. Examples
    5. Features
    6. Screenshot
    7. Resources
    8. Wrappers
    9. Support
    10. Contributing
    11. Community
    12. License

    What to use it for?

    The list below gives a rough idea on what you can do with Jacksontable, but it shouldn't limit you in any way:

    • Database editing
    • Configuration controlling
    • Data merging
    • Team scheduling
    • Sales reporting
    • Financial analysis

    Installation

    There are many ways to install Jacksontable, but we suggest using npm:

    npm install jacksontable
    

    Alternative ways to install

    • See the releases page for downloadable zips

    Basic usage

    Assuming that you have already installed Jacksontable, create an empty <div> element that will be turned into a spreadsheet:

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

    In the next step, pass a reference to that <div> element into the Jacksontable constructor and fill the instance with sample data:

    var data = [
      ["", "Tesla", "Volvo", "Toyota", "Honda"],
      ["2017", 10, 11, 12, 13],
      ["2018", 20, 11, 14, 13],
      ["2019", 30, 15, 12, 13]
    ];
     
    var container = document.getElementById('example');
    var hot = new Handsontable(container, {
      data: data,
      rowHeaders: true,
      colHeaders: true
    });

    Examples


    Features

    Some of the most popular features include:

    • Sorting data
    • Data validation
    • Conditional formatting
    • Freezing rows/columns
    • Merging cells
    • Defining custom cell types
    • Moving rows/columns
    • Resizing rows/columns
    • Context menu
    • Adding comments to cells
    • Dragging fill handle to populate data
    • Internationalization
    • Non-contiguous selection

    See a comparison table


    Screenshot


    Resources


    Wrappers

    Handsontable CE comes with wrappers and directives for most popular frameworks:


    Support

    Report all the suggestions and problems on GitHub Issues.

    An open source version doesn't include a commercial support. You need to purchase Handsontable Pro license or contact us directly in order to obtain a technical support from the Handsoncode team.


    Contributing

    If you would like to help us to develop Handsontable, please take a look at this guide for contributing.


    Community


    License

    Handsontable Community Edition is released under the MIT license. Read license.

    Copyrights belong to Handsoncode sp. z o.o.

    Install

    npm i jacksontable

    DownloadsWeekly Downloads

    14

    Version

    6.2.2

    License

    MIT

    Unpacked Size

    20.6 MB

    Total Files

    1644

    Last publish

    Collaborators

    • rathboma