@handsontable/angular

Handsontable Community Edition for Angular is the official wrapper for Handsontable Community Edition, an open source data grid component with a spreadsheet look & feel. It easily integrates with any data source and comes with lots of useful features like data binding, validation, sorting or powerful context menu.

Table of contents

1. Installation
2. Getting Started
3. Documentation
4. What to use it for?
5. Features
6. Screenshot
7. Resources
8. Support
9. Contributing
10. Licensing

Installation

Use npm to download the project.

npm install handsontable @handsontable/angular

Getting Started

Assuming that you have installed the wrapper with npm, now you just need to include Handsontable styles into your build system and use <hot-table> just like any other Angular component.

Styles

@import '~handsontable/dist/handsontable.full.css';

Angular Component

import { BrowserModule } from '@angular/platform-browser';
import { NgModule } from '@angular/core';
import { AppComponent } from './app.component';
import { HotTableModule } from '@handsontable/angular';
 
@NgModule({
  declarations: [
    AppComponent
  ],
  imports: [
    BrowserModule,
    HotTableModule.forRoot()
  ],
  providers: [],
  bootstrap: [AppComponent]
})
export class AppModule { }

Template

<hot-table></hot-table>

Documentation

Visit docs.handsontable.com to get more Handsontable for Angular examples and guides.

What to use it for?

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

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

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

Screenshot

Resources

• Guides
• API Reference
• Release notes
• Roadmap
• Twitter

Support

You can report your issues here on GitHub.

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

Contributing

If you would like to help us to develop this wrapper for Angular, please read the guide for contributors first.

Licensing

This wrapper is released under the MIT license.

Copyrights belong to Handsoncode sp. z o.o.

Changelog

[13.0.0] - 2023-06-22

Added

• Angular: Added support for Angular 16. #10396

Changed

• Breaking change (React, Angular, Vue 2, Vue 3): Changed Handsontable's policy toward older versions of supported frameworks. From now on, Handsontable supports only those versions of any supported frameworks that are officially supported by their respective teams. Dropping Handsontable's support for any older framework versions won't be treated as a breaking change. #10396
• Breaking change: Changed the order in which three hooks are executed: now, the beforeChange hook is fired before the afterSetDataAtCell and afterSetDataAtRowProp hooks. #10231
• Changed the margins of the context menu in the RTL layout direction. #10375

Removed

• Breaking change (Angular): Dropped support for Angular 13 and lower. From now on, Handsontable supports only those versions of Angular that are officially supported by the Angular team: currently, it's 14-16. However, Handsontable 13.0.0 was thoroughly tested and, to the best of our knowledge, works correctly with versions down to Angular 12. #10396
• Breaking change: Removed the deprecated beforeAutofillInsidePopulate hook. #10407
• Breaking change: Removed the deprecated getFirstNotHiddenIndex method. Instead, use the getNearestNotHiddenIndex() method. #10407
• Breaking change: Removed the deprecated parameters of the alter() method: insert_row and insert_col. Instead, use the following parameters: insert_row_above, insert_row_below, insert_col_start, and insert_col_end. #10407
• Breaking change: Removed the deprecated parameters of the populateFromArray() method: direction and deltas. #10407

Fixed

• Fixed an issue where the "Read only" icon of the context menu displayed incorrectly in the RTL layout direction. #10375

For more information on Handsontable 13.0.0, see:

• Blog post (13.0.0)
• Documentation (13.0)
• Migration guide (12.4 → 13.0)
• Release notes (13.0.0)