Incorrect Range size after parsing .csv with the function from the GAS tutorial

Question

I'm using the csvToArray() compact version from this question and answer to write all of the rows as a single array to a range in a spreadsheet:
Access, parse, and write .csv data - google apps script

My issue is that I'm ending up with an empty array for the last "row" in the array after it has parsed my data, and it's causing an error to throw on the setValues line:

    sheet.getRange(1,1,arrData.length,arrData[0].length).setValues(arrData);`

The error I am getting is "Incorrect Range size, was 1, but should be 4. I've narrowed it down to the last "row" by looking at the debugger, which shows the last array in the set with as [""].

I've tried to parse arrData with:

    for (row in arrData){if(arrData[row] !=""){return(arrData[row])}}

And other similar methods (for if, while, etc), but can't quite figure out how to stop adding values to arrData if the row is blank.

Any suggestions?

You should preferably write your solution in an answer and mark it as answered. It won't give you any rep. points but it will be more visible and won't show up as "unanswered" (that was your intention wasn't it ?) — Serge insas
– Serge insas, Commented Feb 24, 2014 at 21:39
Yeah, it wouldn't let me do that for another 9 hours or so since I don't have much rep. I wanted to post an update so people wouldn't spend time answering it while I wait for the clock to tick away. — thoughtcrime
– thoughtcrime, Commented Feb 24, 2014 at 22:33

thoughtcrime · Accepted Answer · 2014-02-25 16:06:33Z

0

I added this block of code in the lines after csvToArray() was called, but I imagine that it would have been just as valid to add a variation of it just prior to the return arrData in the csvToArray() function:

  var csvAdd = [];
  for (var row in csvData){
    if (csvData[row] != ''){
      csvAdd.push(csvData[row]);
    }

  }
  Logger.log(csvAdd);
  cisSheet.getRange(1,1,csvAdd.length,csvAdd[0].length).setValues(csvAdd);

Leaving the question here if anyone else ever has a similar problem in the future.

answered Feb 25, 2014 at 16:06

thoughtcrime

2993 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

Incorrect Range size after parsing .csv with the function from the GAS tutorial

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related