Wilhelm Mauch riveruniversity

Recently created

Least recently created

Recently updated

Least recently updated

nicobrx / to_util

Last active October 28, 2024 19:23

Google Apps Script utility functions for working with 2D arrays in Sheets/tabs, plus a few other miscellanea. The 2D functions depend on the first row of a tab being column headers and each row below the first row having the same number of columns as the first row.

	/*
	updated 2018-04-28
	source lives here: https://gist.github.com/nicobrx/2ecd6fc9ca733dcd883afebba5cf200e
	standalone script ID for use as a library: 1gZ78JObyrYiH0njoZ86fQ2NgMwavUgiXVhRDrIFetPZL256e31PSNiHq

	Functions included here:

	Sheets data array and object functions
	objectifySheet(sheet,propertyNames,newPropertyNames) - Takes a sheet with a header row and converts it into an array of objects
	arrayFromSheet(sheet,propertyNames,newPropertyNames) - creates an array from a sheet, can specify column headers

candycode / image-arraybuffer.js

Created March 7, 2014 15:24

Create a jpg image from ArrayBuffer data

	// Simulate a call to Dropbox or other service that can
	// return an image as an ArrayBuffer.
	var xhr = new XMLHttpRequest();

	// Use JSFiddle logo as a sample image to avoid complicating
	// this example with cross-domain issues.
	xhr.open( "GET", "http://fiddle.jshell.net/img/logo.png", true );

	// Ask for the result as an ArrayBuffer.
	xhr.responseType = "arraybuffer";