excel4node set background color in cell

background color

// Require library 
const xl = require('excel4node');

// Create a new instance of a Workbook class 
const wb = new xl.Workbook();

// Add Worksheets to the workbook 
const ws = wb.addWorksheet('Background Color');

// create a style with solid background color
// for "solid" pattern, the fgcolor is the color shown 
const bgStyle = wb.createStyle({
  fill: {
    type: 'pattern',
    patternType: 'solid',
    bgColor: '#FFFF00',
    fgColor: '#FFFF00',
  }
});

ws.cell(1, 1).style(bgStyle);
ws.cell(1, 1).string('Yellow');

wb.write('BG_Color.xlsx');