javascript - 在 Google 文档内的表格中插入和删除文本

Question

我有一个包含 3x4 表格的 Google 文档。我需要从函数中删除和添加这些表格单元格中的文本。

我可以使用以下代码索引所有表格单元格值:

 var searchElement = copyBody.findElement(DocumentApp.ElementType.TABLE);
     var element = searchElement.getElement();
     var table = element.asTable();
     var tablerows = element.getNumRows();

        for ( var row = 0; row < tablerows; ++row ) {
          var tablerow = element.getRow(row)
          for ( var cell=0; cell < tablerow.getNumCells(); ++cell) {

            var celltext = tablerow.getChild(cell).getText();
            Logger.log( "Text is ("+celltext+")" );

日志输出以下内容:

[16-01-19 01:23:31:663 PST] Text is (A)
[16-01-19 01:23:31:665 PST] Text is (C)
[16-01-19 01:23:31:666 PST] Text is (E)
[16-01-19 01:23:31:667 PST] Text is (X)
[16-01-19 01:23:31:669 PST] Text is (Row 2, Cell 1)
[16-01-19 01:23:31:670 PST] Text is (Row 2, Cell 2)
[16-01-19 01:23:31:672 PST] Text is (Row 2, Cell 3)
[16-01-19 01:23:31:673 PST] Text is (Row 2, Cell 4)
[16-01-19 01:23:31:675 PST] Text is (Row 3, Cell 1)
[16-01-19 01:23:31:677 PST] Text is (Row 3, Cell 2)
[16-01-19 01:23:31:678 PST] Text is (Row 3, Cell 3)
[16-01-19 01:23:31:679 PST] Text is (Row 3, Cell 4)

我之前用过它来插入文本(自由格式，不在表格单元格中):

function insertText() {
 var body = DocumentApp.getActiveDocument().getBody();
 var val = body.findText('Hello! R3C3');
  if(val == null)
  {
   var text = body.editAsText();
   text.insertText(9, 'Hello! R3C3');         
  }
  else
  {
    body.replaceText('Hello! R3C3','');
  }
}

问题:如何查找文本并将其替换为 第 2 行，单元格 1 等文本 'Hello! R3C3'？

Answer 1

以下是我如何将文本插入到 Google 文档中的特定表格单元格:

首先在文档中“查找”表格:

  var copyDoc = DocumentApp.openById(copyId);
  var copyBody = copyDoc.getActiveSection();

          var searchElement = copyBody.findElement(DocumentApp.ElementType.TABLE);
          var element = searchElement.getElement();
          var table = element.asTable();
          var tablerows = element.getNumRows();

要插入/删除文本，请使用以下命令:

  //Row3Cell3
      var Row3Cell3 = table.getRow(2).getCell(2).getChild(0).getText();
      if(Row3Cell3 != 'Hello! R3C3')
      {
        var Row3Cell3_1 = table.getRow(2).getCell(2).getChild(0);
        Row3Cell3_1.setText('Hello! R3C3');         
      }
 else
  {
    copyBody.replaceText('Hello! R3C3','');
  }

所以我希望这对寻求类似解决方案的其他人有所帮助。