如何使用Google Sheets Api批量复制范围

Question

我的代码是：

function Test_Copy() {
  var spreadsheetId = "MY_FILE_ID";
  var sheetId = "SHEET_ID";

  var rangeFrom = Sheets.newGridRange();
  rangeFrom.sheetId = sheetId;
  rangeFrom.startRowIndex = 0;
  rangeFrom.endRowIndex = 1;  
  rangeFrom.startColumnIndex = 0;
  rangeFrom.endColumnIndex = 1;

  var rangeTo = Sheets.newGridRange();
  rangeTo.sheetId = sheetId;
  rangeTo.startRowIndex = 1;
  rangeTo.endRowIndex = 2;  
  rangeTo.startColumnIndex = 1;
  rangeTo.endColumnIndex = 2;  


  var request = Sheets.newCopyPasteRequest();
  request.destination =  rangeTo      
  request.source =  rangeFrom
  request.pasteType = "PASTE_NORMAL";
  request.pasteOrientation = "NORMAL";

  var resource = Sheets.newBatchUpdateSpreadsheetRequest();
  resource.requests = [request];

  Sheets.Spreadsheets.batchUpdate(resource , spreadsheetId);

}

当我运行它时，我得到一个错误：

对sheets.spreadsheets.batchUpdate的API调用失败，错误：收到无效的JSON有效负载。未知名称"pasteType"

我使用GoogleSheetsAPI（以下是我如何启用它的）

Answer 1

我对Sheets API没有太多经验，但这似乎可以在它记录响应数据时工作：

var copyPasteRequest = Sheets.newCopyPasteRequest();
  copyPasteRequest.destination =  rangeTo;    
  copyPasteRequest.source =  rangeFrom;
  copyPasteRequest.pasteType = "PASTE_NORMAL";
  copyPasteRequest.pasteOrientation = "NORMAL";

  var resource = Sheets.newBatchUpdateSpreadsheetRequest();

  //Create request object
  var request = Sheets.newRequest();
  request.copyPaste = copyPasteRequest;
  resource.requests = [request];

  var res = Sheets.Spreadsheets.batchUpdate(resource , spreadsheetId);
  Logger.log(res.replies);
  Logger.log(res.spreadsheetId);

我认为问题在于您试图将CopyPasteRequest对象设置为BatchUpdateRequest对象的属性，但显然它需要一个请求对象作为中介。

{
  "requests": [
    {
      object (Request)
    }
  ],
  "includeSpreadsheetInResponse": boolean,
  "responseRanges": [
    string
  ],
  "responseIncludeGridData": boolean
} 

不过我可能错了。