/Javascript/AngularJS/Angular 11 export excel with customize header

Angular 11 export excel with customize header

public exportAsExcelFile(json: any[], excelFileName: string, headersArray: any[]): void {
    //Excel Title, Header, Data
    const header = headersArray;
    const data = json;
    //Create workbook and worksheet
    let workbook = new Workbook();
    let worksheet = workbook.addWorksheet(excelFileName);
    //Add Header Row
    let headerRow = worksheet.addRow(header);
    // Cell Style : Fill and Border
    headerRow.eachCell((cell, number) => {
      cell.fill = {
        type: 'pattern',
        pattern: 'solid',
        fgColor: { argb: 'FFFFFF00' },
        bgColor: { argb: 'FF0000FF' }
      }
      cell.border = { top: { style: 'thin' }, left: { style: 'thin' }, bottom: { style: 'thin' }, right: { style: 'thin' } }
    })
    // Add Data and Conditional Formatting
    data.forEach((element) => {
      let eachRow = [];
      headersArray.forEach((headers) => {
        eachRow.push(element[headers])
      })
      if (element.isDeleted === "Y") {
        let deletedRow = worksheet.addRow(eachRow);
        deletedRow.eachCell((cell, number) => {
          cell.font = { name: 'Calibri', family: 4, size: 11, bold: false, strike: true };
        })
      } else {
        worksheet.addRow(eachRow);
      }
    })
    worksheet.getColumn(3).width = 15;
    worksheet.getColumn(4).width = 20;
    worksheet.getColumn(5).width = 30;
    worksheet.getColumn(6).width = 30;
    worksheet.getColumn(7).width = 10;
    worksheet.addRow([]);
    //Generate Excel File with given name
    workbook.xlsx.writeBuffer().then((data) => {
      let blob = new Blob([data], { type: EXCEL_TYPE });
      fs.saveAs(blob, excelFileName + '_export_' + new Date().getTime() + EXCEL_EXTENSION);
    })
  }
 Run code snippet

Source: stackoverflow.com

Similar codes

5 votes178 views3 answers
Angularjs cdn
Javascript AngularJS
17 votes198 views2 answers
Angular random number between 1 and 10
Javascript AngularJS
0 vote128 views1 answer
Angular material inline list
Javascript AngularJS
0 vote164 views1 answer
Angular generer guard
Javascript AngularJS
6 votes201 views1 answer
Get value onChange from mat-select angular
Javascript AngularJS
5 votes386 views1 answer
Experimental support for decorators is a feature that is subject to change in a future release. Set the 'experimentalDecorators' option in your 'tsconfig' or 'jsconfig' to remove this warning.ts(1219) angular
Javascript AngularJS
-1 vote197 views1 answer
Angular bind to class or ngClass
Javascript AngularJS
0 vote176 views2 answers
15) Which of the following directive is used to initialize an angular app? A. ng-app ANSWER B.ng-model C.ng-controller D.None of the above
Javascript AngularJS
5 votes175 views2 answers
Angular how to copy text with button
Javascript AngularJS
0 vote173 views1 answer
Convert angular HTTP to Native HTTP in Ionic
Javascript AngularJS