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",
)
})
})
},
)
}