Fixing

优质
小牛编辑
125浏览
2023-12-01

Specify two fixed rows with fixedRowsTop: 2 and two fixed columns with fixedColumnsLeft: 2 option.

Note: You'll need horizontal scrollbars, so just set a container width and overflow: hidden in CSS.

If you're looking for an option to manually fix columns, see the Freezing section of this documentation.

var example = document.getElementById('example1');
var hot = new Handsontable(example, {
  data: Handsontable.helper.createSpreadsheetData(100, 50),
  colWidths: 100,
  width: '100%',
  height: 320,
  rowHeaders: true,
  colHeaders: true,
  fixedRowsTop: 2,
  fixedColumnsLeft: 2
});