JSFiddle - React, Tailwind, and code Playground

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>
<button onclick="exportToExcel()">
Export to excel
</button>
<div id="pivot-container"></div>

JavaScript

var jsonData = [{
  "Color": "green",
  "M": "September",
  "W": "Wed",
  "Country": "Canada",
  "State": "Ontario",
  "City": "Toronto",
  "Price": 857.50,
  "Quantity": 22
}];

var pivot = new Flexmonster({
  container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  report: {
    dataSource: {
      data: jsonData
    },
    formats: [{
      name: "Price",
      decimalSeparator: ",",
      decimalPlaces: 2
    }],
    slice: {
      rows: [{
        uniqueName: "Color"
      }],
      measures: [{
        uniqueName: "Price",
        format: "Price"
      }]
    }
  },
});

function exportToExcel() {
	pivot.exportTo("excel");
}