Sheetjs: How to set width for Columns

[hyrin65]

Hi,
Please help me. How to set width for Columns for excel file export.
Thank you

[ravneetSodhi29]

How to set columns autofit

[danail-vasilev]

Hi,
I want to convert json to .xlsx format buffer (I guess I should use this). Then I want to set width of excel columns as well ! Is that feasible with the free version of this product ?
Kind Regards,

[m26597]

I also want to know the method

[fclemonschool]

var wscols = [
    {wch: 6}, // "characters"
    {wpx: 50}, // "pixels"
    ,
    {hidden: true} // hide column
];
ws['!cols'] = wscols;

like this
Please refer to the following link: https://github.com/SheetJS/js-xlsx/blob/master/tests/write.js#L14-L19

[reviewher]

@fclemonschool answered the question :)

[dave-wind]

automatic cell width you can try to see it
https://github.com/dave-wind/excel

[MWAN001]

Tried both wch or width, neither works

var wscols = [ {wch:20}, {wch:30}, {wch:40}, {wch:30},{wch:10}, {wch:10}];
ws['!cols'] = wscols;

var wscols = [ {width:20}, {width:30}, {width:40}, {width:30},{wch:10}, {width:10}];
ws['!cols'] = wscols;