Google Sheets, writing array to sheet via script

Question

I've a sheet which I'm using arrays in the script (to save on time)

I have no problems writing a 2d Array to my sheets, however for some reason I can't get a 1D array to write properly

This is a screenshot in debug mode of my array. It's just a list of prices (500 rows)

This is my code (I added in the log to show the counts)

Logger.log (costPerItem.length) 
shWorkspace.getRange(1,12,costPerItem.length,1).setValues(costPerItem);

I just want to put the data into the 12th column on the tab that I've called shWorkspace earlier in the code.

But I get the error:

Exception: The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues.

And I can't figure out why.

I've used almost identical code:

shProductData.getRange(1,1,fullDataArrayProducts.length,fullDataArrayProducts[0].length).setValues(fullDataArrayProducts)

To apply a 2d array and this works fine

Cooper · Accepted Answer · 2022-05-23T19:44:45.493

2

Posting a flattened array as a column

let a = CostPerItem.map(e => [e]);
sheet.getRange(1,1,a.length, a[0].length).setValues(a);

function lfunko() {
  const ss = SpreadsheetApp.getActive();
  const sh = ss.getSheetByName("Sheet0");
  let CostPerItem = ["Cost Per Item", 1, 2, 3, 4, 5];
  let a = CostPerItem.map(e => [e]);
  sh.getRange(1, 1, a.length, a[0].length).setValues(a);
}

Cost Per Item
1
2
3
4
5

edited May 23 '22 at 19:44

answered May 23 '22 at 19:39

Cooper

59,616
6
23
54

That worked .what does e => [e] do? – Michael Liew May 23 '22 at 19:45
Go look at it in your debugger. Once you figure it out it will be worth your time. Knowing the structure of a spreadsheet is valuable to your future programming – Cooper May 23 '22 at 19:47

Google Sheets, writing array to sheet via script

1 Answers1

Posting a flattened array as a column