Error with loop in Google Sheets Script

Question

I am trying to write a script to delete columns by passing an array of column numbers getting error

Cannot find method deleteColumns((class))

I'm pretty sure this is the problem

for (var i = 0; i <= arr.length; i++){
      sheet.deleteColumns(arr[i]);
      };

Thanks for any help on this

function DMC_n(){
   DMC('Elements', [1,2]);  
}

function DMC(shtName, arr){
  var sheet =  SpreadsheetApp.getActiveSpreadsheet().getSheetByName(shtName);
  var range = sheet.getDataRange();
  var values = range.getValues();

  for (var i = 0; i <= arr.length -1; i++){
      sheet.deleteColumns(arr[i]);
      };
}

nbkhope · Accepted Answer · 2018-01-08 17:56:55Z

1

Your function DMC() defines three parameters, where the last one, "arr", is not given from your function call:

DMC('Elements', [1,2]);

So the third argument is undefined.

answered Jan 8, 2018 at 17:56

nbkhope

7,5144 gold badges44 silver badges59 bronze badges

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

3 Comments

xyz Over a year ago

Ops. Thanks, I repurposed a script and left that in there by mistake. I edited my question. Now getting error Cannot find method deleteColumns((class))

nbkhope Over a year ago

The issue is just as says. The object sheet does not have that method. Why don't you try console logging sheet and see what's inside?

xyz Over a year ago

This was the problem (var i = 0; i <= arr.length; i++) changed to (var i = 0; i <= arr.length -1; i++) and now works

Collectives™ on Stack Overflow

Error with loop in Google Sheets Script

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related