Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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(["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 = [
- childFile.getName().replace(".pdf",""),
- childFile.getUrl(),
- ]; 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(["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 = [
- childFile.getName().replace(".pdf",""),
- childFile.getUrl(),
- ];
- sheet.appendRow(data);
- } else {
- return;
- }
- }
- }
- getChildFolders(parentName + "/" + childFolder.getName(), childFolder, data, sheet, listAll);
- }
- };
- sheet.appendRow(data);
- } else {
- return;
- }
- }
- }
- getChildFolders(parentName + "/" + childFolder.getName(), childFolder, data, sheet, listAll);
- }
- };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement