google-apps-script - 应用程序脚本将输入表行单元格数据复制到输出表作为转置列数据

Question

尝试将数据从输入表复制到转置的输出表。第一次在张之间复印，不是很熟练。我已经尝试了很多方法来执行 copyTo 代码行，查看以前类似的 stackoverflow 报告。错误“Missing ; before statement.（第 11 行，文件“代码”）第 11 行是最后一行，inRng.copyTo ...

function fetchData() {
  //Browser.msgBox("Test Button");
  var inData = ("FUNGRAPH9");
  var outData = ("Data");
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var input = ss.getSheetByName(inData);
  var output = ss.getSheetByName(outData);
  //test getting data for 1st chart
  inRng = input.getRange(10,3,1,7); 
  outRng = output.getRange(6,21,12,21); 
  inRng.copyTo(outData,6,21,12,21).CopyPasteType.transposed);
}

田池回答的修改后的代码。现在可以了。谢谢！

  function fetchData() {
  //Browser.msgBox("Test Button");
  var inData = ("FUNGRAPH9");
  var outData = ("Data");
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var input = ss.getSheetByName(inData);
  var output = ss.getSheetByName(outData);
  //test getting data for 1st chart
  inRng = input.getRange(10,3,1,7);
  outRng = output.getRange("U6");
  inRng.copyTo(outRng, SpreadsheetApp.CopyPasteType.PASTE_NORMAL, true);
}

标签： google-apps-scriptgoogle-sheets

Answer 1

我使用了 Tanaike 的答案（针对我更正的情况进行了修改）并且它有效，更正的代码：

  function fetchData() {
  //Browser.msgBox("Test Button");
  var inData = ("FUNGRAPH9");
  var outData = ("Data");
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var input = ss.getSheetByName(inData);
  var output = ss.getSheetByName(outData);
  //test getting data for 1st chart
  inRng = input.getRange(10,3,1,7);
  outRng = output.getRange("U6");
  inRng.copyTo(outRng, SpreadsheetApp.CopyPasteType.PASTE_NORMAL, true);
}