OpenLayers

OpenLayers

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

//create temporary container for graphic manipulations
var garbageContainer;
if (!document.getElementById('garbageContainer')) {
 garbageContainer = document.createElement('div');
read more >>

3Dmol library

3Dmol

Library name 3Dmol
Difficulty Medium (intermediate JavaScript knowledge required)
Returned value Graphic object
Description WebGL accelerated JavaScript molecular graphics library.
Link https://github.com/3dmol/3Dmol.js
Documentation http://3dmol.csb.pitt.edu/doc/index.html
License BSD-3
Library implementation
  • Go to ‘Tools’ menu, select ‘Add library’ (read more how to add library here)
  • Give a name to the library (3DMol), add required file:

Url 1: https://cdnjs.cloudflare.com/ajax/libs/3Dmol/1.3.7/3Dmol-nojquery-min.js

  • Add description (optional). 
  • Click ‘OK’.
Custom functions

There are different graphic objects offered by this library. We will use one of them for this example (read more how to add a custom function here):

  • MOLA

This function is only our proposal to deal with the library, but user can define their own function(s).

Function name DMOLA Arguments – dataset Syntax =DMOLA(dataset) Description

Calls the library function and returns the result as an graphic object. Dataset is a data bank model and is loaded from server.

Function body

//create temporary container for graphic manipulations
var garbageContainer;
if (!document.getElementById('garbageContainer')) {
 garbageContainer = document.createElement('div');
read more >>