Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
var conjunto = 1; var limite = 400; // no tocar var contador = 0 + (limite*(conjunto-1)); var skip = limite*(conjunto-1); var skip_c = 0; function listFilesAndFolders(){ var folderId = Browser.inputBox('Enter folder ID', Browser.Buttons.OK_CANCEL); if (folderId === "") { Browser.msgBox('Folder ID is invalid'); return; } getFolderTree(folderId, true); }; function getFolderTree(folderId, listAll) { try { var parentFolder = DriveApp.getFolderById(folderId); var file, data, sheet = SpreadsheetApp.getActiveSheet(); if(conjunto == 1) { sheet.clear(); sheet.appendRow(["Folder","Name", "URL"]); } getChildFolders(parentFolder.getName(), parentFolder, data, sheet, listAll); } catch (e) { Logger.log(e.toString()); } }; function getChildFolders(parentName, parent, data, sheet, listAll) { var childFolders = parent.getFolders(); while (childFolders.hasNext()) { var childFolder = childFolders.next(); var files = childFolder.getFiles(); while (listAll & files.hasNext()) { var childFile = files.next(); if(skip_c <= skip) { skip_c+=1; } else { contador+=1; if(contador<=conjunto*limite) { data = [ childFolder.getName(), childFile.getName().replace(".pdf",""), childFile.getUrl(), ]; sheet.appendRow(data); } else { return; } } } getChildFolders(parentName + "/" + childFolder.getName(), childFolder, data, sheet, listAll); } };
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)