2021年1月7日星期四

Google Sheet + App script: How to loop for each with an array

Hi I'm trying to get a script that will run some code for each name on a list created from my 'sheet1' column 'A2:A'

1. get the list from Column A2:A  2. run code for each name from the list  

Here's my code but it's not working properly I don't think the array is populating properly

function test(){  var sheet = SpreadsheetApp.getActive().getSheetByName('sheet1');  var list = sheet.getRange('A2:A').getValues();  var a = [list];  a.forEach(function(entry) {          //do something     });  }  
https://stackoverflow.com/questions/65621420/google-sheet-app-script-how-to-loop-for-each-with-an-array January 08, 2021 at 07:30AM

没有评论:

发表评论