schleifer (Google Spreadsheets backend)

JSONP & Google Spreadsheetz to retrieve dataz

by edwardsharp

HTML

<div id="results"></div>

JavaScript

var spreadsheet_id = '1NMXiuYIwO8oIGFV1bneO4bIQA-VqvZz8h1CEyk5YL0s';
var url = 'https://spreadsheets.google.com/feeds/cells/'+spreadsheet_id+'/od6/public/values?alt=json-in-script&callback=?';

var onSuccess = function(data) {
    var html = "";
    var entries = data.feed.entry;
    
    for (var i=0, len = entries.length; i<len; ++i) {
        html += entries[i].content.$t + ' ';
        if ((i + 1) % 3 == 0) {
            html += '<br/>';
        }
    }
    
    $('#results').html(html);
}

$.getJSON(url, cellEntries);

function cellEntries(json) {
  var table = document.createElement('table');
  table.setAttribute('id', 'output');
  var tbody = document.createElement('tbody');
  
  var tr;
  var thead;
  
  for (var i=0; i < json.feed.entry.length; i++) { 
    var entry = json.feed.entry[i];
    
    if (entry.gs$cell.col == '1') {
      if (tr != null) {
        tbody.appendChild(tr);
      }
      tr = document.createElement('tr');
    }
    
    var td = document.createElement('td');
    td.appendChild(document.createTextNode(entry.content.$t));
    tr.appendChild(td);
  } 
 
  tbody.appendChild(tr);
  table.appendChild(tbody);
  document.getElementById('results').appendChild(table);
}