diff options
| author | Pliable Pixels <pliablepixels@gmail.com> | 2017-09-21 12:49:18 -0400 |
|---|---|---|
| committer | Pliable Pixels <pliablepixels@gmail.com> | 2017-09-21 12:49:18 -0400 |
| commit | b28028ac4082842143b0f528d6bc539da6ccb419 (patch) | |
| tree | 1e26ea969a781ed8e323fca4e3c76345113fc694 /www/lib/vis/examples/graph3d/playground/csv2datatable.html | |
| parent | 676270d21beed31d767a06c89522198c77d5d865 (diff) | |
mega changes, including updates and X
Diffstat (limited to 'www/lib/vis/examples/graph3d/playground/csv2datatable.html')
| -rw-r--r-- | www/lib/vis/examples/graph3d/playground/csv2datatable.html | 80 |
1 files changed, 80 insertions, 0 deletions
diff --git a/www/lib/vis/examples/graph3d/playground/csv2datatable.html b/www/lib/vis/examples/graph3d/playground/csv2datatable.html new file mode 100644 index 00000000..08d3c65d --- /dev/null +++ b/www/lib/vis/examples/graph3d/playground/csv2datatable.html @@ -0,0 +1,80 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> +<html> +<head> + <title>Convert CSV to Google Datatable</title> + + <style> + body {font: 10pt arial;} + </style> + + <script type="text/javascript" src="http://www.google.com/jsapi"></script> + <script type="text/javascript" src="csv2array.js"></script> + + <script type="text/javascript"> + var data = null; + var graph = null; + + function loaded() { + + } + + google.load("visualization", "1"); + + // Set callback to run when API is loaded + google.setOnLoadCallback(loaded); + + // Called when the Visualization API is loaded. + function convert() { + var csv = document.getElementById("csv").value; + + var datatable = ""; + + // parse the csv content + var csvArray = csv2array(csv); + + // Create and populate a data table. + datatable += "data = new google.visualization.DataTable();\n"; + + // read the header row + for (var col = 0; col < csvArray[0].length; col++) { + datatable += "data.addColumn('number', '" + csvArray[0][col] + "');\n"; + } + + // read all data + for (var row = 1; row < csvArray.length; row++) { + datatable += "data.addRow(["; + + for (var col = 0; col < csvArray[row].length; col++) { + if (col != 0) + datatable += ", "; + datatable += csvArray[row][col]; + } + + datatable += "]);\n"; + } + + document.getElementById("datatable").value = datatable; + + alert(csvArray.length + " rows converted"); + } + </script> +<script>(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,document,'script','//www.google-analytics.com/analytics.js','ga');ga('create', 'UA-61231638-1', 'auto');ga('send', 'pageview');</script></head> + +<body> +<div id="graph"></div> + +<div id="info"></div> + +<b>CSV</b><br> +<textarea id="csv" style="width: 400px; height: 300px;"></textarea> +<br> +<br> +<input type="button" value="Convert" onclick="convert();"> +<br> +<br> + +<b>Google DataTable</b><br> +<textarea id="datatable" style="width: 400px; height: 300px;"></textarea> + +</body> +</html> |