create a Google spreadsheet in a particular folder

问题:

this question teaches how to adjust the folders of a file to move it into a particular folder, and out of the root.

It also suggests using folder.createFile to create it directly in the desired folder... but it appears createFile only applies to Docs... is there a way to create a spreadsheet directly in a particular folder?

回答1:

Since DocsList is deprecated, currently the following solution works:

var folder=DriveApp.getFoldersByName(folderName).next();//gets first folder with the given foldername
var file=SpreadsheetApp.create(fileName);
var copyFile=DriveApp.getFileById(file.getId());
folder.addFile(copyFile);
DriveApp.getRootFolder().removeFile(copyFile);

回答2:

Create spreadsheets using Apps Script does not work with regular Google accounts and Google Apps Standard Edition accounts. However, you can always make a copy of a dummy spreadsheet and then modify it accordingly using Google Apps Script. Here is a sample code.

function createSpreadsheetInfolder() {
  var dummySS = DocsList.getFileById('ID of dummy SS');
  var myCopy = dummySS.makeCopy('My new file');
  //Get your target folder
  var folder = DocsList.getFolder('ID or path of folder');
  myCopy.addToFolder(folder);
}

回答3:

The answers already given don't seem to work, maybe they're outdated.

Here's my answer (worked for me).

var folders=DriveApp.getFoldersByName("existingFolder");
while (folders.hasNext()) {
  var folder = folders.next();
  var file=SpreadsheetApp.create("the file that must be in a folder");
  var copyFile=DriveApp.getFileById(file.getId());
  folder.addFile(copyFile);
  DriveApp.getRootFolder().removeFile(copyFile);
}

回答4:

Admittedly, my answer is derived from the previous ones, none of which did exactly what I needed. This function has been tested with current Google Apps Script and spreadsheet documents. With duplicate folder names it will work, but move the file to the first folder returned by the API.

// Arguments are a file object and a folder name.
function moveFileToFolder(file, folderName)
{
    var folders = DriveApp.getFoldersByName(folderName);
    var copyFile = DriveApp.getFileById(file.getId());

    if (folders.hasNext()) {
       var folder = folders.next();
       folder.addFile(copyFile);
       DriveApp.getRootFolder().removeFile(copyFile);
    }
}

回答5:

Now it is possible to create Google spreadsheet in a specific folder. For that you need to use advanced drive service v2. Enable it from Advanced Services menu in google app script editor.

var oFile = placeGoogleSpreadsheetInSpecificFolder("my file", "target folder id");
var oSpreadsheet = SpreadsheetApp.open(DriveApp.getFileById(oFile.getId()));

function placeGoogleSpreadsheetInSpecificFolder(sSpreadsheetName, sTargetFolderId) {
    var oGeneratedFile = Drive.Files.insert({
        "mimeType": "application/vnd.google-apps.spreadsheet",
        "parents": [{
            id: sTargetFolderId
        }],
        "title": sSpreadsheetName
    });
    return oGeneratedFile;
}

This solution worked perfectly fine for me.

回答6:

This code works for me, I think there is no way to avoid the "remove from root" step, at least not that I know.

function createSpreadsheet() {
var folder = DocsList.getFolder('GAS');// this value as test for me
var root = DocsList.getRootFolder()
var newFileId = SpreadsheetApp.create('testNewSS').getId();// this defines the name of the new SS
var newFile = DocsList.getFileById(newFileId); // begin the 'move to folder process'
newFile.addToFolder(folder);
newFile.removeFromFolder(root);// had to do it in 2 separate steps 
}

回答7:

This question has beeen answerd in. https://stackoverflow.com/a/19610700 It is a nice solustion.

folder.createFile("name", '',MimeType.GOOGLE_SHEETS);

using anything but a empty string leaves me with a error.