insert array in Range

[Maik Uhlig]

Hi,

I am searching for the syntax to insert an array into a Range.

For example:

array: data_ar=['Hungary','Germany','England','USA');

The result should be:

         A                 B                 C

1  Hungary

2  Germany

3  England

4  USA

5  

I can solve it with a for-loop and getRange().setValue(), but there a more than thousand values and the loop will take to many time. 

Is there a direct syntax, like getRange('A1').setValue(data_ar)?

Thanks for help

[Darren D'Mello]

sheet.getRange("A1:A4).setValues(

[

['Hungary']',

[Germany'],

['England'], 

['USA']

]

);

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/743dc69e-f674-4da4-9f0d-f757bd93a33bn%40googlegroups.com.

[Marco Pires]

Yes, you can use the getRange().setValues(). In your case:

data_ar=['Hungary','Germany','England','USA');

getRange('A1:A4').setValues(data_ar);

The size of the two-dimensional array must match the size of the range.

Have a nice day.

[Maik Uhlig]

Hello, thanks for help. But the result is:

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

I tried this example!

I made a screenshot.

Any ideas?

[Marco Pires]

Ops...  sorry, the array has to be two-dimensional. Like this:

data_ar=[ ['Hungary','Germany','England','USA] ];

getRange('A1:D1').setValues(data_ar);

In your example: 

data_ar=[ ['Hungary'], ['Germany'], ['England'], ['USA'] ];

getRange('A1:A4').setValues(data_ar);

[Maik Uhlig]

THANK YOU VERY MUCH! Now, it works!