Hi dnnrg26,

This forum is for questions regarding AdWords API only. Your question does 
not look specific to the AdWords API. Please contact relevant mailing list.


-Danial, AdWords API Team.


On Thursday, August 9, 2012 3:08:07 PM UTC+4, dnrg26 wrote:
>
> hi some one please advise me;;
>
> var filter = 
> SpreadsheetApp.openById("0AhioeCK_-aU4dENCVjViWVhhdkZrdF92MElOTWhpWFE").getSheetByName("Sales").getRange("D2").getValue();
>  
> //Only Filter that row which is matching wiht D2
>   Logger.log("getDataRange().getValues() data is " + data);
>   for (var i = 1; i < data.length; i++ )
>     {
>      if (filter.test(data[i][3]) == filter )
>       
> dest.push([data[i][0],data[i][1],data[i][2],data[i][3],data[i][4],data[i][5],data[i][6],data[i][7],data[i][74]]);
>     }
>   //Logger.log(dest);
>   if( dest.length > 0 ) {
>     archive.insertRowsBefore(5,dest.length);
>     archive.getRange(5,1,dest.length,dest[0].length).setValues(dest);
>   }
> }
> //Irror : The coordinates or dimensions of the range are invalid. (line 
> 6)Dismiss//
>
>

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en

Reply via email to