How to freeze a pane in an Excel table using SheetJS?

Question

I use SheetJS to make an Excel table in my node.js application:

const xlsx = require('xlsx');

const workbook = xlsx.utils.book_new();
const worksheet = xlsx.utils.aoa_to_sheet([
    ['Number', 'Name', 'Value'],
    [1, 'Bill', 1500],
    [2, 'John', 2300]
]);
xlsx.utils.book_append_sheet(workbook, worksheet, 'Accounts');
xlsx.writeFile(workbook, 'output.xlsx');

How to freeze a pane of the table, e.g. the first row? Saying "freeze" I mean making a row and/or a column always stay on the top of a table viewer interface.

score 1 · Answer 1 · answered Dec 04 '19 at 20:36

It seems there were some tries to implement this feature, but as of version 0.14.1 it is still not available.

It seems someone in Apr 2, 2017 tried to implement it. I even tried using the sample code on the javascript comments but it didn't work.

Reference: Commit history on GitHub

Doing a code search on v.0.14.1 I found 3 instances of the word "Freeze":

0x0087: 'FREEZE.PANES', // On line 11478
case 'FreezePanes': break; // On line 15746
/* FreezePanes */ // On line 16113

So, it seems there were some tries to implement it but there were removed/abandoned, at least on the community version as of 0.14.

score 1 · Answer 2 · answered May 21 '21 at 08:47

I just researched this, they don't offer freezing option in community edition but in their pro compendium, one of the developers mentioned this in a GitHub issue.

The reference link is here. https://github.com/SheetJS/sheetjs/issues/785#issuecomment-390501860

How to freeze a pane in an Excel table using SheetJS?

2 Answers2