Javascipt: using XLSX.utils alignment is not working

Viewed 10

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); 
0 Answers
Related