njoerd114 · October 3, 2024 18:38 · Penteas · Mar 4, 2024 · red-adi · Oct 3, 2024
diff --git a/README.MD b/README.MD
diff --git a/code.gs b/code.gs
 function onOpen() {
    SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
        .createMenu('Zusatzfunktionen')
        .addItem('SankeyDiagram', 'openDialog')
        .addToUi();
 }

 function getSpreadsheetData() {
    // ID of your Document, take from URL
    var ssID = "",
        // which Sheet? [0] is the first and so on...
        sheet = SpreadsheetApp.openById(ssID).getSheets()[0],
        data = sheet.getDataRange().getValues();
    return data;
 }

 function openDialog() {
    var html = HtmlService.createHtmlOutputFromFile('index')
        .setHeight(300)
        .setWidth(1000);
    SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
        .showModalDialog(html, 'Sankey Diagram');
 }
diff --git a/index.html b/index.html


 <!DOCTYPE html>
 <html>
   <head>
      <base target="_top">
      <script src="https://www.google.com/jsapi"></script>
   </head>
   <body>
      <div id="main"></div>
      <script type="text/javascript">
         google.load('visualization', '1', {
           packages: ['corechart', 'sankey']
         });      google.setOnLoadCallback(initialize);
           
           function initialize() {
            google.script.run.withSuccessHandler(drawChart).getSpreadsheetData();
           }
           
           function drawChart(rows) {
             console.log(rows);
             var data = google.visualization.arrayToDataTable(rows);
             var chart = new google.visualization.Sankey(document.getElementById('main'));
             chart.draw(data, {width: 900, sankey: {iterations: 64}});
           }
      </script>
   </body>
 </html>
	function onOpen() {
	SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
	.createMenu('Zusatzfunktionen')
	.addItem('SankeyDiagram', 'openDialog')
	.addToUi();
	}

	function getSpreadsheetData() {
	// ID of your Document, take from URL
	var ssID = "",
	// which Sheet? [0] is the first and so on...
	sheet = SpreadsheetApp.openById(ssID).getSheets()[0],
	data = sheet.getDataRange().getValues();
	return data;
	}

	function openDialog() {
	var html = HtmlService.createHtmlOutputFromFile('index')
	.setHeight(300)
	.setWidth(1000);
	SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
	.showModalDialog(html, 'Sankey Diagram');
	}


	<!DOCTYPE html>
	<html>
	<head>
	<base target="_top">
	<script src="https://www.google.com/jsapi"></script>
	</head>
	<body>
	<div id="main"></div>
	<script type="text/javascript">
	google.load('visualization', '1', {
	packages: ['corechart', 'sankey']
	}); google.setOnLoadCallback(initialize);

	function initialize() {
	google.script.run.withSuccessHandler(drawChart).getSpreadsheetData();
	}

	function drawChart(rows) {
	console.log(rows);
	var data = google.visualization.arrayToDataTable(rows);
	var chart = new google.visualization.Sankey(document.getElementById('main'));
	chart.draw(data, {width: 900, sankey: {iterations: 64}});
	}
	</script>
	</body>
	</html>