Row headers

Use default row headers (1, 2, 3), or set them to custom values provided by an array or a function.

Overview

Row headers are gray-colored columns that are used to label each row. By default, these headers are filled with numbers displayed in ascending order.

To turn the headers on, set the option rowHeaders to true.

Bind rows with headers

You can bind row numbers with row headers. This is used mostly to differentiate two business cases in which Handsontable is most often used.

When moving a row in a typical grid-like application, the numbers in the row headers remain intact. Only the content is moved.
In a data grid, each row has its unique ID. Therefore, the column header should follow its row whenever it changes its position in the grid.

Basic example

To enable the plugin, set the bindRowsWithHeaders property to true. Move the rows in the example below to see what this plugin does.

Possible values:

true - Enables the plugin.
strict - Enables the plugin and the order of indexes is not reorganized after the operation such as hiding or moving rows.
loose - Enables the plugin and the order of indexes is re-organized after the operation such as hiding or moving rows.

1
import Handsontable from 'handsontable/base';
2
import { registerAllModules } from 'handsontable/registry';
3

4
// Register all Handsontable's modules.
5
registerAllModules();
6

7
// Generate an array of arrays with a dummy data
8
const generateData = (rows = 3, columns = 7, additionalRows = true) => {
9
  let counter = 0;
10
  const array2d = [...new Array(rows)].map((_) => [...new Array(columns)].map((_) => counter++));
11

12
  if (additionalRows) {
13
    array2d.push([]);
14
    array2d.push([]);
15
  }
16

17
  return array2d;
18
};
19

20
const container = document.querySelector('#example1');
21

22
new Handsontable(container, {
23
  data: generateData(),
24
  colHeaders: true,
25
  rowHeaders: true,
26
  height: 'auto',
27
  contextMenu: true,
28
  manualRowMove: true,
29
  bindRowsWithHeaders: true,
30
  autoWrapRow: true,
31
  autoWrapCol: true,
32
  licenseKey: 'non-commercial-and-evaluation',
33
});

1
import Handsontable from 'handsontable/base';
2
import { registerAllModules } from 'handsontable/registry';
3

4
// Register all Handsontable's modules.
5
registerAllModules();
6

7
// Generate an array of arrays with a dummy data
8
const generateData = (rows = 3, columns = 7, additionalRows = true) => {
9
  let counter = 0;
10

11
  const array2d = [...new Array(rows)].map((_) => [...new Array(columns)].map((_) => counter++));
12

13
  if (additionalRows) {
14
    array2d.push([]);
15
    array2d.push([]);
16
  }
17

18
  return array2d;
19
};
20

21
const container = document.querySelector('#example1')!;
22

23
new Handsontable(container, {
24
  data: generateData(),
25
  colHeaders: true,
26
  rowHeaders: true,
27
  height: 'auto',
28
  contextMenu: true,
29
  manualRowMove: true,
30
  bindRowsWithHeaders: true,
31
  autoWrapRow: true,
32
  autoWrapCol: true,
33
  licenseKey: 'non-commercial-and-evaluation',
34
});

Tree grid

A tree grid enables you to represent the nested data structures within the data grid. To learn more about this feature, see the Row parent-child page.

Related guides

Row parent-child

Configuration options

activeHeaderClassName

currentHeaderClassName

Core methods

Hooks