How to set cell width when export .xlsx files with js-xlsx

Question

I am trying to set a fixed column/cell width to my exported excel files with js-xlsx.

EDIT:

Here is the source of js-xlsx: https://github.com/SheetJS/js-xlsx

Data View

Answer

I found a snippet the the write test here https://github.com/SheetJS/js-xlsx/blob/master/tests/write.js#L14-L19

For quick reference, where ws is your worksheet.

var wscols = [
    {wch:6},
    {wch:7},
    {wch:10},
    {wch:20}
];

ws['!cols'] = wscols;

Accepted Answer

I found a snippet the the write test here https://github.com/SheetJS/js-xlsx/blob/master/tests/write.js#L14-L19For quick reference, where ws is your worksheet.var wscols = [    {wch:6},    {wch:7},    {wch:10},    {wch:20}];ws['!cols'] = wscols;

Advertisement

Answer