Skip to content

Instantly share code, notes, and snippets.

View harshsharma94's full-sized avatar

Harsh Sharma harshsharma94

  • Gojek
View GitHub Profile
var KEY_COLUMN = 0;
var VALUE_COLUMN = 1;
var DIALOG_TITLE = 'Exported JSON';
var MENU_TITLE = "Export JSON";
var MENU_ENTRY_ITEM_TITLE = "Export Key Values as JSON";
// Invoked when Script is initialized
// We should inflate menu items in the menu bar now
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
@harshsharma94
harshsharma94 / DisplayJSONFromSheet.gs
Created August 13, 2020 20:10
Display some Key and Value in Google SpreadSheet as JSON in Dialog
var KEY_COLUMN = 0;
var VALUE_COLUMN = 5;
var DIALOG_TITLE = 'Exported JSON';
var MENU_TITLE = "Export JSON";
var MENU_ENTRY_ITEM_TITLE = "Export Key Values as JSON";
// Invoked when Script is invoked
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var menuEntries = [
// 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.
var FORMAT_ONELINE = 'One-line';
var FORMAT_MULTILINE = 'Multi-line';
var FORMAT_PRETTY = 'Pretty';
var LANGUAGE_JS = 'JavaScript';
var LANGUAGE_PYTHON = 'Python';
@harshsharma94
harshsharma94 / AutomateDeepLinks.py
Last active June 4, 2020 07:28
Run deepLinks one after another on a connected debugging device