1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| function Lister_fichiers(){
// Log the name of every file in the user's Drive that modified after date = A1, whose name contains "MARQUE = B1".
var app = SpreadsheetApp;
var classeur = app.getActiveSpreadsheet();
const Formsheet = classeur.getSheetByName('Var');
const CsvM = classeur.getSheetByName('CsvM');
const Date = Formsheet.getRange('A1').getValues();
const Marque = Formsheet.getRange('B1').getValues();
const Pays = Formsheet.getRange('C1').getValues();
var sffiles = DriveApp.searchFiles("modifiedDate > '"+Date+"' and title contains '"+Marque+"' ");
// Cette ligne ci-dessus ne fonctionne pas
// Alors que celle ci-dessous fonctionne
// var sffiles = DriveApp.searchFiles('modifiedDate > "2019-01-01" and title contains "Chantelle" and mimeType = "application/vnd.google-apps.spreadsheet" and trashed=false');
while (sffiles.hasNext()){
var sffile = sffiles.next();
var sfname = sffile.getName();
var sfdate = sffile.getLastUpdated();
var sfsize = sffile.getSize();
var sfurl = sffile.getUrl();
var fileParents = sffile.getParents();
while (fileParents.hasNext()) {
var sffolder = fileParents.next();
Logger.log(sffolder.getName());
}
var sfid = sffile.getId();
Logger.log(sffile.getId());
Logger.log(sffile.getName());
var sflist = [sfname,sfdate,sfsize,sfurl,sfid,sffolder];
CsvM.appendRow(sflist);
}
CsvM.appendRow(["A-Name", "Date", "Size", "URL", "ID", "Dossier Parent"]);
CsvM.sort(1);
} |
Partager