Skip to content
Advertisement

Add row in google Spreadsheet with javascript

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?

Advertisement

Answer

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:

enter image description here

Output:

enter image description here

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement