Tom R tnrn9b

Creating Multiple Buttons on Google Spreadsheet using Google Apps Script

This is a sample script for creating the multiple buttons on Google Spreadsheet using Google Apps Script.

Recently, I have got several contacts about this. I thought that when this is published, it might be useful for other users. So I published this sample script.

Sample script

Downloading Active Sheet in Google Spreadsheet as CSV and PDF file by Clicking Button

This is a sample script for downloading the active sheet in Google Spreadsheet to the local PC as a CSV file and a PDF file when a button on the side bar and the dialog is clicked. This is created with Google Apps Script and HTML&Javascript. In this post, the script of the previous post was modified.

Sample script

Please create new Google Spreadsheet and copy and paste the following scripts to the script editor. And please run openSidebar(). By this, the side bar is opened to the Spreadsheet.

We want to upload file to a server with POST HTTP request. We will use curl functions.


// data fields for POST request
$fields = array("f1"=>"value1", "another_field2"=>"anothervalue");

// files to upload
$filenames = array("/tmp/1.jpg", "/tmp/2.png");;

We want to upload file to a server with POST HTTP request. We will use curl functions.


// data fields for POST request
$fields = array("f1"=>"value1", "another_field2"=>"anothervalue");

// files to upload
$filenames = array("/tmp/1.jpg", "/tmp/2.png");;

First install Brew on your MAC

Setup Brew: ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
brew update
brew tap homebrew/dupes
brew tap homebrew/php
Install PHP 7.0.+ brew install php70
Install mcrypt: brew install mcrypt php70-mcrypt
Finally, install composer: brew install composer

	$factories = array(
	'Your\Namespace\ControllerName' => 'Your\Namespace\Factory\ControllerNameControllerFactory',
	...
	);

	$writeRouteFromControllerKey = static function (array $factories, $namespace)
	{
	$createRoute = static function (string $controller, array $actions) use ($namespace) {
	$controller = lcfirst($controller);
	$childRoutes = "";

	<?php

	// Trims whitespaces after any tags. Assumes that a tag ends with '/>', '\w>', '">'.
	$html = preg_replace('#(["\|\/\|\w]>)(\s+)#', '$1', $html);

	// Trims whitespaces before any tags. Assumes that tags start with '<\w+'
	$html = preg_replace('#(\s+)(<\/?\w+)#', '$2', $html);

	// Trims spaces between tags (both opening and closing).
	// Assumes that a tag ends with '/>', '\w>', '">' and starts with '<\w+'

	public static function generateInvoicePDF($row)
	{
	self::loadLanguage();

	require_once JPATH_ROOT . '/components/com_osmembership/tcpdf/tcpdf.php';
	require_once JPATH_ROOT . '/components/com_osmembership/tcpdf/config/lang/eng.php';

	$db = JFactory::getDbo();
	$query = $db->getQuery(true);
	$config = self::getConfig();

	/**
	* Sample of serverside generation of Highcharts using an extension to jsdom in node.js.
	*
	* Usage:
	* npm install jsdom
	* npm install highcharts
	* node highcharts-jsdom
	*/

	/* eslint-env node */

	(* author: Dimitur Krustev *)
	(* started: 20130616 *)
	(* based on: http://siek.blogspot.com/2013/05/type-safety-in-three-easy-lemmas.html *)

	Require Import Arith List Bool.

	Set Implicit Arguments.

	Section Lang.