API call exportTo

Export and print

by Flexmonster Pivot Table

HTML

<script src="https://cdn.flexmonster.com/flexmonster.js"></script>

<button onclick="pdf()">Export to PDF</button>
<button onclick="excel()">Export to Excel</button>
<button onclick="html()">Export to HTML</button>
<button onclick="csv()">Export to CSV</button>
<button onclick="image()">Export to image</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/",
  report: {
    dataSource: {
      filename: "data/data.csv",
    },
    slice: {
      rows: [
        {
          uniqueName: "Category",
        },
      ],
      columns: [
        {
          uniqueName: "Country",
          filter: {
            members: [
              "country.[canada]",
              "country.[france]",
              "country.[united states]",
            ],
          },
        },
        {
          uniqueName: "[Measures]",
        },
      ],
      measures: [
        {
          uniqueName: "Price",
          aggregation: "sum",
        },
      ],
      reportFilters: [
        {
          uniqueName: "Business Type",
          filter: {
            members: ["business type.[warehouse]"],
          },
        },
      ],
    },
  },
});

function pdf() {
  const params = {
    filename: "flexmonster",
    header: "##CURRENT-DATE##",
    footer: "<div style='color:#df3800'>##PAGE-NUMBER##</div>",
    fontUrl: "https://cdn.flexmonster.com/fonts/NotoSansCJKtc-Regular.ttf",
    pageFormat: "A5",
    pageOrientation: "landscape",
  };
  pivot.exportTo("pdf", params);
}

function excel() {
  const params = {
    filename: "flexmonster",
    header: "First header row\nSecond header row",
    footer: "Table Footer",
    excelSheetName: "Report",
    showFilters: true,
  };
  pivot.exportTo("excel", params);
}

function html() {
  const params = {
    filename: "flexmonster",
    header: "##CURRENT-DATE##",
    footer: "<div style='color:#df3800'>Table Footer</div>",
  };
  pivot.exportTo("html", params);
}

function csv() {
  const params = {
    filename: "flexmonster",
    header: "First header row\nSecond header row",
    footer: "Table Footer",
    alwaysEnclose: true,
    fieldSeparator: ";",
  };
  pivot.exportTo("csv",...