Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function calculate() {
- //R01 can be found in http://pastebin.com/2uRe6GR0
- //R02=>
- //var fileList = DocsList.getFiles();
- //var count = fileList.length;
- var files = DriveApp.getFiles();
- //R02<=
- var file;
- var i;
- var theSheet = SpreadsheetApp.getActiveSheet();
- theSheet.clear();
- theSheet.getRange(1, 1).setValue("File Name");
- theSheet.getRange(1, 2).setValue("File Location(s)");
- theSheet.getRange(1, 3).setValue("File Size");
- //R02=>
- //for (i=0; i<count; i++)
- i = 0;
- while (files.hasNext())
- //R02<=
- {
- //R02=>
- //file = fileList[i];
- file = files.next();
- i++;
- //R02<=
- theSheet.getRange(i+2, 1).setValue(file.getName());
- theSheet.getRange(i+2, 3).setValue(file.getSize());
- var folders = file.getParents();
- var folderNames = "";
- //R02=>
- //var fIdx;
- //for (fIdx in folders)
- //{
- // folderNames = folders[fIdx].getName() + "; " + folderNames;
- //}
- while (folders.hasNext())
- {
- var folder = folders.next();
- folderNames = folder.getName() + "\\" + folderNames;
- if(!folders.hasNext())
- {
- folders = folder.getParents();
- }
- }
- //R02<=
- theSheet.getRange(i+2, 2).setValue(folderNames);
- }
- theSheet.sort(3, false);
- //R02=>
- //theSheet.getRange(2, 3, count, 1).setNumberFormat("#,##0")
- theSheet.getRange(2, 3, i+2, 1).setNumberFormat("#,##0")
- //R02=>
- }
Add Comment
Please, Sign In to add comment