search

jpillora / node-edit-google-spreadsheet

A simple API for editing Google Spreadsheets
304 stars 101 forks source link

Append Row #105

Open gusarov opened 6 years ago

gusarov commented 6 years ago

How can I append next row without downloading entire table? AFAIK google api allows this via spreadsheets.values.append But with this module the only thing that works for me now is 

const [rows, info] = await sheet.receive();
sheet.add({
    [info.nextRow]: [['data']],
});
await sheet.send();

This downloads entire table and becoming slower and slower...

jpillora commented 6 years ago

Yeah it's a limitation. Append will need a PR On Tue, 2 Jan 2018 at 11:11 pm Dmitry Gusarov notifications@github.com wrote:

How can I append next row without downloading entire table? AFAIK google api allows this via spreadsheets.values.append But with this module the only thing that works for me now is

const [rows, info] = await sheet.receive(); sheet.add({

}); await sheet.send();

This downloads entire table and becoming slower and slower...

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/jpillora/node-edit-google-spreadsheet/issues/105, or mute the thread https://github.com/notifications/unsubscribe-auth/AAmr8-RZnCbJG2ozL_N2fvN5AF5MlzP0ks5tGh0AgaJpZM4RQjMe .