0.1.1 • Published 10 years ago

google-spreadsheet-stream v0.1.1

Weekly downloads
-
License
-
Repository
-
Last release
10 years ago

Streaming API for Google Spreadsheets

A very basic streaming API for Google Spreadsheets.

Currently only read-only, supports only public spreadsheets.

Installation

npm install google-spreadsheet-stream

Basic Usage

const GoogleSpreadsheet = require('../index.js');

const testKey = '0AmBuTbmfT_ZudHBIY1FfbWUzU2pQSjgwX1VON09Gd3c';
const testSheetId = 'od6';

var spreadsheet = new GoogleSpreadsheet(testKey);

spreadsheet.getColumnHeaders(testSheetId)
  .on('data', function(data) {
    console.log('Column Headers: ' + data);
  })
  .on('end', function() {
    var currentRow = 1;
    spreadsheet.getRows(testSheetId)
      .on('data', function(data) {
        console.log('Row ' + currentRow + ': ' + data);
        currentRow++;
      });
  });

TODO

  • Allow authentication for private sheets
  • Add query functionality to getRows()
  • Add write functionality