Write a row to Google Spreadsheet programmically javascript
        Posted  
        
            by 
                Verber
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Verber
        
        
        
        Published on 2012-10-01T20:50:49Z
        Indexed on 
            2012/10/01
            21:37 UTC
        
        
        Read the original article
        Hit count: 255
        
JavaScript
|I'm trying to find a way to insert a row into a google spreadsheet dynamically. I have a list of objects that has all the data for every column in a row. I'm just trying to run a for loop and then send the data to the row in the spread sheet. But the spreadsheet is completely empty. So I don't know if that creates certain problems or not.
  for(var j=0; j < masterList.length; j++) {
        //tried this one but it didn't pan out
       sheet.appendRow([ masterList[j].Date, masterList[j].Name, masterList[j].Bugs,      masterList[j].Enhancements, masterList[j].Epic, masterList[j].DevOps, masterList[j].High ]);
   }
© Stack Overflow or respective owner