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
没有评论:
发表评论