This library is aimed at people who need to work with large (several thousand rows) Google spreadsheets.
To achieve this end, it does three things differently than most comparable libraries:
- It uses streams so that at no point must all the spreadsheet rows be loaded into memory.
- It lets the consumer of the stream determine just how many rows to return.
- It leverages Google's API to allow for querying based on conditions.
Installation
npm install google-spreadsheet-stream-reader
Example
var gsStreamFactory = factory; var gsReadStream = gsStreamFactory //use HTTPS //return only 10 rows //only return rows where name is Terrence; //Set up expressvar express = ;var router = express;var app = ; router; app;app;
TODO
Some kind of writable stream, but that will probably be a separate module. Can you imagine how cool it would be to be able to do this:
var gsReader = gsStreamFactory;var gsWriter = gsStreamFactory; ;