Displays data arrays with appendrow where other columns contain data

Question

I wrote a script to display a list of names and folder IDs.

The script that I wrote like this:

function listFolders() {

var sheet = SpreadsheetApp.getActiveSheet();
  sheet.getRange('A2:B').clear();
  //sheet.appendRow(["Name", "Folder-Id"]);

var folderID = DriveApp.getFolderById("1Hp_dM8WR0mGDT5q-a-VS-VVtl5dNCLfe");
var contents = folderID.getFolders();

var cnt = 0;
var lFolder;

while (contents.hasNext()) {
    var lFolder = contents.next();
    cnt++;

       data = [
            lFolder.getName(),
            lFolder.getId(),
        ];

         sheet.getRange(2, 1, data.length, data[0].length).setValues(data); //modified
    };
};

I want to add new data in column C. After I fill in a text in column C, then I run the script. But the second row is empty.

Answer 1

Regarding the rev 2 of the question

I don't think that the modified code line produce the result of the previous code and it's shown in the image because it writes data over and over the same range.

If you will go to use that code line then the first argument should be a variable corresponding to the row where the data will be written.

I reiterate that a better practices is to avoid the use of Google Apps Script methods inside a loop, instead create an array that hold all the values to be added to the sheet then add them on a single statement (it's implicit that it will be out of any loop).

About the rev 1 of the question

appendRow(rowContent) adds the rowContent to the first empty row, so if you will be writing data on column C, instead of it use setValues(values).

It's worth to note that Google Apps Script methods are slow so it's advisable whenever is possible to avoid their use on loops. To do this use your loop to create an array of values, then on a single statement pass the array to the spreadsheet.

Related

• Prevent “invoked too many times per second” error in Google Apps Script