Handsontable Pro is a premium JavaScript/HTML5 data grid component with spreadsheet look & feel. It easily integrates with any data source and comes with premium features like Filtering, Nested Headers, Dropdown Menu, Collapsing Columns, Multiple Column Sorting and Export to File. It is available for Vue, React, Angular and Polymer.

This is a commercial, paid software available for evaluation purposes only. To use it in a production environment you need to purchase a license and pass a valid license key in the configuration object.

Table of contents

1. Installation
2. Basic usage
3. Examples
4. Features
5. Screenshot
6. Resources
7. Wrappers
8. Support
9. Pricing
10. License key
11. License

Installation

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

npm install handsontable-pro

Alternative ways to install

• See the download section on how to install Handsontable Pro using nuget, bower, yarn and more.

Basic usage

Assuming that you have already installed Handsontable Pro, 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 Handsontable 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,
  filters: true,
  dropdownMenu: true
});

Examples

• See a live demo

Features

It includes all of the Handsontable Community Edition (CE) features, plus:

• Filtering
• Export to file
• Dropdown menu
• Nested headers
• Collapsing columns
• Multiple Column Sorting
• Hiding rows
• Hiding columns
• Trimming rows
• Column summary
• Header tooltips
• Binding rows with headers
• Formulas (alpha)
• Nested rows (alpha)
• Gantt Chart (beta)
• Non-contiguous selection

See a comparison table

Screenshot

Resources

• API Reference
• Compatibility
• Change log
• Roadmap
• Newsroom

Wrappers

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

• Angular
• Angular 1
• React
• Vue
• Polymer

Support

Handsontable Pro is supported on a commercial basis. All the suggestions and issues should be sent to [email protected].

Pricing

The pricing page lists all pricing info, and contains links to purchase a new license, or to renew a maintenance plan.

License key

Handsontable Pro requires passing a valid license key in the configuration section. You can find your purchased license key in your account at my.handsontable.com.

An example of what the configuration object should look like:

hot = new Handsontable(container,{
  data: data,
  rowHeaders: true,
  colHeaders: true,
  licenseKey: '00000-00000-00000-00000-00000'
});

Note that the license key is passed as a string so you need to wrap it in quotes ('').

License

Handsontable Pro is released under a commercial license. Learn more

Copyright belong to Handsoncode sp. z o.o.