JSFiddle - React, Tailwind, and code Playground

Export and print

by Flexmonster Pivot Table

HTML

<link rel="stylesheet" href="https://s3.amazonaws.com/flexmonster/2.3/demo.css">
<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<script src=" https://cdn.jsdelivr.net/npm/exceljs@4.4.0/dist/exceljs.min.js "></script>
<script src="https://cdn.jsdelivr.net/npm/file-saver/dist/FileSaver.min.js"></script>

<button onclick="excel()">Export to exсel</button>

<div id="pivot-container"></div>

JavaScript

let pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  report: {
    options: { grid: { type: "flat", showGrandTotals: "off" } },
    dataSource: {
      data: [
        {
          "Product ID": "0014633382556",
          "Product Name":
            "Gra PS3 Command and Conquer: Red Alert 3 Ultimate Edition (pyta Blu-ray_x000D_ ) (0014633382556)",
        },
      ],
    },
    slice: {
      columns: [{ uniqueName: "Product ID" }, { uniqueName: "Product Name" }],
    },
  },
})

function excel() {
  pivot.exportTo(
    "excel",
    {
      filename: `report`,
      excelSheetName: "Sheet1",
      destinationType: "plain",
    },
    function (result) {
      let workbook = new ExcelJS.Workbook()
      workbook.xlsx.load(result.data.buffer).then((workbook) => {
        workbook.eachSheet((sheet) => {
          sheet.eachRow((row) => {
            row.eachCell((cell) => {
              let value = cell.value.toString()
              // if (this.isValidUrl(value)) {
              //   cell.value = { formula: `HYPERLINK("${value}", "${value}")` };
              cell.value = value.replace(/(_x[0-9A-F]{4}_)/gmi, '_x005F$1');
              cell.style = JSON.parse(JSON.stringify(cell.style))
              cell.font = {
                ...cell.font,
                underline: true,
                color: { theme: 10 },
              }
              //   }
            })
          })
        })

        workbook.xlsx.writeBuffer().then((buffer) => {
          saveAs(
            new Blob([buffer], { type: "application/octet-stream" }),
            "report.xlsx",
          )
        })
      })
    },
  )
}