In various posts I have covered ways to get data in and out of Excel and other PC based systems. The latest capability I have looked at is being able to get data live into Excel from Google Docs.
Following previous developments on hiding data in excel objects, Excel jSon conversion and dynamic forms I figured it was time to combine all these threads, and have implemented all that as an integrated solution as […]
I have already looked at geocoding with Bing Maps -vs- Google Maps and Google Maps is a clear winner. Yahoo Placemaker is pretty good at first glance even though it claims not to be a […]
In a previous post I covered how you could use the Google Maps Api to complete and parse addresses for subsequent mapping directly from Excel. In the name of fairness, I implemented the same thing […]
Comments are closed.
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
Looks like Google have just tweaked their wire protocol a little to be more jSON friendly – specifically the key/value pairs now have a quoted keys – so for example what used to say table:[ now says "table":[ .
I modified the cDataSet downloadable example file today that is the subject of this article to work with this new Google wire format.
https://ramblings.mcpher.com/Home/excelquirks/downloadlist
Bruce