react-datasheet-grid

An Airtable-like / Excel-like component to create beautiful spreadsheets.

SpreadsheetReact
nick-keller/react-datasheet-gridreact-datasheet-grid

README

react-datasheet-grid


An Airtable-like / Excel-like component to create beautiful spreadsheets.

Feature rich:
- Dead simple to set up and to use
- Supports copy / pasting to and from Excel, Google-sheet...
- Keyboard navigation and shortcuts fully-supported
- Supports right-clicking and custom context menu
- Supports dragging corner to expand selection
- Easy to extend and implement custom widgets
- Blazing fast, optimized for speed, minimal renders count
- Smooth animations
- Virtualized rows and columns, supports hundreds of thousands of rows
- Extensively customizable, controllable behaviors
- Built with Typescript

Install


  1. ```bash
  2. npm i react-datasheet-grid
  3. ```

Usage


  1. ```tsx
  2. import {
  3.   DataSheetGrid,
  4.   checkboxColumn,
  5.   textColumn,
  6.   keyColumn,
  7. } from 'react-datasheet-grid'

  9. // Import the style only once in your app!
  10. import 'react-datasheet-grid/dist/style.css'

  12. const Example = () => {
  13.   const [ data, setData ] = useState([
  14.     { active: true, firstName: 'Elon', lastName: 'Musk' },
  15.     { active: false, firstName: 'Jeff', lastName: 'Bezos' },
  16.   ])

  18.   const columns = [
  19.     {
  20.       ...keyColumn('active', checkboxColumn),
  21.       title: 'Active',
  22.     },
  23.     {
  24.       ...keyColumn('firstName', textColumn),
  25.       title: 'First name',
  26.     },
  27.     {
  28.       ...keyColumn('lastName', textColumn),
  29.       title: 'Last name',
  30.     },
  31.   ]

  33.   return (
  34.     <DataSheetGrid
  35.       value={data}
  36.       onChange={setData}
  37.       columns={columns}
  38.     />
  39.   )
  40. }
  41. ```