Export Chart Data to Excel using SheetJS | CanvasJS JavaScript Charts

Export Chart Data to Excel using SheetJS | CanvasJS JavaScript Charts

by canvasjs

HTML

<script src="https://canvasjs.com/assets/script/canvasjs.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.14.0/xlsx.full.min.js"></script>
<br/><!-- Just so that JSFiddle's Result label doesn't overlap the Chart -->
<div id="chartContainer" style="height: 360px; width: 100%;"></div>
<button id="downloadExcel">Download Chart Data as Excel</button>

JavaScript

var chart = new CanvasJS.Chart("chartContainer", {
	title: {
  	text: "Exporting Chart Data as Excel using SheetJS"
  },
	data: [
	{
		type: "column",
		dataPoints: [
			{ x: 10, y: 71 },
			{ x: 20, y: 55 },
			{ x: 30, y: 50 },
			{ x: 40, y: 65 },
			{ x: 50, y: 95 },
			{ x: 60, y: 68 },
			{ x: 70, y: 28 },
			{ x: 80, y: 34 },
			{ x: 90, y: 14 }
		]
	}					
	]
});

chart.render();

document.getElementById("downloadExcel").addEventListener("click", function(){
  downloadAsExcel({ filename: "chart-data", chart: chart })
});

function downloadAsExcel(args) {
  var dataPoints, filename;  
  filename = args.filename || 'chart-data';

  dataPoints = args.chart.data[0].dataPoints;
  dataPoints.unshift({x: "X Value", y: "Y-Value"});
  var ws = XLSX.utils.json_to_sheet(dataPoints, {skipHeader:true, dateNF: 'YYYYMMDD HH:mm:ss'});
  if(!ws['!cols']) ws['!cols'] = [];
  ws['!cols'][0] = { wch: 17 };
  var wb = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(wb, ws, filename);
  XLSX.writeFile(wb, filename + ".xlsx");
}