Remove ribbon and tabs from editable Excel sheet embedded into SP page

Question

I'm trying to embed an editable Excel sheet into a SharePoint page, but only want users to see the sheet itself (no tabs, no ribbons). I'm using the iframe parameter action=edit to make it an editable sheet, which works. I'm encountering the following issues, though:

1. I'm trying to use wdHideSheetTabs=True, but it seems to only work when the sheet is NOT editable. Is there another parameter/workaround that will remove the tabs?
2. There doesn't seem to be a parameter that removes the ribbon...I tried ui=none but it didn't affect any change.

Am I using the wrong command for the action parameter? If not, are there solutions to the issues above?

Answer 1

Per my test, I could reproduce the situation as you described above.

The parament wdHideSheetTabs=True only works with action=embedview, it cannot work with action=edit.

The only workaround is select Show tabs only in the excel file.

Reference:

https://support.microsoft.com/en-us/office/show-or-hide-the-ribbon-in-office-d946b26e-0c8c-402d-a0f7-c6efa296b527#ID0EBBD=Newer_Versions

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.