Google表格脚本复制值从数组到列 [英] Google Sheets Script Copy Values from Array to Column

问题描述

我在尝试将值从数组复制到活动工作表中的另一列时遇到问题.虽然我一直在关注有关复制值的代码示例和教程，但是在我的当前设置中却遇到错误，说我的Range is not found用于 sheet.getRange(resultsArray.length).copyTo(sheet.getRange("F1:F24")).setValues(resultsArray);

I'm have an issue where I'm trying to copy values from an array to another column within my active sheet. While I have been following code samples and tutorials on copying values, I get an error with my current setup saying that my Range is not found for sheet.getRange(resultsArray.length).copyTo(sheet.getRange("F1:F24")).setValues(resultsArray);

我不太确定它来自哪个范围，但我的假设是.copyTo方法中的范围

I'm not too sure which range it is coming from, but my assumption is the range within the .copyTo method

这是我的全部功能:

function extractBranded() {

  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  for (var i = 0; i < data.length; i++) {

    var keywords = /ipad game|game system/;

    if (data[i][0].match(keywords)) {

      var resultsArray = [];
      var brandedKeywords = data[i][0];


      resultsArray = brandedKeywords;

      Logger.log(resultsArray.length);

      Logger.log(shopkeepKeywords);

      sheet.getRange(resultsArray.length).copyTo(sheet.getRange("F1:F24")).setValues(resultsArray);


    } else {

    }
  }

}

推荐答案

sheet.getRange至少需要2个参数: (行，上校) 或者 (行，列，行数或行数，列数)

sheet.getRange wants at least 2 arguments: (row, col) or (row, col, number or rows, number of cols)

sheet.getRange(resultsArray.length)无效，因此您可能需要:

sheet.getRange(resultsArray.length) is not a valid range, so you probably need:

sheet.getRange(1,1,resultsArray.length,1)

这篇关于Google表格脚本复制值从数组到列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！