Jessica Lord, open web developer—designer

Sheetsee.js v3.0

  • By Jessica Lord
  • 2014-02-28
  • Open Source, Sheetsee.js


I've just updated Sheetsee.js with new features and all new docs. I've been waiting to ship this, it feels like, for far too long. I’m hoping now Sheetsee is at a solid enough place that I can focus spare time on making more fork-n-go examples.

I'll get straight to the most exciting point: the new sample data for the demos is of my flattened penny collection. Below are the other things.

New Features


Tables: Pagination, Multi Table Sorting and Filtering

Tables can now be paginated so that you don’t have to display your entire spreadsheet of data in one go. Unless you want to.

Tables now supports having multiple tables with sorting and filtering. So long as you keep your table IDs straight, you’re golden.

See: table demo

Maps: Polygons and Lines

Maps now support polygons and lines. So long as you have the correct coordinate structure in your cells, Sheetsee will add them to the geoJSON it creates for your maps. More details for coordinates of lines and polygons in geoJSON are here, but briefly:

A linestring:

[-122.41722106933594, 37.7663045891584], [-122.40477561950684, 37.77695634643178]

A polygon:

[-122.41790771484375, 37.740381166384914], [-122.41790771484375, 37.74520008134973], [-122.40966796874999, 37.74520008134973],[-122.40966796874999, 37.740381166384914], [-122.41790771484375, 37.740381166384914]

A Multipolygon:

[[-122.431640625, 37.79106586542567], [-122.431640625, 37.797441398913286], [-122.42666244506835, 37.797441398913286],[-122.42666244506835, 37.79106586542567], [-122.431640625, 37.79106586542567]],
[[-122.43352890014648, 37.78197638783258], [-122.43352890014648, 37.789031004883654], [-122.42443084716797, 37.789031004883654], [-122.42443084716797, 37.78197638783258], [-122.43352890014648, 37.78197638783258]]

See: map demo.


I redid the documentation and website for Sheetsee. Instead of one gigantic readme file/website, all of the different elements are given their own file/page. Now you can find docs, demos, tips and such all filed away nicely here in the repository and on the website.


The other big thing that has happened to Sheetsee is that I've taken each component (core, maps, tables and charts) and made them into their own Node.js module. This makes for smaller, more manageable code files and it makes it so that users can build their own version of Sheetsee with just the elements they want to use. For instance, if you're only making maps, just build a Sheetsee with the map component.

All builds come with the sheetsee-core module which contains all of the data organizing functions.

The module sheetsee is a command line module that builds your custom sheetsee for you.

If you're not interested in Node modules or building anything, that's ok, too. I'll always keep a full build (with all the components) here in the sheetsee.js repository (which from here on out exists to be the consolidated documentation and source of a full build).

If you need to file an issue for a bug or feature, try and file it on the repository with the component it relates to (they each have their own repository now):