Library name
OpenLayers
Difficulty
Low to medium
Returned value
Graphic object
Description
A high-performance, feature-packed library for creating interactive maps on the web.
Link
https://openlayers.org
Documentation
https://openlayers.org/en/latest/doc/quickstart.html
License
BSD-2-Clause
Library implementation
Go to 'Tools' menu, select 'Add library' (read more how to add library here)
Give a name to the library (OpenLayers), add required file/s:
Url 1: https://cdn.rawgit.com/openlayers/openlayers.github.io/master/en/v5.3.0/build/ol.js
CSS: https://cdn.rawgit.com/openlayers/openlayers.github.io/master/en/v5.3.0/css/ol.css
Add description (optional).
Click 'OK'.
Custom functions
To add a simple map in a spreadsheet create one simple function (read more how to add a custom function here):
OPENLAYERS
This function is only our proposal to deal with the library, but user can define their own function(s).
Function name
OPENLAYERS
Arguments
- longitude
- latitude
- zoom
Syntax
=OPENLAYERS(longitude, latitude, zoom)
Description
Calls the library function and returns the result as a map object.
Function body
Example
=OPENLAYERS(C5,E5,G5)
Example spreadsheet is shown below:
Get a copy of this spreadsheet
Read the full article