Posted By

asimmittal on 02/06/13

Tagged

google json apps docs spreadsheets

Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

db_snipplr
icecreamboyy

Google Docs Spreadsheet Rows to JSON

/ Published in: JavaScript

URL: http://hackonista.blogspot.com/2013/02/scripting-in-your-spreadsheets.html

This snippet takes all the rows from your google spreadsheet and turns it into JSON, which can be copied to the clipboard. You can run this as part of the Google Docs scripting environment.

Highlighted TextExpand

/*
 * create a simple container that shows the string argument
 * in a text box
*/

function dumpDataIntoUI(data){
  
  //the white container is the app
  var app = UiApp.createApplication();
  app.setHeight(480);
  app.setWidth(640);
  
  //we want a nice label with the title of the script
  var label = app.createLabel("All Rows to JSON");
  label.setStyleAttribute("font-size","24");
  label.setStyleAttribute("font-weight","bold");
  label.setStyleAttribute("padding-bottom", "25px");
  
  //next, we will add the text box and fill it with the string argument  
  var text = app.createTextArea();
  text.setHeight(400);
  text.setWidth(640);
  text.setValue(data);
  text.setSelectionRange(0, data.length);
  
  //add all the widgets into the app and show it
  app.add(label);
  app.add(text);
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  spreadsheet.show(app);
}

/*
 * function to actually grab all the rows and put them
 * into a JSON string.
*/

/**
 * Adds a custom menu to the active spreadsheet, containing a single menu item
 * for invoking the readRows() function specified above.
 * The onOpen() function, when defined, is automatically invoked whenever the
 * spreadsheet is opened.
 * For more information on using the Spreadsheet API, see
 * https://developers.google.com/apps-script/service_spreadsheet
 */
function onOpen() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var entries = [
    {
      name : "All Rows to JSON",
      functionName : "rowsToJson"
    }    
  ];
  
  sheet.addMenu("My Scripts", entries);
};

Report this snippet Tweet

Comment:

You need to login to post a comment.

Posted By

Tagged

Versions (?)

Who likes this?

Google Docs Spreadsheet Rows to JSON

Related snippets

Choose a language for easy browsing: