Spreadsheet-like data grid editor
npm install @reactual/handsontableHandsontable Community Edition (CE) is an open source JavaScript/HTML5 UI Spreadsheet component for web apps. It easily integrates with any data source and comes with a variety of useful features like data binding, validation, sorting or powerful context menu. Actively supported by the Handsoncode team and many contributors.
If you are looking for a commercial version, try out Handsontable Pro.




1. What to use it for?
1. Installation
2. Basic usage
3. Examples
4. Features
5. Screenshot
6. Resources
7. Wrappers
8. Support
9. Contributing
10. Community
11. License
- Database editing
- Configuration controlling
- Data merging
- Team scheduling
- Sales reporting
- Financial analysis
npm install handsontable
`Alternative ways to install
- See the download section on how to install Handsontable CE using nuget, bower, yarn and more.
$3
Assuming that you have already installed Handsontable CE, create an empty element that will be turned into a spreadsheet:`html
`
In the next step, pass a reference to that element into the Handsontable CE constructor and fill the instance with sample data:
`javascript
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
});
``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
- Angular
- Angular 1
- React
- Vue
- Polymer
- Typescript file
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.
Copyrights belong to Handsoncode sp. z o.o.