How to set header at row 3 or 4 in exceljs

Viewed 15

I want to set header at row 3 or 4 in exceljs.I have seen a similler question here and I have tried like what they suggest but it dosen't work for me.Can you guys please find out where i am doing wrong

        var filename = this.state.id + "no_machinereport.xlsx";
        var workbook = new Excel.Workbook();
        workbook.creator = "Sourav Singha";
        workbook.lastModifiedBy = "Sourav Singha";
        workbook.modified = new Date();
        workbook.lastPrinted = new Date();
        var worksheet = workbook.addWorksheet("Publications", { properties: { tabColor: { argb: '6B5B95' }, defaultRowHeight: 30, defaultColWidth: 25 } });
        worksheet.getRow(1).height = 48;
        worksheet.getRow(2).height = 21;

        // Print Title
        worksheet.mergeCells(1, 1, 1, 8);
        worksheet.getCell(1, 1).value = "Machine " + this.state.id + " Report";
        worksheet.getCell(1, 1).style = { font: { size: 16, underline: true, bold: true }, alignment: { vertical: "middle", horizontal: "center" }, width: 25 };

        var header_row = worksheet.getRow(3)
        const Header = [
            { header: "Date", key: "date", width: 30, style: { font: { size: 12, underline: false, bold: true }, alignment: { vertical: "middle", horizontal: "center" } } },
            { header: "Hour", key: "hour", width: 30, style: { font: { size: 12, underline: false, bold: true }, alignment: { vertical: "middle", horizontal: "center" } } },
            { header: "Runtime(runtime)", key: "runtime", width: 30, style: { font: { size: 12, underline: false, bold: true }, alignment: { vertical: "middle", horizontal: "center" } } },
            { header: "Stoptime(stoptime)", key: "stoptime", width: 30, style: { font: { size: 12, underline: false, bold: true }, alignment: { vertical: "middle", horizontal: "center" } } },
            { header: "Offline", key: "offline", width: 30, style: { font: { size: 12, underline: false, bold: true }, alignment: { vertical: "middle", horizontal: "center" } } },
            { header: "Stoppaage", key: "stoppage", width: 30, style: { font: { size: 12, underline: false, bold: true }, alignment: { vertical: "middle", horizontal: "center" } } },
        ];
        header_row.header = Header
0 Answers
Related