adding a row to google sheet JavaScript

Question

I have a script that is used for a previous spreadsheet that adds a row to the table and keeps the formatting. I am trying to use this script on another sheet to do the same thing. The problem is that the row is being added in the incorrect location at the bottom of the page. What can I do to adjust where the new row is being added?

  // addRow.GS 
var ss = SpreadsheetApp.getActive();

function onOpen() {
  var menu = [{name:"Add New Last Row", functionName:"addRow"}];
  ss.addMenu("Extra", menu);
}

function addRow() {
  var s, data, rw;
  s=SpreadsheetApp.getActiveSheet();
  data=s.getDataRange().getValues();
  for (rw in data) {
    if (data[rw][6]=="Condition Description :") break;
  }
  s.insertRowBefore(Number(rw));
  s.getRange(Number(rw), 4, 1, 2).merge();
  s.getRange(Number(rw), 8).setFormula("=f"+Number(rw)+"*g"+Number(rw));
}



function myFunction() //Code.GS {

var ss = SpreadsheetApp.getActive();

function onOpen() {
  var menu = [{name:"Add New Last Row", functionName:"addFirstRow"}];
  ss.addMenu("Extra", menu);
}
function addFirstRow() {
    var firstRow = 1;
    var sh = ss.getActiveSheet();
    var lCol = sh.getLastColumn();
    var range = sh.getRange(firstRow, 1, 1, lCol);
    var formulas = range.getFormulas(firstRow, 1, 1, lCol);
    sh.insertRowsAfter(1, 1);
    newRange = sh.getRange(firstRow, 1, 1, lCol);
    newRange.setFormulas(formulas);

}
}

What are you trying to add? there is an appendRow method in the sheet object — Robin Gertenbach
– Robin Gertenbach, Commented Apr 12, 2017 at 20:44
onOpen is a reserved name in Google Apps Script. It should be used only once by project. — Wicket
– Wicket, Commented Apr 13, 2017 at 0:20

OblongMedulla · Accepted Answer · 2017-04-13 12:58:26Z

3

Here are a few examples:

var ss = SpreadsheetApp.getActive();

function onOpen() {
  var menu = [{name:"Add New Last Row", functionName:"addFirstRow"}];
  ss.addMenu("Extra", menu);
}

function addFirstRow() {
  var sheet = ss.getActiveSheet();
  sheet.appendRow(['This row']);

  // Insert one empty row after the last row in the active sheet.
  sheet.insertRowsAfter(sheet.getMaxRows(), 1);
  sheet.appendRow(['That Row']);
  
  
  // Shifts all rows down by one
  sheet.insertRows(1);
  
  // inserts a row at row 10
  sheet.insertRows(10);
  
}

answered Apr 13, 2017 at 12:58

OblongMedulla

1,60110 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

adding a row to google sheet JavaScript

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related