迭代范围，将字符串附加到每个 [英] Iterate over range, append string to each

问题描述

我在 Google 表格 (activerange) 中选择了一系列单元格.我想遍历该范围内的每个单元格，并在末尾添加一个字符串.字符串始终相同，可以硬编码到函数中.

I have a range of cells selected in a Google Sheets (activerange). I want to iterate over every cell in that range, and add a string to the end. The string is always the same, and can be hard coded into the function.

这似乎是一件非常简单的事情，但是我已经弄了一个小时的代码并且无法得到任何有用的东西，而且文档真的没有帮助.

It seems like a really simple thing, but I've been messing with the code for an hour now and can't get anything useful to happen, and the docs are really not helping.

这是我现在所拥有的.我不会编写 JS 代码(我知道 VBA，因为所有这些都有帮助..).

Here's what I have now. I don't code JS (I do know VBA, for all that helps..).

function appendString() {
  var range = SpreadsheetApp.getActiveSheet().getActiveRange();
  for (var i = 0; i < range.length; i++) {
    var currentValue = range[i].getValue();
    var withString = currentValue + " string";
    range[i].setValue(withString);
  }
}

推荐答案

你可以试试这样的:

//
// helper `forEachRangeCell` function
//

function forEachRangeCell(range, f) {
  const numRows = range.getNumRows();
  const numCols = range.getNumColumns();

  for (let i = 1; i <= numCols; i++) {
    for (let j = 1; j <= numRows; j++) {
      const cell = range.getCell(j, i)

      f(cell)
    }
  }
}

//
// Usage
//

const range = SpreadsheetApp.getActiveSheet().getActiveRange();

forEachRangeCell(range, (cell) => {
  cell.setValue(`${cell.getValue()} string`)
})

这篇关于迭代范围，将字符串附加到每个的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！