brucemcpherson

// this will return data from a public scraperwiki table as json
// you call like this - ?shortname=xyz&limit=x&fielda=x&fieldy=y etc... where fielda refers to the name of a field in the scraperwiki table
// see ramblings.mcpher.com for more info
function doGet(e) {
  // lets decode the arguments
   var content = "";
   if (!e.parameter) {
     content = {error: "parameters not found"} ;
   }
   else if (!e.parameter.shortname) {

brucemcpherson

'gistThat@mcpher.com :do not modify this line - see ramblings.mcpher.com for details: updated on 14/11/2013 18:02:03 : from manifest:3414394 gist https://gist.github.com/brucemcpherson/3414216/raw/cCell.cls
' a data Cell - holds value at time of loading, or can be kept fresh if there might be formula updates
Option Explicit
' Version 2.04 -
'for more about this
' http://ramblings.mcpher.com/Home/excelquirks/classeslink/data-manipulation-classes
'to contact me
' http://groups.google.com/group/excel-ramblings
'reuse of code
' http://ramblings.mcpher.com/Home/excelquirks/codeuse

brucemcpherson

<gistThat info="this is a manifest for gistThat VBA code distribution  - see ramblings.mcpher.com for details">
<manifest description="restlibrary associated classes and modules" contact="bruce@mcpher.com">
<gists>

        <item3 gistid="3423912" version="" filename="cBrowser.cls" module="cBrowser" type="class"/>
        <item1 gistid="3423885" version="" filename="restLibrary.vba" module="restLibrary" type="module"/>
        <item18 gistid="b72f7a826d553fb46cfa" version="" filename="cDbab.cls" module="cDbab" type="class"/>
        <item19 gistid="b72f7a826d553fb46cfa" version="" filename="cDbabResult.cls" module="cDbabResult" type="class"/>

        <item2 gistid="3423885" version="" filename="cRest.cls" module="cRest" type="class"/>

brucemcpherson

/** @description
 * javaScript/Google Apps script functions that are equivalent to common VBA functions
 * in general these provide the same functionality and have the same calling stack
 * See http://ramblings.mcpher.com/Home/excelquirks/codeuse for more details
 * @author <a href="mailto:bruce@mcpher.com">Bruce McPherson</a><a href="http://ramblings.mcpher.com"> ramblings.mcpher.com</a>
 */

/**
 * Removes leading and trailing whitespace
 * @param {string|number} v the item to be trimmed 

brucemcpherson

'gistThat@mcpher.com :do not modify this line - see ramblings.mcpher.com for details: updated on 8/18/2014 3:54:19 PM : from manifest:7471153 gist https://gist.github.com/brucemcpherson/3414346/raw
Option Explicit
' v2.23  3414346

' Acknowledgement for the microtimer procedures used here to
' thanks to Charles Wheeler - http://www.decisionmodels.com/
' ---


#If VBA7 And Win64 Then

brucemcpherson

N4IgbghgNgrgpiAXKAzgCwgDxUg2qjJEAZggAYA2MgFgBMBWCe26gTmrgoCYB2ZgY1oAzWvwBG9OKzgRitVvTJCm9EABoQAS1pFSlGgyYt2nXgOGiJUmXIVKV6kACc4ABwD2AMRhQoAOQgAWwREEDQAF1cogHoKADoyAE8YJxg0GAB3CEd+dwA7cLgCpFBwzWCALXyQkABBFE0IaIAVdwBrRPdHWjcinrz+TTgcZABfDThMfjcy/IAZdwBzRc08xaIAZWbagGEAaQARACUASQA1AFEjx1SC8rgzuCcG/KIzgA4QUfGCbNCeIT0VhCMhiIT8HgUVgKYgARggYi4YlhfHoPDIPDgIiEXAoEGk7y4rFhjm0RABQJBYIhUJh8MRyNR6Mx2Nx+LghOJNzcXh8/iCNQAEnAju4ALLuaKLCAoAC04XctHcmhQ4Ry+UKxWQIDKlWqRHqjRa7U63V6eX6g2GJXGIEm01cszyC2Wq3WoS2u0Op0u1w0t11DyeLzyb0+3zUv10/CEsNoXGoPFoxF4NB4xDI4kxFGoymJEFh1HeZAgTC4ynIpJ0oWIMbjCaTKfRiYzWc4ufx8MLxdL9HLpbI3I83l8AWCRAlgU0ACtNJp+GhNItJYEwGg5UExDKUBAlU5ZUIXOhgnlZYsnO4YK5ZegYEIhFA4LLXBfp3B+GqNLkCkU1drA1UeQ1LUwROPOTR+HAGQAPoAJruE4bRmq4fRFFaIzALa9ozJo8xLCsaybNs+zHOcVw3DAdzBI8zy4aGoQfF8PwgOgfwgO81Cwlwu7UPQfHsMQ7xiD2XD0GI1BkBm1D8BwZDlmI0hcEiihVkQHFcTxfFAtQgnCSWoniZJNAyXAclCApcBKRIg7+jyI78uOoS0OUmjhGBspgCgUoyje4QQE4hROOqP5aqU9yAcBoHgdEkEwfBiEUVRQa0a8DGfBoPQoRaaFDBhWFTDheGuoRHrEd6ZHXBGUahMwWLEKwxA4hA0xidpEAcWQtA8OiBbKWwkl0GQrBJqpNU

brucemcpherson

'gistThat@mcpher.com :do not modify this line - see ramblings.mcpher.com for details: updated on 15/10/2013 10:52:06 : from manifest:5055578 gist https://gist.github.com/brucemcpherson/3423885/raw/cRest.cls
' This is a generalized class for dealing with rest queries
Option Explicit
' v2.13
'for more about this
' http://ramblings.mcpher.com/Home/excelquirks/classeslink/data-manipulation-classes
'to contact me
' http://groups.google.com/group/excel-ramblings
'reuse of code
' http://ramblings.mcpher.com/Home/excelquirks/codeuse

brucemcpherson

'gistThat@mcpher.com :do not modify this line - see ramblings.mcpher.com for details: updated on 28/02/2013 09:55:55 : from manifest:3414394 gist https://gist.github.com/brucemcpherson/3414615/raw
' this is all about colors
Option Explicit
' v2.7   3414615

Public Type colorProps
    ' this is a single type to hold everything i know how to calculate about a color
    rgb As Long
    red As Long
    green As Long

brucemcpherson

<gistThat info="this is a manifest for gistThat VBA code distribution  - see ramblings.mcpher.com for details">
    <manifest description="cDataset and associated classes and modules" contact="bruce@mcpher.com">
        <gists>
            <item1 gistid="3414216" version="" filename="cCell.cls" module="cCell" type="class" />
            <item2 gistid="3414216" version="" filename="cDataSet.cls" module="cDataSet" type="class" />
            <item3 gistid="3414216" version="" filename="cDataSets.cls" module="cDataSets" type="class" />
            <item4 gistid="3414216" version="" filename="cDataColumn.cls" module="cDataColumn" type="class" />
            <item5 gistid="3414216" version="" filename="cDataRow.cls" module="cDataRow" type="class" />
            <item6 gistid="3414216" version="" filename="cHeadingRow.cls" module="cHeadingRow" type="class" />
            <item7 gistid="3414346" version="" filename="" module="usefulStuff" type="module" />

brucemcpherson

Option Explicit
'v1.1 - 5116003
Private Function testTableToHtml()
    Dim content As String, fn As String, _
        sheetName As String, maxrows As Long, styles As String, _
        outputType As String
    ' an example of how to use these
    ' you could make a form or dialog to set these up
    ' name of worksheet containing the data
    sheetName = "sankey"