Skip to content

Instantly share code, notes, and snippets.

@kurozumi
Last active May 11, 2017 13:12
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save kurozumi/48e6e5f8375c3b1ce6ff5c3a0dad5043 to your computer and use it in GitHub Desktop.
【Google Apps Script】スプレッドシートでGoogleドライブの指定したフォルダに指定したファイルが存在するかどうかチェックする方法
var FOLDER_NAME = "フォルダ名"
function onEdit(event) {
var r = event.source.getActiveRange();
if(fileExists_(r.getValue())){
Browser.msgBox("ファイルが見つかりました。");
}else{
Browser.msgBox("ファイルが見つかりませんでした。");
}
}
function fileExists_(fileName) {
var folder = getFolder_(FOLDER_NAME);
var files = folder.getFilesByName(fileName);
while (files.hasNext()) {
var file = files.next();
if(fileName == file.getName()) {
return true;
}
}
return false;
}
function getFolder_(folderName) {
var folders = DriveApp.getFoldersByName(folderName);
while(folders.hasNext()) {
var folder = folders.next();
if(folder.getName() == folderName){
break;
}
}
return folder;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment