Using setValues()

[Dirk]

Hi,

I have some trouble with writing an array to a range of cells.

function go(){

var xy = [];

for(i=0; i<12; i++){

xy[i] = i;

}

Geodata.getRange("Z2:Z13").setValues(xy);

}

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

Can you help?

[Bennett, Scott]

I think you need to define xy as

xy=[[]]

--
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/99c24477-e936-4f7d-b82d-5d6d685f9476n%40googlegroups.com.

[Dirk]

No, this is not the issue.

[CBMServices Web]

Set Values is expecting a 2 dimensional array but you xy array is one dimensional.

Try this:

function go(){

var xy = [];

for(i=0; i<12; i++){

xy[i][0]= i;

}

Geodata.getRange("Z2:Z13").setValues(xy);

}

[Dirk]

This leads to the error: TypeError: Cannot set property '0' of undefined

[Bennett, Scott]

Is this what  you want for the array?

function go(){

var xy = [];

for(i=0; i<12; i++){

xy.push([i]);

}

Logger.log(xy)

}

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/0765bace-c14e-422b-8e0b-1a0c760141fcn%40googlegroups.com.

--

Scott Bennett

Data and Assessment Coordinator/Math Teacher

Bradley-Bourbonnais Community High School

P 815.937.3707 ext. 6010

C 708.584.0872

[CBMServices Web]

I never liked the way arrays are defined in javascript.

Try this:

function go(){

var xy = [];

for(i=0; i<12; i++){

xy[i]=[ i];

}

Geodata.getRange("Z2:Z13").setValues(xy);

}

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/22b60eef-16c0-453d-9588-0e16bf8f1434n%40googlegroups.com.

[Dirk]

This is working! Great! Thank you!

[Dirk]

This is also working! Thank you!