Error in google apps script - Array

Question

May I get some help on googlescript? This script is actually downloading responses from typeform into googlesheet. I have an issue in downloading.

error message:

incorrect range width, was 11 but should be 12 At this line:

doc.clearContents();

doc.getRange("A1:L" + array.length).setValues(array);

Serge insas · Accepted Answer · 2016-10-27 21:42:56Z

1

instead of hardcoding a part of your range definition try using a more reliable method like this :

doc.getRange(1,1,array.length, array[0].length).setValues(array);

if your array is right then it will work flawlessly .

answered Oct 27, 2016 at 21:42

Serge insas

46.9k7 gold badges113 silver badges135 bronze badges

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

1 Answer 1