使用Google Docs API检索namedRange中的文本 [英] Retrieve text in namedRange with Google Docs API

查看：52 发布时间：2020/11/17 4:21:06 node.js google-apps-script google-docs-api named-ranges

本文介绍了使用Google Docs API检索namedRange中的文本的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

使用带有Node的Google Docs/Drive API，我成功地提供了一项服务，该服务可以生成模板"样式的文档，这些文档具有名为Ranges的特征，可供其他用户写入.我想使用Google Docs API读取在这些范围内输入的文本，但是看不到一种干净的方法.鉴于我拥有每个范围的开始和结束索引，我认为这将非常简单！不幸的是，我看不到任何内置的方法?

Using the Google Docs/Drive APIs with Node, I've successfully made a service which produces 'template' style documents which feature namedRanges for other users to write into. I'd like to use the Google Docs API to read the text that gets entered inside of these ranges, but can't see a clean way of doing so. Given that I have the start and end indices of each range, I thought this would be very simple! Unfortunately I can't see any built-in way of doing it?

当前看来，我将不得不请求整个Google文档，并针对我正在查看的每个范围，比较每个节点的开始/结束索引，然后递归遍历树，直到它们匹配为止.没有更好的方法吗?

Currently it looks like I will have to request the whole google doc, and for each range that I'm watching, compare each node's start/end index and recursively traverse down the tree until they match. Is there not a better way of doing this?

欢呼

Tanaike的以下解决方案更加简洁，但是我已经在Firebase Function上运行了一个版本，因此我想也可以共享它.此代码检索具有给定ID的Google文档，并将namedRanges的内容作为字符串存储在Firebase实时数据库中，并通过"BBCode"保持图像和表格的完整性.样式标签.下面的代码(请注意，我知道每个namedRange都位于表单元格内，这使查找它们变得更加容易):

Tanaike's solution below is cleaner, but I had already got a version working on my Firebase Function so thought I might as well share it. This code retrieves a Google Doc with the given ID and stores the contents of the namedRanges as strings within the a Firebase Realtime Database, keeping images and tables intact though "BBCode" style tags. Relevent code below (note that I know that each namedRange is inside of a table cell, which makes finding them easier):

async function StoreResponses(oauth2Client, numSections, documentId, meetingId, revisionId, roomId) 
{
    var gdocsApi = google.docs({version: 'v1', auth: oauth2Client});

    return gdocsApi.documents.get({ "documentId": documentId })
    .then((document) => {
        
        var ranges = document.data.namedRanges;
        var docContent = document.data.body.content;

        var toStore = [];

        for(var i = 0; i < numSections; i++)
        {
            var range = ranges[`zoomsense_section_${i}`].namedRanges[0].ranges[0]
            
            // loop through document contents until we hit the right index
            for(var j = 0; j < docContent.length; j++)
            {
                if(docContent[j].startIndex <= range.startIndex && docContent[j].endIndex >= range.endIndex)
                {
                    // we know that the ranges are inside single table cells
                    var sectionContents = docContent[j].table.tableRows[0].tableCells[0].content;

                    toStore.push(readStructuralElementsRecursively(document, sectionContents));
                }
            }
        }

        return db.ref(`/data/gdocs/${meetingId}/${roomId}/${documentId}/revisions/${revisionId}/responses`).set(toStore);
    })
    .catch((exception) => {
        console.error(exception)
        res.status(500).send(exception);
    })
}

// uses https://developers.google.com/docs/api/samples/extract-text
function readStructuralElementsRecursively(document, elements)
{
    var text = "";
    elements.forEach(element => {
        if(element.paragraph)
        {
            element.paragraph.elements.forEach(elem => {
                text += readParagraphElement(document, elem);
            });
        }
        else if(element.table)
        {
            // The text in table cells are in nested Structural Elements, so this is recursive
            text += "[table]"
            element.table.tableRows.forEach(row => {
                text += "[row]"
                row.tableCells.forEach(cell => {
                    text += `[cell]${readStructuralElementsRecursively(document, cell.content)}[/cell]`;
                })
                text += "[/row]"
            })
            text+= "[/table]"
        }
    });

    return text;
}

// handle text and inline content
function readParagraphElement(document, element)
{
    if(element.textRun)
    {
        // standard text
        return element.textRun.content;
    }
    if(element.inlineObjectElement)
    {
        var objId = element.inlineObjectElement.inlineObjectId;
        var imgTag = "\n[img]404[/img]"

        try
        {
            var embeddedObj = document.data.inlineObjects[objId].inlineObjectProperties.embeddedObject;
            if(embeddedObj.imageProperties)
            {
                // this is an image
                imgTag = `[img]${embeddedObj.imageProperties.contentUri}[/img]`
            }
            else if(embeddedObj.embeddedDrawingProperties)
            {
                // this is a shape/drawing
                // can't find any way to meaningfully reference them externally,
                // so storing the ID in case we can do it later
                imgTag = `[drawing]${objId}[/drawing]`
            }
        }
        catch(exception)
        {
            console.log(exception)
        }
         
        return imgTag;
    }
}

使用Google Docs API检索namedRange中的文本 [英] Retrieve text in namedRange with Google Docs API

问题描述

推荐答案

3.部署Web应用.

4.使用Web Apps运行该功能.

4. Run the function using Web Apps.

相关文章

其他开发最新文章

热门教程

热门工具

登录关闭

使用Google Docs API检索namedRange中的文本 [英] Retrieve text in namedRange with Google Docs API

问题描述

推荐答案

3.部署Web应用.

4.使用Web Apps运行该功能.

4. Run the function using Web Apps.

相关文章

其他开发最新文章

热门教程

热门工具

登录 关闭

登录关闭