locked
Embedding Excel spreadsheet in iFrame - What Parameters are Available? RRS feed

  • Question

  • We have SharePoint Foundation 2013 with Office Web Apps installed. I would like to display an excel spreadsheet on a page and without Excel Services, have arrived at the following solution:

    Add a Content Editor web part to the page.  Edit the coded and insert the spreadsheet as so:

    <iframe src="https://mysharepointsite.com/BI/Shared%20Documents/ExcelFileName.xlsx?web=1"
    width="565" height="445"
    </iframe>

    I would like to be able to use additional parameters like wdHideSheetTabs, wdHideHeaders, and ActiveCell but none of the parameters that I add has any effect except the width and height.  My questions are:

    1) While embedding Excel in an iFrame, is there a way to use these additional parameters

    2) If so, what is the proper syntax?

    3) If not, is there another solution considering that we don't have SharePoint Enterprise Edition?

    Thanks so much!

    Tuesday, December 15, 2015 8:46 PM

All replies

  • Hi,

    To Embedding Excel spreadsheet in iFrame with many parameters:

    <iframe width="500" height="200" frameborder="0" scrolling="no" src=" https://host/personal/user/_layouts/15/guestaccess.aspx?guestaccesstoken=2UdAHGlFpWVaJjkI32xuisKCQsULG6M6b%2fIjG1LYpRM%3d&docid=166d02b42f5a1443781a1de428d9518ee&action=embedview&wdbipreview=true&wdHideSheetTabs=true&wdAllowInteractivity=True& Item=PivotTable1& ActiveCell=B4&wdHideGridlines=True &wdHideHeaders=True& wdDownloadButton=True”>

    Refer to the following article to Embed your Excel workbook on your web page:

    https://support.office.com/en-ca/article/Embed-your-Excel-workbook-on-your-web-page-or-blog-from-SharePoint-or-OneDrive-for-Business-7af74ce6-e8a0-48ac-ba3b-a1dd627b7773

    Best Regards,

    Lisa Chen


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Thursday, December 17, 2015 9:35 AM
  • Hi Lisa,

    Thanks for the reply.  Unless I embed my spreadsheet using ".xlsx?web=1", our SharePoint site will only prompt me to download or open with Excel.  It just doesn't display the contents.  Any parameter that I add after ".xlsx?web=1" causes an error and the spreadsheet won't display.

    Do you have any more information about what ".xlsx?web=1" does?

    Thanks again!

    Monday, December 21, 2015 8:08 PM