如何通过应用程序脚本在特定文件夹中创建电子表格 [英] How to Create a Spreadsheet in a particular folder via App Script

问题描述

任何人都可以帮助我，

我想通过应用程序脚本在特定文件夹中创建电子表格。如何做到这一点。

目前我正在做如下操作：

  var folder = DocsList.getFolder（MyFolder）; 
 var sheet = SpreadsheetApp.create（MySheet）; 
 var file = DocsList.getFileById（sheet.getId（））; 
 file.addToFolder（folder）; 
 file.removeFromFolder（file.getParents（）[0]）; 
  

不工作.......

DriveApp 创建 Google文档（文档或SpreadSheets），也不能使用 addToFolder 因为 DocList 已被弃用。只有一种方法可以创建或移动Google文档或Google SpreadSheets。

  //将文件移动到文件夹------------------------------- // 
 var fileID ='12123123213321'
 var folderID = '21321312312'
 var file = DriveApp.getFileById（fileID）.getName（）
 var folder = DriveApp.getFolderById（folderID）
 var newFile = file.makeCopy（file，folder）
 
 //从根文件夹中删除文件-------------------------------- // 
 DriveApp.getFileById（fileID）.setTrashed（true）
  

正如您可以看到 DOES NOT 移动文件，它会在所需的文件夹中创建一个具有相同名称的副本，然后将原始文件移动到垃圾箱。我很确定没有其他方法可以做到这一点。

Can anybody help me out,

I want to create a Spreadsheet through App Script in a particular folder. How to do that.

Presently I am doing as follow:

var folder = DocsList.getFolder("MyFolder");
var sheet = SpreadsheetApp.create("MySheet");
var file = DocsList.getFileById(sheet.getId());
file.addToFolder(folder);
file.removeFromFolder(file.getParents()[0]);

It is not working.......

解决方案

Since you can no longer create Google Docs (Docs or SpreadSheets) using DriveApp, nor use addToFolder because DocList is deprecated. There is only one way to create or "move" Google Docs or Google SpreadSheets..

  //"Move" file to folder-------------------------------//
  var fileID = '12123123213321'
  var folderID = '21321312312'
  var file = DriveApp.getFileById(fileID).getName()
  var folder = DriveApp.getFolderById(folderID)
  var newFile = file.makeCopy(file, folder)

  //Remove file from root folder--------------------------------//
  DriveApp.getFileById(fileID).setTrashed(true)

As you can see this DOES NOT move the file, it makes a copy with the same name in the folder you want and then moves the original file to the trash. I'm pretty sure there is no other way to do this.

这篇关于如何通过应用程序脚本在特定文件夹中创建电子表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！