Skip to content

scottbw/Google-SpreadSheet-to-D3-Dataframe

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 

Repository files navigation

Google-SpreadSheet-to-D3-Dataframe

Converts Google Spreadsheet JSON into an array usable with D3

To use it, fetch Google Spreadsheet data using the JSON API (e.g. using the JSONP method), and call this function like so:

var dataframe = mapEntries(data,row_length,skip);

Where:

data is the JSON object returned from the API

row_length allows you to specify whether to restrict the data set to only rows with this number of cells (useful for ommitting summary rows), or set this to null to return rows of any number of cells.

skip is the number of rows to skip at the beginning of the spreadsheet.

The function will return an array of arrays (i.e. a two-dimensional array) representing the spreadsheet cells. This makes it much easier to then process the cells using D3js.

About

Converts Google Spreadsheet JSON into an array usable with D3

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published