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