Tuesday, 27 November 2018

How to change msexcell cell format in Node.js by using exceljs

const Excel = require('exceljs');
let workbook = new Excel.Workbook();
let workSheet = workbook.getWorksheet(1);
workSheet.getCell('W2').font = {color: {argb: "004e47cc"}};

this code sets font color for entire row, not just W2 cell. Same happens if I do:

let row2 = workSheet.getRow(2);
row2.getCell(23).font = {color: {argb: "004e47cc"}}; //W2

So how do I set cell style just for certain cell?



from How to change msexcell cell format in Node.js by using exceljs

No comments:

Post a Comment