I am using XLSX utils in javascript to generate excel. here I am using below code for cell alignment
ws["H"+i].s = { alignment : {horizontal: "left"}};
Please help me if above on is correct / solution
full code:
var xls1 = XLSX.utils.table_to_book(document.getElementById('xls1'), {sheet:"sheet1"});
var xls1_name = 'sheet_'+(new Date()).toLocaleDateString('en-us').replace(/[\-\:\.]/g, "")+'_'+(new Date()).toLocaleTimeString().replace(/[\-\:\.]/g, "")+'.xlsx';
var ws = xls1.Sheets.sheet1;
let range = XLSX.utils.decode_range(ws['!ref']);
var cellNumberFormat = '#,##0.00';
var colsFmt = ['H','I','J','K','L','M','O','Q','S','N','T','U','V','W']
for ( let i = 3; i <= range.e.r+1; i++) {
for(var colIdx =0; colIdx < colsFmt.length; colIdx++) { console.log(colsFmt[colIdx]+i);
ws[colsFmt[colIdx]+i].z = cellNumberFormat;
ws[colsFmt[colIdx]+i].s = { alignment : {horizontal: "left"}};
}
}
XLSX.writeFile(xls1, xls1_name);