Take the complexity out of your spreadsheets by moving data retrieval and preprocessing to the cloud. No VBA required!
Gridarrow apps are simply Python scripts - this allows you to integrate Excel with just about any data source.
Gridarrow instantly sends updates to all clients to make sure everybody is looking at the same data.
We provide a simple
API for sending data to Excel from
Python - the
Grid. Update the Grid with a value
grid[row, column] = value and the data immediately appears in all users
The Python environment is unrestricted, and you can
install any dependencies you need
to get the job done.
from gridarrow import Arrow arrow = Arrow() grid = arrow.grid("ga_active_users", rows=10, columns=["Desktop", "Mobile"]) def get_ga_report(): # build analytics service not shown return analytics.get(ids=view_id, metrics='rt:pageViews', dimensions='rt:deviceCategory') # do something every 30 seconds @arrow.on_timer(period=30) def on_interval(): grid[0:10, ["Desktop", "Mobile"]] = get_ga_report()