handsontable 0,8,6,0,5,10,0,14 editorconfig travis-ci grunt Bower npm

Handsontable Community Edition - a JavaScript/HTML5 Spreadsheet Library for Developers

Build Status

Handsontable is a pure JavaScript/HTML5 spreadsheet component with an Excel-like appearance. It can easily integrate with any data source and comes with a variety of useful features like data binding, validation, sorting or powerful custom context menu. Actively supported by the Handsoncode team team and many contributors.

Build status npm npm

What to use it for?

We have seen Handsontable being used in many different, sometimes completely unexpected fields. The list below is just to give you a rough idea on what you can do with Handsontable, but it doesn’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 Handsontable but we suggest using one of available package managers.

npm install handsontable --save

or

bower install handsontable --save

Alternative installation

AMD support

If you use a modular script loader then you can require Handsontable just like any other module:

require(['handsontable'], function(Handsontable) {
    var hot = new Handsontable(document.getElementById('example'), {
      data: [[1, 2, 3, 4], [1, 2, 3, 4]]
    });
});

CommonJS module support

If you use a CommonJS compatible environment you can use the require function to import Handsontable:

var handsontable = require('handsontable');

To bundle Handsontable with Browserify you must specify the module names of all required modules:

browserify main.js -o bundle.js -r moment -r pikaday -r zeroclipboard -r numbro

Basic usage

Assuming you have already installed Handsontable, add 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 and fill it with sample data:

var data = [
  ["", "Ford", "Volvo", "Toyota", "Honda"],
  ["2016", 10, 11, 12, 13],
  ["2017", 20, 11, 14, 13],
  ["2018", 30, 15, 12, 13]
];

var container = document.getElementById('example');
var hot = new Handsontable(container, {
  data: data,
  rowHeaders: true,
  colHeaders: true
});

Examples

Resources

Commercial version

Handsontable Pro is a commercial spreadsheet solution packed with additional, business-ready features. It comes with a dedicated support and a forum support, where you can find the answers to common questions.

| Pro Feature | Description | |————————— |—————————————————————————————- | | Binding rows with headers | Bind rows with headers to lock the row number and always display one beside the other. | | Collapsing columns | Expand and collapse columns to better fit the content. | | Column summary | Carry out pre-defined calculations and display the results in Handsontable. | | Dropdown menu | Add a menu to the heading to enable additional operations for the columns. | | Export to file | Export data to a flat file like CSV or a string. | | Filtering | Display rows that meet your criteria and hide the rest. | | Gantt Chart | Create a simple Gantt Chart using Handsontable. | | Header tooltips | Display the header label in a tooltip. | | Hiding columns | Hide specific columns and show the rest. | | Hiding rows | Hide specific rows and show the rest. | | Nested headers | Create a nested, hierarchical structure of headers to get your data into groups. | | Trimming rows | Exclude specific rows from the rendering process so they won’t be displayed. |

Have questions regarding the Pro version? Contact us or take a look at the Frequently Asked Questions.

Screenshot

Handsontable Screenshot

Community

Contributing

If you would like to help us in writing the code, please take a look into CONTRIBUTING.md

Copyright and license

Handsontable is released under the MIT license.

Copyrights belong to Handsoncode sp. z o.o.

Related Repositories

handsontable

handsontable

Handsontable Community Edition - a JavaScript/HTML5 Spreadsheet Library for Developers ...

ngHandsontable

ngHandsontable

AngularJS directive for Handsontable ...

ng2-handsontable

ng2-handsontable

Angular 2 directive for Handsontable ...

hot-table

hot-table

Polymer Element wrapper for Handsontable data grid editor ...

handsontable-ruleJS

handsontable-ruleJS

Formula parser for Handsontable data grid using RuleJS library ...


Top Contributors

warpech jansiegel budnix psmolenski kubak10 swistach Berus bollwyvl littley skilesare jayden-emergence swilla thanpolas Dinesh-Ramakrishnan j-francisco tomalec cmac rkrx peller vo-va bengladwell abliss alexgann ghiculescu alexpls archit AMBudnik bgrohman GabiAxel jasoncrawford

Dependencies

package version
moment 2.18.1
numbro 1.11.0
pikaday 1.5.1
dev babel-cli ^6.24.1
babel-core ^6.25.0
babel-eslint ^7.2.3
babel-jest ^19.0.0
babel-loader ^7.1.1
babel-plugin-forbidden-imports ^0.1.2
babel-plugin-transform-object-rest-spread ^6.23.0
babel-plugin-transform-require-ignore ^0.1.1
babel-polyfill ^6.23.0
babel-preset-env ^1.6.0
babel-register ^6.24.1
check-es3-syntax-cli ^0.2.0
concurrently ^3.5.0
copy-webpack-plugin ^4.0.1
cross-env ^5.0.1
css-loader ^0.28.4
eslint ^4.3.0
eslint-config-airbnb-base ^11.3.1
eslint-plugin-import ^2.7.0
extract-text-webpack-plugin ^2.1.2
glob ^7.1.2
grunt ^1.0.1
grunt-lib-phantomjs ^1.1.0
html-webpack-plugin ^2.29.0
jasmine-co ^1.2.2
jasmine-core 2.5.2
jasmine-terminal-reporter ^1.0.3
jest ^19.0.0
loader-utils ^1.1.0
optimize-css-assets-webpack-plugin ^1.3.2
progress-bar-webpack-plugin ^1.10.0
request ^2.81.0
rimraf ^2.5.4
spawn-command 0.0.2
style-loader ^0.18.2
supports-color ^4.2.1
tree-kill ^1.1.0
typescript ^2.4.2
webpack ^2.7.0

Releases

-   v0.10.5 zip tar
-   v0.10.4 zip tar
-   v0.10.3 zip tar
-   v0.10.2 zip tar
-   v0.10.1 zip tar
-   v0.10.0 zip tar
-   v0.10.0-beta4 zip tar
-   v0.10.0-beta3 zip tar
-   v0.10.0-beta2 zip tar
-   v0.10.0-beta1 zip tar
-   v0.9.19 zip tar
-   v0.9.18 zip tar
-   v0.9.17 zip tar
-   v0.9.16 zip tar
-   v0.9.15 zip tar
-   v0.9.14 zip tar
-   v0.9.13 zip tar
-   v0.9.12 zip tar
-   v0.9.11 zip tar
-   v0.9.10 zip tar
-   v0.9.9 zip tar
-   v0.9.8 zip tar
-   v0.9.7 zip tar
-   v0.9.6 zip tar
-   v0.9.5 zip tar
-   v0.9.4 zip tar
-   v0.9.3 zip tar
-   v0.9.2 zip tar
-   v0.9.1 zip tar
-   v0.9.0 zip tar