node-google-spreadsheet
node-google-spreadsheet copied to clipboard
set backgroundColor for the new row
Hello, I am trying to add backgroundColor when the new row creates, but I can't make it work. I was able to set backgroundColor when I make some cell updates but I don't know how to apply it for the whole row.
I would really appreciate any help. Thank you in advance!
Here is the part of my code to add a row:
At the moment, the row-based API does not have access to any more advanced styling / formatting capabilities available. You'll have to use the cell-based methods to do it. Also, I have not implemented the "repeatCell" request which would allow updating a range of cells to a specific format. You'd have to update each cell in the row and then save the updated cells.
Adding some formatting to rows would be nice enhancement though... maybe soon
@theoephraim Thank you a lot for the reply! I'll try what you recommend