A streaming interface for Google Spreadsheets that allows you to batch write and read worksheet cells.
npm install google-worksheet-stream
Returns a worksheet object with a property for each of the three levels of abstraction: cells
, rows
, and objects
.
This constructor takes three arguments:
token
(required): A token instance from google-oauth-jwt-stream.spreadsheetId
(required): The 44-character ID of the spreadsheet, as found in its URL.worksheetId
(options): The ID of the worksheet within the spreadsheet, defaulting tood6
.
Returns a readable object stream of the cells in the worksheet. Each cell emitted has two properties:
key
: a[row, column]
array of numbers identifying the cellvalue
: a string or number representing the cell value
The options
object is not required, and can take the following properties, as documented in the fetch API:
minRow
: the minimum row returned, inclusivemaxRow
: the maximum row returned, inclusiveminCol
: the minimum column returned, inclusivemaxCol
: the maximum column returned, inclusive
Returns a writable object stream of the cells in the worksheet, with the same spec as the readable stream above.
Returns a readable object stream of the rows in the worksheet. This is an abstraction on top of the cells
interface in which cells are grouped by row. Each row emitted has two properties:
key
: a number identifying the rowvalue
: an object with column numbers as keys and cells as values.
The options
object is not required, and can take the following properties:
minRow
: corresponds tominRow
in the cell APImaxRow
: corresponds tomaxRow
in the cell API
Returns a writable object stream of the rows in the worksheet, with the same spec as the readable stream above. This stream will also accept arrays as values, in which case keys will be incremented by one, so that the following rows are identical:
{key: 2, value: {1: "Jed Schmidt", 2: "@jedschmidt"}}
{key: 2, value: ["Jed Schmidt", "@jedschmidt"]}
Returns a readable object stream of the objects in the worksheet. This is an abstraction on top of the rows
interface, in which column numbers are replaced with attribute names obtained from the first row (the "header" row). Each row emitted has two properties:
key
: a number identifying the rowvalue
: an object with column names as keys and cells as values.
The options
object is not required, and can take the following properties:
minRow
: corresponds tominRow
in the cell API, but starting at 2, since row 1 is used as the header row.maxRow
: corresponds tomaxRow
in the cell API
Returns a writable object stream of the objects in the worksheet, with the same spec as the readable stream above.