How do you resolve a “The parameters (number[]) don’t match the method signature for SpreadsheetApp.Range.setValues” error

by

setValues accepts(and getValues() returns):

  • 1 argument of type:
  • Object[][] a two dimensional array of objects

It does NOT accept a 1 dimensional array. A range is always two dimensional, regardless of the range height or width or both.

If A1:A2 is the range, then corresponding values array would be like:

  • [[1],[3]]

Similarly, A1:B1 would be

  • [[1,2]]

A1:B2 would be

  • [[1,2],[3,4]]

Notice how the two dimension provides direction and that it is always a 2D array, even if the height or width of the range is just 1.

Solution:

Push a 1D array to make the output array 2D.

Snippet:

vWriteTable.push(/*Added []*/["Yes"]);

More information:

For a more detailed explanation of arrays in google sheets, checkout my answer here.

More Related Contents:

  1. What does the range method getValues() return and setValues() accept?
  2. If value is true in Column A, set Column C one higher
  3. How much faster are arrays than accessing Google Sheets cells within Google Scripts?
  4. How to filter an array of arrays?
  5. How to maintain absolute cell address even when deleting ranges?
  6. How to turn off array range check [closed]
  7. Not all properties displayed
  8. How to protect the Apps Script code in a Google spreadsheet?
  9. How to convert VBA script to Google Apps Script automatically?
  10. MATLAB adding array elements iteratively: time behavior
  11. Remove an element from a Bash array
  12. How to return an array in bash without using globals?
  13. Swift: Pass array by reference?
  14. Google Sheets add-on: Set anonymous/dynamic functions to Menu using Google App Script
  15. Defining a function returning an array
  16. If char*s are read only, why can I overwrite them?
  17. Google App Scripts cannot be given Authorization or Permission
  18. How to add hashtable to multidimensional array? Cannot assign values via member-access enumeration
  19. How to speed ​up the search data in sheet
  20. Perl array vs list
  21. Increment Cell value by one by clicking
  22. Reorder array compared to another array in Swift [duplicate]
  23. Is there a way to not have to initialize arrays twice?
  24. Dumping whole array: console.log and console.dir output “… NUM more items]”
  25. How do I call New-Object for a constructor which takes a single array parameter?
  26. Access Array column in Spark
  27. convert string to number array in matlab
  28. How do I remove elements at a set of indices in a vector in MATLAB?
  29. Excel VBA Quickest way to sort an array of numbers in descending order?
  30. How can I store function pointers in an array? [duplicate]

Leave a Comment