Tom R tnrn9b

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");;

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.

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.

	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();

	<?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+'