JSFiddle - React, Tailwind, and code Playground

Export and print

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>
<button onclick="excel()">Export to excel</button>
<div id="pivot-container"></div>

CSS

@import url(https://cdn.flexmonster.com/assets/jsfiddle-styles.css);

JavaScript

const pivot = new Flexmonster({
  container: 'pivot-container',
  componentFolder: 'https://cdn.flexmonster.com/',
  toolbar: true,
  report: {
    dataSource: {
      filename: 'data/data.csv',
    },
    formats: [
      {
        name: 'decimalFormat',
      },
    ],
    slice: {
      reportFilters: [
        {
          uniqueName: 'Color',
          filter: {
            members: ['color.[blue]', 'color.[green]'],
          },
        },
        {
          uniqueName: 'Destination',
        },
        {
          uniqueName: 'Size',
        },

        {
          uniqueName: 'Country',
          filter: {
            members: ['country.[Australia]', 'country.[Canada]'],
          },
        },
      ],
      rows: [
        {
          uniqueName: 'Category',
        },
      ],
      columns: [
        {
          uniqueName: 'Business Type',
        },
        {
          uniqueName: '[Measures]',
        },
      ],
      measures: [
        {
          uniqueName: 'Price',
          aggregation: 'sum',
          format: 'decimalFormat',
        },
      ],
    },
  },
});

function excel() {
  pivot.exportTo('excel', {
    showFilters: true,
  });
}