Forked from SheetJS Spreadsheet data parser and writer. Customised for DCM Excel templates, i.e. enabled some cell formatting like borders, bold font, highlighting (light blue fill color as in DCM templates), vertical and horizontal alignment.
npm install xlsx-dcm-templateForked from SheetJS Spreadsheet data parser and writer. Customised for DCM Excel templates, i.e. enabled some cell formatting like borders, bold font, highlighting (light blue fill color as in DCM templates), vertical and horizontal alignment.
Basically, you can use four additional cell properities to do what was said above:
worksheet[cellRef].border = true;
worksheet[cellRef].bold = true;
worksheet[cellRef].highlight = true;
worksheet[cellRef].alignmentID = 13;