Google Apps 脚本：在 Google 文档中按 ID/名称插入和更新文本

Question

我希望能够使用Google Apps脚本，具有给定ID的自定义文本插入Google文档中，以便以后能够更新它们（任何次数）。插入应与光标放置以及更换任何选定的元素一起使用。

我的代码对此非常有效（部分基于 this 答案），请参阅下面。我使用“

// function for inserting text
insertAny = (textToInsert, textName = null, range = null) => {
    var doc = DocumentApp.getActiveDocument();
    var cursor = doc.getCursor();
    var rangeBuilder = null;
    if (cursor && (range === null)) {
        // Attempt to insert text at the cursor position. If the insertion returns null, the cursor's
        // containing element doesn't allow insertions, so show the user an error message.
        var cElement = cursor.insertText(textToInsert);
        if (!cElement) {
            textName = null
            DocumentApp.getUi().alert('Cannot insert text here.');
        } else {
            rangeBuilder = doc.newRange();
            rangeBuilder.addElement(cElement);
        }
    } else {
        var selection;
        if (range === null) {
            selection = DocumentApp.getActiveDocument().getSelection();
        } else {
            selection = range;
        }
        if (!selection) {
            textName = null
            DocumentApp.getUi().alert('Insertion omitted: A cursor placed in the text or a selected text is needed to indicate the position of the insertion.');
        } else {
            var elements = selection.getRangeElements();
            var replace = true;
            for (var i = 0; i < elements.length; i++) {
                if (elements[i].isPartial()) {
                    var tElement = elements[i].getElement().asText();
                    var startIndex = elements[i].getStartOffset();
                    var endIndex = elements[i].getEndOffsetInclusive();
                    var text = tElement.getText().substring(startIndex, endIndex + 1);
                    tElement.deleteText(startIndex, endIndex);
                    if (replace) {
                        tElement.insertText(startIndex, textToInsert);
                        if (rangeBuilder === null) {
                            rangeBuilder = doc.newRange();
                            rangeBuilder.addElement(tElement, startIndex, startIndex + textToInsert.length - 1);
                        }
                        replace = false;
                    }
                } else {
                    var eElement = elements[i].getElement();
                    // if not specified as "any", throws type errors for some reason
                    if (replace && eElement.editAsText) {
                        eElement.clear().asText().setText(textToInsert);
                        replace = false;
                        if (rangeBuilder === null) {
                            rangeBuilder = doc.newRange();
                            rangeBuilder.addElement(eElement);
                        }
                    } else {
                        if (replace && i === elements.length - 1) {
                            var parent = eElement.getParent();
                            parent[parent.insertText ? 'insertText' : 'insertParagraph'](parent.getChildIndex(eElement), textToInsert);
                            if (rangeBuilder === null) {
                                rangeBuilder = doc.newRange();
                                rangeBuilder.addElement(eElement);
                            }
                            replace = false; //not really necessary since it's the last one
                        }
                        eElement.removeFromParent();
                    }
                }
            }
        }
    }
    if (textName !== null && rangeBuilder !== null) {
        doc.addNamedRange(textName, rangeBuilder.build());
    }
}

// function for updating text
const updateNamedRange = (textName, newText) => {
    var doc = DocumentApp.getActiveDocument();
    var myNamedRanges = doc.getNamedRanges(textName);
    for (var i = 0; i < myNamedRanges.length; i++) {
        var range = myNamedRanges[i].getRange();
        insertAny(newText, textName, range);
    }
}

有什么想法（或更好的解决方案）吗？

Answer 1

好的，似乎原因是，如果我立即插入命名范围旁边的文本，它将自动属于该范围。 （因此，随后的更新也影响了这些无关的部分。）

我真正的技巧解决方案是暂时插入占位符角色，以将新文本与任何名称范围的潜在范围区分开……这让我发笑，但我尝试过的其他任何事情也没有工作。对于我能想到的所有棘手场景，这似乎是强大的。我的最终代码在下面。

 const insertAny = (textToInsert, textName = null, range = null) => {
    var doc = DocumentApp.getActiveDocument();
    var cursor = doc.getCursor();
    var rangeBuilder = null;
    if (cursor && (range === null)) {
        // Attempt to insert text at the cursor position. If the insertion returns null, the cursor's
        // containing element doesn't allow insertions, so show the user an error message.
        var cElement = cursor.insertText(textToInsert);
        if (!cElement) {
            textName = null
            DocumentApp.getUi().alert('Cannot insert text here.');
        } else {
            rangeBuilder = doc.newRange();
            rangeBuilder.addElement(cElement);
        }
    } else {
        var selection;
        if (range === null) {
            selection = DocumentApp.getActiveDocument().getSelection();
        } else {
            selection = range;
        }
        if (!selection) {
            textName = null
            DocumentApp.getUi().alert('Insertion omitted: A cursor placed in the text or a selected text is needed to indicate the position of the insertion.');
        } else {
            var elements = selection.getRangeElements();
            if (range !== null) {
                elements.length = 1;
            }
            var replace = true;
            for (var i = 0; i < elements.length; i++) {
                if (elements[i].isPartial()) {
                    var tElement = elements[i].getElement().asText();
                    var startIndex = elements[i].getStartOffset();
                    var endIndex = elements[i].getEndOffsetInclusive();
                    var text = tElement.getText().substring(startIndex, endIndex + 1);
                    if (replace) {
                        tElement.insertText(endIndex + 1, 'x');
                        tElement.deleteText(startIndex, endIndex);
                        tElement.insertText(startIndex + 1, textToInsert);
                        if (rangeBuilder === null) {
                            rangeBuilder = doc.newRange();
                            rangeBuilder.addElement(tElement, startIndex + 1, startIndex + 1 + textToInsert.length - 1);
                        }
                        replace = false;
                        tElement.deleteText(startIndex, startIndex);
                    } else {
                        tElement.deleteText(startIndex, endIndex);
                    }
                } else {
                    var eElement = elements[i].getElement();
                    // if not specified as "any", throws type errors for some reason
                    if (replace && eElement.editAsText) {
                        eElement.clear().asText().setText(textToInsert);
                        replace = false;
                        if (rangeBuilder === null) {
                            rangeBuilder = doc.newRange();
                            rangeBuilder.addElement(eElement);
                        }
                    } else {
                        if (replace && i === elements.length - 1) {
                            var parent = eElement.getParent();
                            parent[parent.insertText ? 'insertText' : 'insertParagraph'](parent.getChildIndex(eElement), textToInsert);
                            if (rangeBuilder === null) {
                                rangeBuilder = doc.newRange();
                                rangeBuilder.addElement(eElement);
                            }
                            replace = false; //not really necessary since it's the last one
                        }
                        eElement.removeFromParent();
                    }
                }
            }
        }
    }
    if (textName !== null && rangeBuilder !== null) {
        doc.addNamedRange(textName, rangeBuilder.build());
    }
}


const updateNamedRange = (textName, newText) => {
    var doc = DocumentApp.getActiveDocument();
    var myNamedRanges = doc.getNamedRanges(textName);
    for (var i = 0; i < myNamedRanges.length; i++) {
        var range = myNamedRanges[i].getRange();
        myNamedRanges[i].remove();
        insertAny(newText, textName, range);
    }
}