Geo code from ip and host names Today’s API is a straightforward query per row, meaning that data is retrieved from the API using the contents of a column as the query. In this case […]
Get rxNorm drug data into Excel and Google Apps Script Aside from being a little specialized, today’s API is another quite unusual one. Normally apis allow you select the format of the output through a […]
Unlike Google Apps Script, which has a fine cloud based library capability, sharing and keeping code current for non-professional developers who use VBA is challenging. The use of add-ins for finished products with specific capabilities […]
Random Neil deGrasse Tyson quotes There’s probably no practical use to today’s API of the day, except that I am always amused by what he has to say. The other thing I wanted to look […]
Geocode and get administrative details and geoHash link from a UK postcode directly into an Excel or Google Spreadsheet Following on from the Yahoo GeoCode entry here’s another geoCoder – this time using UK post […]
On this blog, and on the ramblings site there is a growing number of code samples, but of course as things evolve, they get out of date. I started to write something to embed Gist samples in […]
In Starter implementation of R-melt for Excel I introduced a one liner in Excel/VBA to transform this into this You could consider this to be a kind of un-pivot – exploding tabulated data back into transactional […]
I came across ifttt.com (if THIS then THAT) the other day. Essentially it’s a simple way creating a trigger based on some event such as tweet mentioning you, or a facebook upload (THIS) and so […]
You have probably read that jSon works well with javaScript because ‘it is javaScript syntax’. Consider this javaScript (actually Google Apps Script). var items = {itema:1,itemb:’b’}; Logger.log (items.itema + “,” + items.itemb); We […]
Shorten URL API directly into an Excel or Google Spreadsheet Today’s API is from “ttb.li” which is a url shortening service. This is a query by row API, populating columns in a spreadsheet row using […]
Geocode with Yahoo API directly into an Excel or Google Spreadsheet Strictly speaking today’s API doesn’t really qualify as ‘API of the day’, since I’ve written about this before comparing a few geoCoding APIs. I’ve […]
In passing arguments in VBA using jSON I covered how you could use javaScript Object syntax to pass complex arguments to VBA procedures. Today I’ll cover how to pass complex arguments where there are optional values. […]
Data from CrunchBase API directly into an Excel or Google Spreadsheet Today’s API is another query type from “crunchbase” which is a free database of corporations, people and investors. Yesterday I showed you how to get […]
Data from CrunchBase API directly into an Excel or Google Spreadsheet Today’s API is from “crunchbase” which is a free database of corporations, people and investors. There are a number of types of query available in […]
Today’s API is “FAA airport status” – a dataSet query API, populating rows in a spreadsheet using the Airport IATA code as a key Here’s the Excel code (included in cDataSet.xlsm downloadable from the ramblings site) Public […]
In various posts such as this one, I’ve covered new entries to the REST library but it’s been kind of haphazard. Since I’m adding these regularly I figured I’d make a quick post like this for […]
Going back to the theme of ‘doing complicated things in one line of code’, here’s a mash up of cDataSet, Color Ramps, Mapping and various other things. Lets say we want to create a thematic […]
bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines