Data is likely to be one of the most, if not THE most valuable assets your business has.
API’s are the keys to that data. They are hence poised, to become an increasingly valuable part of your business.
Excel is one of the best consumers of API’s on the market. Hence it is very likely that you will want to use this power.
How API Connections work:
What are API’s
Example Of Using an API:
API’s and Excel
You can communicate with an API by sending and receiving text strings. The most common formats for these strings are known as JSON and REST .
Where we as developers, and Excel excel, with API’s is in building and format these strings in a dynamic and data contextual manner.
An Excel API connection is a classic example of Excel being a one-stop-shop for software solutions. We have direct experience of building fully automated applications that work in real time.
Excel & API Case Studies
Property Portfolio Management Spreadsheet We built the Property Portfolio Workbook for an estate agency that wanted to keep track of their clients portfolios of property investments. The idea was that the agent [...]
Environmental Modelling – Monitoring and Models Estimated driving times can play a vital role in spacial data analysis. Customer address lists can be fed into a GIS system and processed to find [...]
Environmental Modelling – Monitoring and Models There is a real need for mathematical models that simulate or model various environmental modelling systems, such as water or air quality. Environmental quality measurements [...]
Daily work orders updated automatically in Excel Drawing data from one spreadsheet and inserting it into another spreadsheet is a very common and time consuming process in the business environment. A [...]