mhawksey

function getJSON(aUrl,sheetname) {
  //var sheetname = "test";
  //var aUrl = "http://pipes.yahoo.com/pipes/pipe.run?_id=286bbb1d8d30f65b54173b3b752fa4d9&_render=json";
  var response = UrlFetchApp.fetch(aUrl); // get feed
  var dataAll = JSON.parse(response.getContentText()); //
  var data = dataAll.value.items;
  for (i in data){
    data[i].pubDate = new Date(data[i].pubDate);
    data[i].start = data[i].pubDate;
  }

johnwards

function lastValue(column) {
  var parts = column.split("!");
  if (parts.length == 2) {
    var sheetName = parts[0];
    var column = parts[1];
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
  } else {
    var column = parts[0];
    var sheet = SpreadsheetApp.getActiveSheet();
  }

mhawksey

function scheduledCollection(){
  var schedule = [];
  // dates/times in mm/dd/yyyy hh:mm - timezone matches settings in File > Project properties 
  schedule.push({start:"08/29/2012 15:00", end:"08/29/2012 16:00"});
  schedule.push({start:"08/29/2012 20:00", end:"08/29/2012 22:00"});
  checkCollect(schedule);
}

function checkCollect(schedule){
  var now = new Date();

daaain

/**
 * Adds a custom menu to the active spreadsheet, containing a single menu item
 * for invoking the exportJSON() 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();

beezly

function zeroCells() {
  var ss=SpreadsheetApp.getActiveSpreadsheet();
  var sheet=ss.getSheets()[0];
  var selection=sheet.getDataRange();
  var columns=selection.getNumColumns();
  var rows=selection.getNumRows();
  for (var column=1; column < columns; column++) {
    for (var row=1; row < rows; row++) { 
      var cell=selection.getCell(row,column);
      if (cell.isBlank()) {

Integralist

var str = "The quick brown fox jumped over the box like an ox with a sox in its mouth";

str.match(/\w(ox)/g); // ["fox", "box", "sox"]

// match (when used with a 'g' flag) returns an Array with all matches found
// if you don't use the 'g' flag then it acts the same as the 'exec' method.

str.match(/\w(ox)/); // ["fox", "ox"]
/\w(ox)/.exec(str);  // ["fox", "ox"]

nylen

function inject(src, callback) {
    if (typeof callback != 'function') callback = function() { };
    
    var el;
    
    if (typeof src != 'function' && /\.css[^\.]*$/.test(src)) {
        el      = document.createElement('link');
        el.type = 'text/css';
        el.rel  = 'stylesheet';
        el.href = src;

mogsdad

SheetConverter library (formerly "Spreadsheet to HTML")

This is the source repository for the SheetConverter Google Apps Script library.

Libary documentation is available here.

Caveats

This script is incomplete, ignoring some types of formatting. (Feel free to fork and enhance it, if you wish! Broadly applicable enhancements can be merged and the library updated) There are also some known issues:

vs4vijay

function getDataFromXpath(path, url) {
  var data = UrlFetchApp.fetch(url);
  var text = data.getContentText();
  var xmlDoc = Xml.parse(text, true);
  
  // Replacing tbody tag because app script doesnt understand.
  path = path.replace("/html/","").replace("/tbody","","g");
  var tags = path.split("/");
  Logger.log("tags : " + tags);
  // getting the DOM of HTML

Strikeskids

// ==UserScript==
// @name       Youtube Download Video
// @namespace  http://www.strikeskids.com
// @version    0.05
// @description  Creates a download button on youtube videos to enable them to be downloaded
// @match	http*://*.youtube.com/watch*v=*
// @copyright  2014+, Strikeskids
// @require http://code.jquery.com/jquery-latest.js
// @run-at document-end
// @author Strikeskids