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: 148

Filed under:
|

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

Related posts about JavaScript

Related posts about google