Gaurav Kumar

Gaurav Kumar

  • 1.9k
  • 46
  • 4.9k

formatting in excel header back color and image Logo

Jun 29 2020 9:17 PM
generateExcel(pageTemplate, image, fileName) {
const ws: xlsx.WorkSheet =
xlsx.utils.table_to_sheet(pageTemplate.nativeElement);
const wb: xlsx.WorkBook = xlsx.utils.book_new();
xlsx.utils.book_append_sheet(wb, ws, 'Sheet1');
xlsx.writeFile(wb, fileName + '.xlsx');
}

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (1)