Library name Flag-Icon-CSS
Difficulty None
Returned value Graphic object
Description A collection of all country flags in SVG.
Link https://github.com/lipis/flag-icon-css
Documentation https://github.com/lipis/flag-icon-css
License MIT
Library implementation
  • Go to ‘Tools’ menu, select ‘Add library’ (read more how to add library here)
  • Give a name to the library (Flag-Icon-CSS), add required file:

CSS: https://cdnjs.cloudflare.com/ajax/libs/flag-icon-css/3.3.0/css/flag-icon.min.css

  • Add description (optional). 
  • Click ‘OK’.
How to use this library?

Add a flag in the cell(s) by adding a div, span or element with flag-icon and flag-icon- class, where code read more >>

Add library

Add Library To Spreadsheet

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’.

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!