Add Library To Spreadsheet

You are here:

There are thousands of JavaScript and CSS libraries available to be used for free. You can find them on different repositories (just to mention CDNJS, jsDeliv, Google Hosted Libraries). When a library is added to the spreadsheet, user can create their own custom function that uses the functions/methods/classes provided by the library and thus extend the functionality of the spreadsheet. It can be a simple function that returns an alphanumerical value, but it also can be an advanced graphical function that shows a chart or a drawing. The scope and variety of use is limitless.

So, how to start?

In menu ‘Tools’ select ‘Add library’.

Add library

The library is already added. You can add as many libraries as you want to the spreadsheet, but please bear in mind that every new file takes some memory resources and you can end up with a very slow working spreadsheet, therefore use it with caution.

The next step is to create a custom function (if you don’t know how to do it – read it here). The body of a function can look like this:

var a = library_namespace.function1(argument1, argument2, ...); //function1 returns a string or number
return a;

And that’s it. More advanced and real-life examples will be added on a regular basis. Stay with us!