Maksim Petruk bulleet

florentdescroix / exportjson.js

Last active January 29, 2024 23:26 — forked from pamelafox/exportjson.js

Google Spreadsheet JSON ExportHow-to at http://blog.pamelafox.org/2013/06/exporting-google-spreadsheet-as-json.html

	const EMPTY_VALUE = undefined;

	// Includes functions for exporting active sheet or all sheets as JSON object (also Python object syntax compatible).
	// Tweak the makePrettyJSON_ function to customize what kind of JSON to export.

	function onOpen() {
	var ss = SpreadsheetApp.getActiveSpreadsheet();
	var menuEntries = [
	{name: "Export JSON for this sheet", functionName: "exportSheet"},
	{name: "Export JSON for all sheets", functionName: "exportAllSheets"}

chrislkeller / import_json_appsscript.js

Last active March 25, 2024 19:45

Adds what amounts to an =ImportJSON() function to a Google spreadsheet... To use go to Tools --> Script Editor and add the script and save.

	/**
	* Retrieves all the rows in the active spreadsheet that contain data and logs the
	* values for each row.
	* For more information on using the Spreadsheet API, see
	* https://developers.google.com/apps-script/service_spreadsheet
	*/
	function readRows() {
	var sheet = SpreadsheetApp.getActiveSheet();
	var rows = sheet.getDataRange();
	var numRows = rows.getNumRows();