how to style header of exported file using excelJs

Question

How can I custom style like border,color, width etc, of creating header in excelJs ?

I can style the rows of the sheet but not the header

  fDay = days[0].charAt(0)
  sDay = days[1].charAt(0)
  sheet.columns = [
    {header: 'Num', key: 'id'},
    {header: 'Nom prenom', key: 'name'},
    {header: 'Date de naissance', key: 'birthday'},
    {header: fDay+'1', key: fDay+'1', style: {border: 'thin'}},
    {header: sDay+'1', key: sDay+'1'},
    {header: fDay+'2', key: fDay+'2'},
    {header: sDay+'2', key: sDay+'2'},
    {header: fDay+'3', key: fDay+'3'},
    {header: sDay+'3', key: sDay+'3'},
    {header: fDay+'4', key: fDay+'4'},
    {header: sDay+'4', key: sDay+'4'},
    {header: fDay+'5', key: fDay+'5'},
    {header: sDay+'5', key: sDay+'5'},
  ]
  $.each(dataPlayers, (index, player)=>{
    row = sheet.addRow({id: player.id, name: player.Prenom+' '+player.Nom, birthday: getShortDate(player.DateNaissance)})
    row.eachCell(function(cell) {
         cell.border = {
           top: {style:'thin'},
           left: {style:'thin'},
           bottom: {style:'thin'},
           right: {style:'thin'}
         };
       })
  })

the result is like this

a excel file

D. Ahmed · Accepted Answer · 2021-08-19 11:23:57Z

So, the way that I found is to create all the rows and then iterate each cell of each row to apply a style on it or on the row it self :

sheet.eachRow({ includeEmpty: true }, function(row, rowNumber){
  row.eachCell(function(cell, colNumber){
   cell.font = {
     name: 'Arial',
     family: 2,
     bold: false,
     size: 10,
   };
   cell.alignment = {
     vertical: 'middle', horizontal: 'center'
   };
   if (rowNumber <= 10) {
     row.height = 20;
     cell.font = {
       bold: true,
     };
    }
    if (rowNumber >= 10) {
     for (var i = 1; i < 14; i++) {
       if (rowNumber == 10) {
         row.getCell(i).fill = {
           type: 'pattern',
           pattern:'solid',
           fgColor:{argb:'C7C7C7'}
         };
       }
       row.getCell(i).border = {
       top: {style:'thin'},
       left: {style:'thin'},
       bottom: {style:'thin'},
       right: {style:'thin'}
     };
   }
  }
 });
});

using the documentation of excelJS to use the style properties

Alex · Accepted Answer · 2023-02-17 05:59:26Z

0

const titleRow4 = worksheet.addRow([mainheading]);
    titleRow4.font = { family: 4, size: 10, bold: true };
    titleRow4.alignment = { horizontal: 'center' }
    worksheet.mergeCells('A5:D5');

answered Feb 17, 2023 at 5:59

Alex

111 bronze badge

3 Comments

Alex Over a year ago

you can also use for loop to simply add

Fcmam5 Over a year ago

Please explain your answer and highlight was was wrong in OP's approach

Alex Over a year ago

1.mainheading = 'any string'; we can give each row style include its string

Collectives™ on Stack Overflow

how to style header of exported file using excelJs

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related