如何使用Google Apps脚本在Google文档的表格单元内复制和编辑文本数据

我相信您的目标如下。

• 您希望使用Google Apps脚本实现表格单元格转换为问题中所显示的图像。（下图来自您的问题。）

  

为此，这个答案如何？我想提出以下示例脚本来解决您的问题。该脚本的流程如下。

1. 检索表。
2. 检索表的单元格“ B2”。
   • 这来自您的示例图像。
3. 创建一个包含文本和文本样式的对象。
   • 这用于将值拆分到单元格。
4. 文本和文本样式设置为单元格。
5. 当行数小于分割值的行数时，将追加新行，并将文本和文本样式设置为单元格。

示例脚本：

Please copy and paste the following script to the container-bound script of the Google Document, and run the function of myFunction at the script editor. In this script, row and column are the row and column numbers, respectively. So in your image, please set row = 2 and column = 2. For example, when you want to split the cell "C3", please set row = 3 and column = 3.

function myFunction() {
  // 1. Retrieve table.
  const body = DocumentApp.getActiveDocument().getBody();
  const table = body.getTables()[0];
  
  // 2. Retrieve the cell "B2" of the table.
  const row = 2;  // Please set the row number.
  const column = 2;  // Please set the column number.
  const cell = table.getCell(row - 1, column - 1);
  
  // 3. Create an object including the text and text styles. This is used for splitting values to the cells.
  const text = cell.editAsText();
  let temp = [];
  const textRuns = [].reduce.call(text.getText(), (ar, c, i, a) => {
    if (c != "\n") temp.push({text: c, foregroundColor: text.getForegroundColor(i), backgroundColor: text.getBackgroundColor(i), textAlignment: text.getTextAlignment(i), italic: text.isItalic(i)});
    if (c == "\n" || i == a.length - 1) {
      ar.push({text: temp.reduce((s, {text}) => s += text, ""), styles: temp});
      temp = [];
    }
    return ar;
  }, []);
  
  // 4. The text and text styles are set to the cells.
  for (let i = row - 1; i < table.getNumRows(); i++) {
    const t = table.getCell(i, column - 1).editAsText();
    const run = textRuns.shift();
    t.setText(run.text);
    run.styles.forEach((r, j) => {
      t.setBackgroundColor(j, j, r.backgroundColor);
      t.setForegroundColor(j, j, r.foregroundColor);
      t.setItalic(j, j, r.italic);
      if (r.textAlignment) t.setTextAlignment(j, j, r.textAlignment);
    });
  }
  
  // 5. When the number of rows are smaller than the number of rows of splitted values, the new rows are appended and the text and text styles are set to the cells.
  while (textRuns.length > 0) {
    const appendedRow = table.appendTableRow();
    for (let i = 0; i < table.getRow(row - 1).getNumCells(); i++) {
      appendedRow.appendTableCell("");
    }
    const t = appendedRow.getCell(column - 1).editAsText();
    const run = textRuns.shift();
    t.setText(run.text);
    run.styles.forEach((r, j) => {
      t.setBackgroundColor(j, j, r.backgroundColor);
      t.setForegroundColor(j, j, r.foregroundColor);
      t.setItalic(j, j, r.italic);
      if (r.textAlignment) t.setTextAlignment(j, j, r.textAlignment);
    });
  }
}

Result:

When above script is run for your initial table, the following result can be obtained. In this demonstration, at first, the values of cell "B2" are expanded, and then, the values of cell "C3" are expanded.

Note:

• This sample script is prepared for above situation. If your specification of above image is changed, the script might not be able to be used. So please be careful this.
• 在此示例脚本中，BackgroundColor并且ForegroundColor用作文本样式。如果您想使用其他文本样式，请修改上面的脚本。

参考文献：

• 类表
• 类TableCell
• editAsText（）