问Google工作表转储与我的驱动器中的所有文件/URLS/所有者/最后编辑日期

EN

function getfiles() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Raw");

  var files = DriveApp.getFiles();

  var rows = [[ "Owner", "Name", "Link","Last updated"]];

  while ( files.hasNext()){

    var file = files.next();

    try { 

      var owner = file.getOwner();
      var name = file.getName();
      var url = '<a href="' + file.getUrl() + '">' + file.getName() + '</a>';
      var lup = file.getLastUpdated();

      var owners = [];
      var names = [];
      var urls = [];
      var lups = [];

      for (var v=0; owner.length;v++){
        owners.push(owner[v].getName());
      }
      for (var i=0; name.length; v++){
        names.push(name[i]);
      }
      for (var k=0; url.length; k++){
        urls.push(url[k]);
      }
      for (var o=0; lup.length; o++){
        lups.push(lup[o]);
      }


  sheet.getRange(1,1,owners.length,owners[0].length).setValues(owners);
      sheet.getRange(1,2,names.length,names[0].length).setValues(names);
      sheet.getRange(1,3,urls.length,urls[0].length).setValues(urls);
      sheet.getRange(1,4,lups.length,lups[0].length).setValues(lups);




    } catch (err) { 

      Logger.log(err);
    }
  }
}