問題描述

我有一個包含 2000 多個文件的文件夾.我需要在 google 電子表格上列出所有這些文件.我在網上找到了一些腳本.但它們并沒有完全正常工作.當我點擊RUN"時，我只會得到一個包含 250 個文件的列表.

I have a Folder With more than 2000 Files.. And i Need to make a List of all these files on google spreadsheet.. I Found online some Scripts.. but they're not completely working. When i hit "RUN" i just get a list of 250 Files.

在閱讀 Google Developers 頁面時，我發現了一些有關啟用 Google Drive 高級服務的信息(我做到了)..而且我認為我可以使用名為令牌"的東西來解決這個問題??

Reading on Google Developers page i found some things about enabling Google Drive advanced services (and i did it).. And i think i could solve this problem using something named "tokens"??

我不知道..我不是程序員，我幾乎不會英語..我嘗試編輯此腳本，將我在網上找到的內容融合在一起.但一切正常.我只是得到了我什至無法理解的錯誤.

I don't know.. i'm not a programmer, and i barely know english.. i Tried editing this script making a fusion of what i found online.. But anything works.. i just get errors that i can't even understand..

所以.. 有沒有人可以解決它?

So.. is there someone able to fix it?

function listFilesInFolder() {
  var folder = DocsList.getFolder("Film");
  var contents = folder.getFiles();
  var file;
  var data;

  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.clear();

  sheet.appendRow(["Nome", "Data", "Dimensione"]);

  for (var i = 0; i < contents.length; i++) {
    file = contents[i];

    if (file.getFileType() == "SPREADSHEET") {
      continue;
    }

    data = [ 
      file.getName(),
      file.getDateCreated(),
      file.getSize(),
    ];

    sheet.appendRow(data);
  }
};

推薦答案

此腳本適用于至少 2200 個文件 :)

This Script works for at least 2200 Files :)

function listFilesInFolder(id) {
  var folder = DriveApp.getFolderById('MyFolderID');
  var contents = folder.getFiles();
  var file;
  var name;
  var sheet = SpreadsheetApp.getActiveSheet();
  var date;
  var size;

  sheet.clear();
  sheet.appendRow(["Nome", "Data", "Dimensione"]);


  while(contents.hasNext()) {
    file = contents.next();
    name = file.getName();
    date = file.getDateCreated()
    size = file.getSize()

    data = [name, date, size]
    sheet.appendRow(data);
  }
};

這篇關于如何在 Google 電子表格上列出 Google Drive 文件夾中的所有文件的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！