我有這個代碼，但這給出了一個錯誤，即無法讀取 null 的屬性“getName”我該如何解決這個問題。我的驅動器上有大約 2000 個檔案。還有其他用戶共享的檔案。
function getMyFilesFromDrive() {
var myFiles = DriveApp.searchFiles('title contains "A3_"');
var sheet = SpreadsheetApp.getActive().getSheetByName("Files");
sheet.clear();
var rows = [];
rows.push(["ID", "Name", "Url", "user"]);
while(myFiles.hasNext()) {
var file = myFiles.next();
if(file != null) {
rows.push([file.getId(), file.getName(), file.getUrl(), file.getOwner().getName()]);
}
}
sheet.getRange(1,1,rows.length,4).setValues(rows);
}
uj5u.com熱心網友回復：
查找電子表格
這就是我使用的：
function getSpreadsheets() {
const ss = SpreadsheetApp.getActive();
const sh = ss.getSheetByName('Files');
if (sh.getLastRow() > 1) {
const rg = sh.getRange(2, 1, sh.getLastRow() - 1, sh.getLastColumn());
rg.clearContent();
SpreadsheetApp.flush();
}
var token = '';
var vA = [["Id", "MimeType", "Kind", "Title", "Path", "OwnerEmails"]];
do {
let resp = Drive.Files.list({ pageToken: token, q: "mimeType='application/vnd.google-apps.spreadsheet'" });
token = resp.nextPageToken;
for (let i = 0; i < resp.items.length; i ) {
let item = resp.items[i];
if (item.title.match(/^A3_.*$/)) {//with names that begin with A3_
vA.push([item.id, item.mimeType, item.kind, item.title, getPathFromId(item.id), item.owners.map(function (o) { return o.emailAddress }).join(',')]);
}
}
if (token == '') {
ss.toast('That was the last ' resp.items.length '. Your Done!');
} else {
ss.toast('Another ' resp.items.length '. Keep Going!');
}
} while (token)
sh.getRange(2, 1, vA.length, vA[0].length).setValues(vA);
SpreadsheetApp.flush();
}
function getPathFromId(id) {
try {
var file = DriveApp.getFileById(id)
var pA = [];
pA.push(file.getName());
var folder = file.getParents();
while (folder.hasNext()) {
var f = folder.next();
pA.push(f.getName());
folder = f.getParents()
}
var r = pA.reverse().join(' / ');
}
catch (e) {
return e;
}
return r;
}
您將需要啟用驅動器 API。
您可以將 downloadUrl 添加到此
vA.push([item.id, item.mimeType, item.kind, item.title, getPathFromId(item.id), item.owners.map(function (o) { return o.emailAddress }).join(','),item.downloadUrl]);
和這里的標題：
var vA = [["Id", "MimeType", "Kind", "Title", "Path", "OwnerEmails","Url"]];
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/459995.html
標籤：谷歌应用脚本