Show / Hide Table of Contents

    Embedding O365 and Google Documents

    PLEASE NOTE THAT WE CURRENTLY DO NOT SUPPORT G SUITE!

    Embedding O365 documents

    Please note that you will need the embeddable URL of your document to be able to use it in our system. Otherwise it will not work due to cors-policy issues.

    If you have a URL like: https://docs.google.com/presentation/d/e/2PACX-1vR6jTPScvnRhgrSv9q/**pub**?start=false&loop=false&delayms=3000&slide=id.p

    You need to change it to: https://docs.google.com/presentation/d/e/2PACX-1vR6jTPScvnRhgrSv9q/**embed**?start=false&loop=false&delayms=3000&slide=id.p

    First, you need to obtain a shared URL for your document.

    • Go into your OneDrive account and click the share button on your file.

    • Then click the "copy URL" button.

    Now you have your document's shared URL, which you can embed using our custom widget.

    Select the "URL" as the content type, and paste the shared URL from the previous step as the URL, and add "&action=embedview" to the end of the URL.

    Your URL should look something like this:

    https://tenant-my.sharepoint.com/:p:/g/personal/teanant/EWg5asd4BuNi1yTWihPWB5a7F3wmsUw?e=9Bndf1&action=embedview

    You can also enable Interactivity, to make your widget interactive (ability to scroll in the document, change pages in a presentation).

    This method will work for EXCEL, PPT, and WORD files.

    For EXCEL files you can use these query params to perform different actions:

    wdHideSheetTabs=True : Hides the sheet tabs that are displayed at the bottom of all sheets in a workbook.

    wdAllowInteractivity=True : Lets you interact with the data if your workbook has a table or PivotTable that can be sorted and filtered.

    Item=itemName ** : Displays a specific item. If your workbook includes a chart, table, PivotTable, or named range, and you want to display only one of the items in your web page, use the **Item parameter to specify that item. For information about named ranges and named items in Excel workbooks.

    **ActiveCell=CellName ** : Specifies the active (selected) cell in the embedded workbook when the web page opens. You can specify the active cell by cell reference (such as A1) or by name.

    wdHideGridlines=True : Hides worksheet gridlines for a cleaner look.

    wdHideHeaders=True : Hides the column and row headers.

    wdDownloadButton=True ** : Includes the **Download button so viewers can download their own copy of the workbook.

    Add the query param to the end of the URL after the &action=embedview, like: &wdHideSheetTabs=True.

    Embedding Google documents

    • To embed Google documents simply open the document and select "publish to the web" in the "file" menu.

    • Then go to the "embed" tab click publish, and copy the URL.

    Now you have your document's shared URL, which you can embed using our custom widget.

    Select the "URL" as the content type, and paste the shared URL from the previous step as the URL.

    Your URL should look something like this:

    https://docs.google.com/spreadsheets/d/e/2PACX-1vTHb75CliYAhjj_jlcTMSoUC0ocmZgHWSxT_/pubhtml?widget=true&headers=false

    You can also enable Interactivity, to make your widget interactive (ability to scroll in the document, change pages in a presentation).

    For Google Spreadsheets you can use these query params to perform different actions:

    gid={{gid_id}} : Display a specific sheet with it's sheet ID.

    gridlines=false / true : To display gridlines.

    sheetnames=true / false : To display sheet names.

    Add the query param to the end of the URL after the ?widget=true&headers=false, like: &gridlines=false.

    Sorry, your browser does not support inline SVG. article updatedarticle updated10/14/2022 5:10:15 AM (UTC)10/14/2022 5:10:15 AM (UTC)
    Feedback     Back to top Copyright © Geomant