Incorrect range width error - Google Apps Script

Question

I need to copy an array of data from one file to another, it needs to be pasted into the destination sheet from column F:J, while in the source file the data is in columns A:D

function copyRange() {
var source = SpreadsheetApp.openById("xxx");
var ssheet = source.getSheetByName("Source"); 
var srow = ssheet.getLastRow();
var srange = ssheet.getRange(8, 1, srow, 5).getValues();
var destination = SpreadsheetApp.openById("yyy");
var dsheet = destination.getSheetByName("Destination");
var drange = dsheet.getRange(5, 6, srow, 10);
drange.setValues(srange);}

I keep getting the error "Incorrect range width, was 5 but should be 10" I assume (I'm a total and utter newbie) that this refers to the number of columns in the destination range, but I don't get why that should be 10 when the data in the source range is in 5 columns?

Shenshen · Accepted Answer · 2017-11-03 16:58:55Z

2

Actually, I just figured it out myself - the columns aren't counted from A, but from the first specified one. Changing the 10 to 5 in the destination fixed it. Sorry for wasting time

answered Nov 3, 2017 at 16:58

Shenshen

213 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Incorrect range width error - Google Apps Script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related