Exception error with 2D array size in Google Apps Script

Question

The exception is:

The number of columns in the data does not match the number of columns in the range. The data has 0 but the range has 3.

I want to populate a google spreadsheet with the three columns and the length of the threads. When I debug the program the arrays are empty. Is there another method that should be used to create a 2D array that can be used with the getrange?

function TheaThreads(){
 var SS =SpreadsheetApp.getActiveSpreadsheet();
 var ThreadSheet = SS.getSheetByName("Threads");
 var threads = GmailApp.getInboxThreads();
 var csNames = new Array();

   for (var i=0; i < threads.length; i++) {
    for (var j = 0; j < 
     threads[i].getMessages().length; j++){
  
     var message = threads[i].getMessages()[j],
     label = threads[i].getLabels(),
     ident = message.getId(),
     emailfrom = message.getFrom();
  
  //remove the name that comes with the email and pops the > at the end and store into str
   
      var str = emailfrom.split("<").pop();
      str=str.replace(">",'');
  // Label empty labels with "No Label"
      if(label==null|| label== undefined|| 
       label.length==0){
       label="No Label";
      }
     }

  //Push the ID, Label and FromEmail into 2D array
  
    csNames[j] = new Array();
    csNames[j][0]= ident;
    csNames[j][1]= label;
    csNames[j][2]=str; 
    Logger.log(csNames[j]);

    ThreadSheet.getRange(2, 1, csNames.length, 
    csNames[j].length).setValues(csNames);

Cooper · Accepted Answer · 2021-04-29 21:34:50Z

1

This runs for me:

 function TheaThreads() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sh = ss.getSheetByName("Sheet1");//changed
  var threads = GmailApp.getInboxThreads();
  var csNames = [['id','label','from']];//changed

  for (var i = 0; i < threads.length; i++) {
    for (var j = 0; j < threads[i].getMessages().length; j++) {
      var message = threads[i].getMessages()[j],
        label = threads[i].getLabels().map(l=>{return l.getName()}).join(','),
        ident = message.getId(),
        emailfrom = message.getFrom();//changed
      var str = emailfrom.split("<").pop();
      str = str.replace(">", '');
      if (label == null || label == undefined ||
        label.length == 0) {
        label = "No Label";
      }
    }
    csNames.push([ident,label,str]);
  }
  sh.getRange(1, 1, csNames.length, csNames[0].length).setValues(csNames);//moved
}

edited Apr 29, 2021 at 21:34

answered Apr 29, 2021 at 20:30

Cooper

64.2k7 gold badges29 silver badges65 bronze badges

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

2 Comments

Martimus Over a year ago

I took it out of the for loop and get the same error with csNames[ j ].length, and a "cannot read property 'length' of undefined" error with csNames[0].length.

Cooper Over a year ago

Take a look at it again. I added some code to label because it was returning a GmailLabel Array

Collectives™ on Stack Overflow

Exception error with 2D array size in Google Apps Script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related