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
Order Tracking and Invoicing System We built the Order tracking and Invoicing system for a film processing agency that wanted to keep track of their clients orders as they passed through their [...]
Property Portfolio Management Spreadsheets Using Excel Dashboards, we built the property portfolio workbook for an estate agency, to help them to keep track of their clients’ property portfolios [...]
Environmental Modelling – Monitoring and Models Environmental modelling and monitoring with estimated driving times can play a vital role in spacial data analysis. Customer address lists can be fed into a GIS [...]
Environmental Modelling – Monitoring and Models There is a real need for mathematical models to simulate or model various environmental systems, such as water or air quality. [...]