node-google-spreadsheet icon indicating copy to clipboard operation
node-google-spreadsheet copied to clipboard

Edit an existing row by sending the row number

Open JoakoV3 opened this issue 2 years ago • 1 comments

I have been searching about editing fields of an existing row by sending the row number. I know this can be done with cells by sending the specific cell but is there a way to send an array or object to edit a row completely?

Apprecciate your help. Thanks in advance.

JoakoV3 avatar Apr 05 '22 21:04 JoakoV3

This module is not really set up for that at the moment, but you might be able to do something hacky

  • load a single row
  • clone it
  • change the _rowNumber property to the row in question (A1 style row, ie first row is 1, not 0)
  • update the values, call save

theoephraim avatar May 14 '22 05:05 theoephraim

Closing this for now. Please reopen if the above workaround wasn't workable.

theoephraim avatar Jun 26 '23 18:06 theoephraim