:warning: Handsontable Pro is now Handsontable. Since version 6.2.3
the Handsontable Pro package is deprecated. For version 7.0.0
use handsontable instead of handsontable-pro to stay up to date with future releases.
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
- Installation
- Basic usage
- Examples
- Features
- Screenshot
- Resources
- Wrappers
- Support
- Pricing
- License key
- 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
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
Wrappers
Handsontable Pro comes with wrappers and directives for most popular frameworks:
Support
Handsontable Pro is supported on a commercial basis. All the suggestions and issues should be sent to support@handsontable.com.
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.