XLSX : Make BOLD Header : Using Angular 4

[profile4vaibhav]

Hello Team,

I am using XLSX library to export my multiple grids into one single excel file with the help of Angular 4.
I want to make the Headers of the excel BOLD, I tried it but didn't find a way.
So can u just tell me how do i do that, or do we need a paid version of XLSX to achieve this.

[bhavinshiroya1994]

@profile4vaibhav

same problem, please tell me anyone answer

[Alian248]

？？？发自我的华为手机-------- 原始邮件 --------主题：Re: [SheetJS/js-xlsx] XLSX : Make BOLD Header : Using Angular 4 (#1403)发件人：bhavinshiroya1994 收件人：SheetJS/js-xlsx 抄送：Subscribed @profile4vaibhav same problem, please tell me anyone answer —You are receiving this because you are subscribed to this thread.Reply to this email directly, view it on GitHub, or mute the thread.

[curiousalok]

same problem.If anyone has solution to this please do share .

[tayyabxatti]

i used this for loop to get to the headers :

for(var C = range.s.r; C <= range.e.r; ++C) {
var address = XLSX.utils.encode_col(C) + "1"; // <-- first row, column number C
if(!ws[address]) continue;
debugger

    // ws[address].s=ws[address].s={
			// 	font:{
			// 		bold:true
    	// }};
    ws[address].v=ws[address].v.bold(); 
  }

this results in headers values as value I just need to encode it somehow which I am facing difficulty achieving

[SheetJSDev]

Bold and other text and cell styling are covered in our Pro builds