Web Services - Desktop Liberation

This site uses a lot of calls to Google APIs in order to connect Excel to web applications. There are a number of custom classes used everywhere such as Data Manipulation Classes and Excel JSON conversion which are tailored to friendliness with web applications.

Projects which use web services

Although XML is built into Excel, I tend to use jSon to exchange data with web services in all the examples in this site, especially since there are a number of javaScript versions of some of the capabilities developed on this site. The cJobject class is the main interaction between deserialized jSon and VBA.

Here are a selection of articles and examples where you can see and download examples of web service interaction using all of these classes, but the best place to start is probably with the examples in the cDataSet.xlsm workbook.

Adding markers to Ovi Maps from Excel

Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also been either removed or changed. Therefore, I had to remove all examples of VizMap applications I had created. I didn't remove the entire topic as I thought some of the ...

Adding markers to Bing Maps from Excel

Adding markers to Yahoo Maps from Excel

Adding markers to Google Maps from Excel

We've already looked at how to geoCode addresses using various APIs. Now lets look at using Google Maps to put markers on a Map using an Excel worksheet as input. As usual you can find the completed example in the googleMapping.xlsm download. Before running this please check the parameter worksheet and change the filename value ...

Complete Excel Address Data with Bing Maps API

GeoCode Excel Data with Bing Maps If you haven't read about Bing rules on doing this, please do. Since we have done this in Google Maps, I thought it would be worthwhile to see how it's done in Bing Maps. This all uses cDataSet to abstract data and make all this a trivial exercise. Quick ...

Embedding Google Motion Charts in Excel

What are google visualization charts Google provides a growing number of cool charts that are not available in Excel. For this article we are going to focus on the the Google Motion Visualizations. Please take a look here to become familiar with what they are. There are a number of ...

Serializing Excel data for Google motion charts

In a previous section , I explained how to create javascript to create a Google Motion Chart directly from your from Excel data, and optionally embed it in your workbook. Since it is of course possible to embed a Google chart gadget in a web page or a Google document, ...

General Google visualization tool

We previously looked at how to embed a motion chart in excel, as well as how to serialize data as input to one. As a matter of fact, the interaction with the visualization API and the format of the input data is rather standard across different kinds of charts, so ...

Using Twitter in Earth and Maps

Get Data from Google Books

What can you learn here? Use Google Books API Convert jSon Tailor columns and output Getting data about a book using the ISBN number. Get it now In this section we will look at how the Google Books API responds to a request for book details given an ISBN number ...

Complete Excel Address Data with Yahoo Placemaker Maps API

Cookies and Excel

Using cookies straight from Excel Get it now Why would you want to do this? You know what cookies are, and think of them as being a mechanism for web sites to store information about you so they can personalize your experience. As I've shown in other sections there are ...

Data Driven Mapping applications

Deprecated Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also been either removed or changed. Therefore, I had to remove all examples of VizMap applications I had created. I didn't remove the entire topic as I thought some of ...

Get Data from Outlook

How to get data into Excel from your outlook address book get it now Here's a common problem. You have a list of email addresses in Excel and you want to pick up various pieces of data from your contacts or global address list, matched on the email address. This ...

Complete Excel Address Data with Google Mapping API

Get Data From Google Docs

There have been a number of changes to Google Docs over the years each of which has provided more ways to do things. The latest is the new Sheets API V4,which is by far the best way to integrate Excel and Sheets. To see how to do that see Using the Google ...

Google Visualization

Create Google visualizations straight out of Excel. Here you can download a prebuilt application, googleCharts.xlsm that demonstrates how to integrate google Visualizations with Excel. The subsequent pages are about how to develop such an application and provides the tools you need to do it with. If you just want to ...

Rest to Excel library

What can you learn here? Library of Rest CallsPopulate excel tablesAdd your own A library to populate Excel tables with rest query results get it now I found myself writing similar code to deal with the growing number of Rest queries on this site such as Get Data from Google Books, Integrating Excel with ...

Excel to json and back

Before you start.. This is by far the most popular topic on this site. If you want to ask some questions, have difficulty with the downloads, or if this is not what you expected to find here, please leave a comment or ask a question on our Forum gadget to help improve the usefulness ...

Excel JSON conversion

Freeing Excel Data through JSON There have been a number of topics on this site dealing with the serialization of JSON, for example to create input to google visualizations, Hiding data in Excel Objects , Integrating Excel with Maps and Earth and a whole bunch of other Web Services. Whereas XML is built into Excel ...

jSon and Dynamic Forms

Now we know how about Hiding data in Excel Objects, Excel JSON conversion and Dynamic Forms let's combine all that as an enhancement to the Roadmap Generation project. The objective is to embed traceability data in the generated roadmap shapes so that we can bring up a dynamic form, allow changing of the data that made ...

Integrating Excel with Maps and Earth

What to download

All the examples contain all the classes needed for them to work and all projects can be found here.

If you just want the main utility classes used throughout this site, in the Downloads section cDataSet.xlsm includes everything you need including some examples. Here’s what you need.

Questions and feedback are always welcome at our forum. Continue reading about excel to Json or go back to the main page for more topics