jpillora/node-edit-google-spreadsheet

Feature: Row API (List-based Feeds)

Open

#59 aberto em 12 de fev. de 2015

Ver no GitHub
 (0 comments) (0 reactions) (0 assignees)JavaScript (98 forks)github user discovery
enhancementhelp wanted

Métricas do repositório

Stars
 (302 stars)
Métricas de merge de PR
 (Métricas PR pendentes)

Description

Looking for Contributors Please look through these notes and then the source and if you decide to give this a shot, mention that you're working on this in the comments below and I'll give you push access.


Currently, this module only uses cell-based feeds, though there is also a row-based REST API: https://developers.google.com/google-apps/spreadsheets/#working_with_list-based_feeds. I haven't researched too deep into the REST API, though I think it would result in a module API like:

//add a new 'row' property
spreadsheet.rows.get(function(err, rows) {
  //get all rows
});

spreadsheet.rows.query({my:"query"}, function(err, rows) {
  //get specific rows
});

spreadsheet.rows.add({name:"foo",age:25}, function(err, newRow) {
  //insert a row
});

//each of the row objects above have:
row.update({name:"bar"}, function(err) {
   //updates this row inplace
});
row.delete(function(err) {
  //deletes this row and shifts up
});

Read through the docs and comment on the proposed API above, I may have missed something.

If the worksheets API feature is also being done, the rows object would a go inside each worksheet, and then be aliased from spreadsheet.

Guia do colaborador