API call exportTo

Export and print

by abufiddle

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="html()">Export to HTML</button>
<button onclick="csv()">Export to CSV</button>
<button onclick="excel()">Export to Excel</button>
<button onclick="image()">Export to image</button>
<button onclick="pdf()">Export to PDF</button>
<div id="pivot-container"></div>

JavaScript

var pivot = new Flexmonster({
	container: "pivot-container",
  componentFolder: "https://cdn.flexmonster.com/",
  width: "100%",
  height: 430,
  report: {
    dataSource: {
      data: getData()
    },
    options: {
			configuratorActive: false
    }
  }
});

function html() {
  var params = {
    filename: 'flexmonster'
  };
  flexmonster.exportTo('html', params);
}

function csv() {
  var params = {
    filename: 'flexmonster'
  };
  flexmonster.exportTo('csv', params, 
    function(result) {console.log(result.data)}
  );
}

function excel() {
  var params = {
    filename: 'flexmonster',
    excelSheetName: 'Report',
    showFilters: true
  };
  flexmonster.exportTo('excel', params);
}

function image() {
  var params = {
    filename: 'flexmonster'
  };
  flexmonster.exportTo('image', params);
}

function pdf() {
  var params = {
    filename: 'flexmonster',
    header:"<div>##CURRENT-DATE##</div>",
    footer:"<div>##PAGE-NUMBER##</div>",
    pageOrientation: 'landscape'
  };
  flexmonster.exportTo('pdf', params);
}

function getData() {
  return [{
    "Color": "green",
    "M": "September",
    "W": "Wed",
    "Country": "Canada",
    "State": "Ontario",
    "City": "Toronto",
    "Price": 174,
    "Quantity": 22
  }, {
    "Color": "red",
    "M": "March",
    "W": "Mon",
    "Time": "1000",
    "Country": "USA",
    "State": "California",
    "City": "Los Angeles",
    "Price": 1664,
    "Quantity": 19
  }, {
    "Color": "red",
    "M": "January",
    "W": "Mon",
    "Country": "Canada",
    "State": "Quebec",
    "City": "Montreal",
    "Price": 1190,
    "Quantity": 292
  }, {
    "Color": "green",
    "D": "04/08/2014",
    "M": "August",
    "W": "Fri",
    "Time": "1000",
    "Country": "USA",
    "State": "California",
    "City": "Los Angeles",
    "Price": 1222,
    "Quantity": 730
  }, {
    "Color": "white",
    "M": "March",
    "W": "Wed",
    "Country": "USA",
    "State": "California",
    "City": "Los Angeles",
    "Price": 7941,
   ...