summaryrefslogtreecommitdiff
path: root/www/lib/vis/examples/graph3d/playground/csv2datatable.html
diff options
context:
space:
mode:
Diffstat (limited to 'www/lib/vis/examples/graph3d/playground/csv2datatable.html')
-rw-r--r--www/lib/vis/examples/graph3d/playground/csv2datatable.html80
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>