Handsontable example
HTML
<script src="https://cdn.jsdelivr.net/npm/handsontable@12.1/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@12.1/dist/handsontable.full.min.css" />
<script src="https://handsontable.com/docs/8.3.2/components/numbro/dist/languages.min.js"></script>
<div id="example1" class="hot "></div>
<div style="position:fixed">
<button class="freeze">freeze</button>
<button class="unfreeze">unfreeze</button>
</div>
JavaScript
const container = document.querySelector('#example1');
const hot = new Handsontable(container, {
data: Handsontable.helper.createSpreadsheetData(10, 100),
colHeaders: true,
rowHeaders: true,
licenseKey: 'non-commercial-and-evaluation',
ManualColumnFreeze: true
});
let col = 1;
document.querySelector('.freeze').addEventListener('click', () => {
hot.getPlugin('ManualColumnFreeze').freezeColumn(col)
hot.render()
})
document.querySelector('.unfreeze').addEventListener('click', () => {
hot.getPlugin('ManualColumnFreeze').unfreezeColumn(hot.toVisualColumn(col))
console.log(hot.getPlugin('ManualColumnFreeze'))
hot.render()
})