Add row in google Spreadsheet with javascript

Question

Adds the value below the line created earlier. I'm trying to get me to add a line at "2:2" and put the value on that line, and the other values stay below. The maximum result I got so far was to make the new line erase the old one and paste the new value in the same field.

var Sheet1 = SpreadSheet.getSheetByName("Sheet1");
  
  var LastRow = Sheet1.getLastRow();

  
  Sheet1.getRange(LastRow+1, 1).setValue(name);

Any solutions to add a line and paste the values in 2:2 and the old values underneath?

NightEye · Accepted Answer · 2021-11-27 19:52:46Z

2

Use insertRowAfter()

Script:

function myFunction() {
  var SpreadSheet = SpreadsheetApp.getActiveSpreadsheet();
  var Sheet1 = SpreadSheet.getSheetByName("Sheet1");
  // insert row at row 2, moving all rows below the first row down a single row
  Sheet1.insertRowAfter(1);
  var name = [['1.5']];
  // then write data at row 2
  Sheet1.getRange(2, 1, name.length, name[0].length).setValues(name);
}

Sample data:

Output:

answered Nov 27, 2021 at 19:52

NightEye

11.3k2 gold badges8 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add row in google Spreadsheet with javascript

1 Answer 1

Script:

Sample data:

Output:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Script:

Sample data:

Output:

Comments

Your Answer

Sign up or log in

Post as a guest

Related