Google Apps Script: Adding text at a certain position

Asked Dec 22 '21 at 15:09

Active Dec 22 '21 at 15:09

Viewed 37 times

I'm trying to insert a array of text at certain position with google apps script.

For example: In row 2 I need to add the name Mike with city Detroit. What I tried is appending the row with the data and deleting the row before it. This is a messy solution to my problem.

Is there a method which can take a rownumber as a parameter and add text to that row?

asked Dec 22 '21 at 15:09

Chester

2

Sheet.getRange(row,col).setValue(); – Cooper Dec 22 '21 at 15:34
2

or `my_sheet.getRange('B3:C3').setValues( [ ['Mike', 'Detroit'] ] )` – Yuri Khristich Dec 22 '21 at 15:41

Google Apps Script: Adding text at a certain position

0 Answers0