Google Apps Script - Converting column of data into an array

Question

I have a program that works as below

function test() {
var urls = [
    'URL1, 
    'URL2',
    'URL3'
  ]

var results = xx(urls)

^and then xx works its magic and produces results.

Now I want to input the urls via a column in a spreadsheet instead of hard coding them into the script, and so I tried

 function test() {
    var urls = []
    var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Input")
    urls[0] = ss.getRange(2, 1, ss.getLastRow()-1,1).getValues().join()
    
    var results = xx(urls)

But the result is that only one of the URLs gets processed.

Marios · Accepted Answer · 2021-01-28 19:58:01Z

3

Explanation:

You haven't provided what this magical xx function does, but according to the first code snippet, xx accepts a single array of elements.

Therefore, one way of going from 2D array to 1D is to use flat

Solution:

function myFunction() {
  const ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Input")
  const urls = ss.getRange(2, 1, ss.getLastRow()-1).getValues().flat(); // 1D array
  const results = xx(urls);
}

answered Jan 28, 2021 at 19:58

Marios

27.5k9 gold badges40 silver badges59 bronze badges

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

2 Comments

user10553622 Over a year ago

Thank you for the reply! Unfortunately flat() doesn't seem to work with Google apps scripts?

Marios Over a year ago

@user10553622 enable v8 environment and it will work..... Google on how to enable v8 environment : developers.google.com/apps-script/guides/v8-runtime

user10553622 · Accepted Answer · 2021-01-30 19:51:33Z

0

Not sure this is the most elegant solution, but got it to work by modifying it:

function test() {
var urls = {}
var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Input")
urls = ss.getRange(2, 1, ss.getLastRow()-1,1).getValues();
urls = [].concat.apply([], urls)

var results = xx(urls)

answered Jan 30, 2021 at 19:51

user10553622

211 silver badge6 bronze badges

Collectives™ on Stack Overflow

Google Apps Script - Converting column of data into an array

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related