Skip to content

Instantly share code, notes, and snippets.

@RyanRusnak
RyanRusnak / gist:853680d68527a1172be7b7fa7eef2518
Created June 21, 2017 22:16
Google sheet to React table
import React, { Component } from 'react';
import logo from './logo.svg';
import './App.css';
class App extends Component {
componentDidMount(){
fetch('https://spreadsheets.google.com/feeds/list/YOUR_KEY/3/public/values?alt=json').then(
response => {
response.json().then(data => {
@RyanRusnak
RyanRusnak / gist:773a93562511a6f6bfa7a069ae3f0f19
Created June 20, 2017 17:48
SDSW google sheets scripting
// ========== Sheet setup ==========
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Calculator");
var dimensionSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("dimensions");
// ========== Getters ==========
function fromAddress(){
return sheet.getRange("B2").getCell(1, 1).getValue();
}
@RyanRusnak
RyanRusnak / gist:fd2f2361a117dbd1b4e62dec27b8edf5
Last active June 22, 2017 16:35
google sheet helper functions
var SHEET = SpreadsheetApp.getActiveSheet();
function toArray(){
var arr = SHEET.getRange("A1:D1").getValues()[0];
Logger.log(arr);
}
function toMatrix(){
var hash = SHEET.getRange("A3:B5").getValues();
Logger.log(hash);
@RyanRusnak
RyanRusnak / gist:355f017618b73fcb55dd
Created September 26, 2014 14:57
mutable_role_spec.rb
require 'rails_helper'
describe MutableRole do
describe 'before_destroy' do
context 'immutable roles' do
let!(:admin) { MutableRole.create(name: 'admin') }
let!(:moderator) { MutableRole.create(name: 'moderator') }
let!(:member) { MutableRole.create(name: 'member') }
class UserpostsController < ApplicationController
# GET /userposts
# GET /userposts.xml
def index
@userposts = Userpost.all
respond_to do |format|
format.html # index.html.erb
format.xml { render :xml => @userposts }
end