SpreadsheetApp.openById error using appscript

Question

I'm importing data from one sheet to another sheet using Google Appscript. However when I run the code there's an error occuring.

function importdata() {
    var mainfile = SpreadsheetApp.getActive().getSheetByName('Data1');
    var secondfile = SpreadsheetApp.openById('1232131231231abcc').getSheetByName('RAW');
    var datas = secondfile.getRange('C:C').getValues();
    var paste = mainfile.getRange('A:A').setValues(datas);
}

Message details

Exception: The number of rows in the data does not match the number of rows in the range. The data has 27441 but the range has 27509. (line 6, file "Code")

Evgeny Vostok · Accepted Answer · 2019-08-23 08:31:56Z

4

setValues expects your range to have the same length as the length of data you are trying to set (must match dimensions of your range).

try something like

var datas = mainfile.getRange('A:A').getValues()

var range = secondfile.getRange(1,1,datas.length);
range.setValues(datas);

Update: I actually think you might have "hidden" rows in your dataset, this might cause range to be confused with length.

edited Aug 23, 2019 at 8:31

answered Aug 23, 2019 at 8:21

Evgeny Vostok

2451 silver badge11 bronze badges

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

1 Comment

Evgeny Vostok Over a year ago

Hi, check the udpate, please, if you have hidden rows - they were causing the issue, thus they are not copied to your second file if you use this method. Unhide them first.

Collectives™ on Stack Overflow

SpreadsheetApp.openById error using appscript

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related