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