If you use Redis in your company, you know there’s valuable information flowing through it. It’s can be really useful to have that data easily available in Excel.
In this post you’ll learn how using Gridarrow allows you to:
What is Gridarrow?Gridarrow is the missing server for Excel. It connects just about any data source to Excel with simple Python scripts.
Why is it awesome?
- It's real-time, so as soon as the data is updated in the Gridarrow App it's updated in Excel, no need to poll or refresh.
- It's multi-user so your colleagues can connect to the same data at the same time.
- It simplifies your spreadsheets by moving data retrieval and pre-processing into Python.
Redis is one of the most useful components of the modern tech stack. Its unique in-memory data structure handling capabilities have allowed it to serve a huge range of use cases and industries. Redis is most often used for caching, queueing and Pub/Sub, but it also has modules for machine-learning, geospatial calculations and analytics.
Below is a simple example where we’ve connected to a Redis Pub/Sub channel carrying logistics data from a fleet of delivery drivers in London. Here’s how it works:
This is all that’s required to send the data to Excel!
For example, here’s a real time map of the vehicle’s locations.
To create this map, we’ve overlaid a scatterplot over a static image exported from Google Maps. We’ll write more about this technique in a later blog post.
Here’s the full code listing that we used to connect to the Redis Pub/Sub channel and stream the data to Excel.