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 });