Can I pass an array into a Google App Script method from a Google Spreadsheet?
arrays, google-apps-script, google-sheets, google-sheets-custom-function, javascript
Solution
In a spreadsheet formula, you can construct an embedded array using curly braces. Semi-colons are row delimiters; commas (or backslashes in locales that use a comma for the decimal separator) are column delimiters.
Now when such embedded arrays are passed to Google Apps Script, they are converted to a 2-dimensional Javascript array, just like referenced ranges are.
So:
`=myFunc({1,2})`
`=myFunc({1;2})`
function myFunc(value)
{
}
In the first formula, `value` will be `[[1, 2]]`. In the second, it will be `[[1], [2]]`.
Problem
Can I pass an array into a Google App Script method from a Google Spreadsheet? Suppose I have an App Script function that expects a list with two elements (note: this example is just an example so please do not tell me that my problem would be solved if I simply passed each element as a separate argument). How do I call this function from a Google Spreadsheet cell? I've tried both: '=myFunc([1,2])' and '=myFunc((1,2))' and both give me a Parse Error.