如何在谷歌云端硬盘文件夹中的所有文件的Google SpreadSheet上创建一个列表 [英] How to Make a list on Google SpreadSheet of all files in a Google Drive folder
问题描述
当我点击RUN时,我只获得250个文件列表。
在Google Developers页面阅读时,我发现了一些关于启用Google Drive高级服务的信息(我做到了)..
我想我可以用名为tokens的东西解决这个问题??
我不知道..我我不是一个程序员,我几乎不懂英语..
i试过编辑这个脚本,把我在网上找到的东西融合在一起..但是任何东西都可以工作..我只是得到我甚至无法理解的错误..
那么..是否有人能够修复它?
函数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个文件:
函数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);
}
};
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.
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);
}
};
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 SpreadSheet上创建一个列表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!