• This repository has been archived on 15/Mar/2022
  • Stars
    star
    515
  • Rank 82,575 (Top 2 %)
  • Language
    TypeScript
  • License
    MIT License
  • Created over 7 years ago
  • Updated about 3 years ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

React Data Grid with Spreadsheet Look & Feel. Official React wrapper for Handsontable.

Important information

We permanently moved this project to the main Handsontable repository at https://github.com/handsontable/handsontable/tree/master/wrappers/react

It is still available under the same name in npm: @handsontable/react, so you don't have to update your dependency configuration.





Handsontable for React

This is the official wrapper of Handsontable data grid for React.
It provides data binding, data validation, filtering, sorting and more.

npm npm Build status



Installation

Use npm to install this wrapper together with Handsontable.

npm install handsontable @handsontable/react

You can load it directly from jsDelivr as well.

<script src="https://cdn.jsdelivr.net/npm/handsontable/dist/handsontable.full.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/@handsontable/react/dist/react-handsontable.min.js"></script>

<link href="https://cdn.jsdelivr.net/npm/handsontable/dist/handsontable.full.min.css" rel="stylesheet">

The component will be available as Handsontable.react.HotTable.

Usage

Use this data grid as you would any other component in your application. Options can be set as HotTable props.

Styles

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

React Component

import React from 'react';
import ReactDOM from 'react-dom';
import { HotTable } from '@handsontable/react';

class HotApp extends React.Component {
  constructor(props) {
    super(props);
    this.data = [
      ['', 'Tesla', 'Mercedes', 'Toyota', 'Volvo'],
      ['2019', 10, 11, 12, 13],
      ['2020', 20, 11, 14, 13],
      ['2021', 30, 15, 12, 13]
    ];
  }

  render() {
    return (<HotTable data={this.data} colHeaders={true} rowHeaders={true} width="600" height="300" />);
  }
}
See the live demo

Features

A list of some of the most popular features:

  • Multiple column sorting
  • Non-contiguous selection
  • Filtering data
  • Export to file
  • Validating data
  • Conditional formatting
  • Merging cells
  • Custom cell types
  • Freezing rows/columns
  • Moving rows/columns
  • Resizing rows/columns
  • Hiding rows/columns
  • Context menu
  • Comments
  • Auto-fill option

Documentation

Support and contribution

We provide support for all users through GitHub issues. If you have a commercial license then you can add a new ticket through the contact form.

If you would like to contribute to this project, make sure you first read the guide for contributors.

Browser compatibility

Handsontable is compatible with modern browsers such as Chrome, Firefox, Safari, Opera, and Edge. It also supports Internet Explorer 9 to 11 but with limited performance.

License

This wrapper is released under the MIT license but under the hood it uses Handsontable, which is dual-licensed. You can either use it for free in all your non-commercial projects or purchase a commercial license.

Free license Paid license
For non-commercial purposes such as teaching, academic research, personal experimentation, and evaluating on development and testing servers. For all commercial purposes
All features are available All features are available
Community support Dedicated support
Read the license See plans

License key

The license key is obligatory since Handsontable 7.0.0 (released in March 2019).

If you use Handsontable for purposes not intended toward monetary compensation such as, but not limited to, teaching, academic research, evaluation, testing and experimentation, pass a phrase 'non-commercial-and-evaluation', as presented below.

You can pass it in the settings object:

settings: {
  data: data,
  rowHeaders: true,
  colHeaders: true,
  licenseKey: 'non-commercial-and-evaluation'
}

Alternatively, you can pass it to a licenseKey prop:

<HotTable settings={settings} licenseKey="00000-00000-00000-00000-00000" />

If, on the other hand, you use Handsontable in a project that supports your commercial activity, then you must purchase the license key at handsontable.com.

The license key is validated in an offline mode. No connection is made to any server. Learn more about how it works.



Created by Handsoncode with and in Tricity.

More Repositories

1

handsontable

JavaScript data grid with a spreadsheet look & feel. Works with React, Angular, and Vue. Supported by the Handsontable team ⚡
JavaScript
18,903
star
2

hyperformula

HyperFormula is an open-source headless spreadsheet for business web apps. It comes with over 400 formulas, CRUD operations, undo-redo, clipboard support, and sorting. Built in TypeScript, supported by the Handsontable Team.
TypeScript
1,716
star
3

vue-handsontable-official

Vue Data Grid with Spreadsheet Look & Feel. Official Vue wrapper for Handsontable.
TypeScript
748
star
4

formula-parser

Javascript Library parsing Excel Formulas and more
JavaScript
630
star
5

ngHandsontable

Official AngularJS directive for Handsontable
JavaScript
433
star
6

angular-handsontable

Angular Data Grid with Spreadsheet Look & Feel. Official Angular wrapper for Handsontable.
TypeScript
173
star
7

ruleJS

Javascript library to parse excel formulas
JavaScript
154
star
8

hot-table

Handsontable - Best Data Grid Web Component with Spreadsheet Look and Feel.
JavaScript
129
star
9

handsontable-pro

Handsontable Pro - Premium JavaScript/HTML5 Data Grid Component with Spreadsheet Look & Feel. Available for React, Vue and Angular.
JavaScript
88
star
10

handsontable-ruleJS

Formula parser for Handsontable data grid using RuleJS library
JavaScript
59
star
11

spreadsheet-viewer

Spreadsheet Viewer is a developer-friendly JavaScript tool that lets your users preview Excel files without leaving your web app
27
star
12

handsontable-skeleton

Handsontable Skeleton
JavaScript
20
star
13

docs

API Documentation for Handsontable
HTML
20
star
14

hot-builder

CLI tool for building custom Handsontable package
JavaScript
16
star
15

performance-lab

JavaScript performance tests for Handsontable
JavaScript
12
star
16

hyperformula-demos

JavaScript
10
star
17

spreadsheet-icons

Spreadsheet icons - a minimalistic icon set for data views (data grids, spreadsheets and tables)
10
star
18

jstat

JavaScript Statistical Library
JavaScript
8
star
19

docs-archive

API Documentation for Handsontable
6
star
20

examples

Examples for Handsontable component
TypeScript
1
star
21

docs-pro-archive

API Documentation for Handsontable Pro
1
star
22

babel-plugin-forbidden-imports

Babel plugin which adds you ability to forbidden load specific modules
JavaScript
1
star