Publish Excel spreadsheet to webpage

Question

Publish Excel spreadsheet to webpage

Anonymous

I must be missing something and so I come her seeking some guidance.

We Share spreadsheets via OneDrive. Several of the worksheets within a workbook need to be published/displayed as a webpage within our facility. We have monitors which will display these pages by navigating to a link.

Need the webpage to live in the cloud for retrieval.
These are view only
With the spreadsheet shared in OneDrive currently, when the data is updated by anyone we need the webpage to update as well.

We do this process currently using Google Sheets. I am just not finding the steps to do this with Excel that are as seamless.

We do have Sharepoint if that is a better suggestion for housing/retrieving webpages.

Regards,

Lance

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

Dear Lance,

If it is a SharePoint page and share it with an external user, you can add the external users to Microsoft Entra via the steps in Quickstart: Add a guest user and send an invitation | Microsoft Learn, share the Excel file with them with the View permission, embed the file with the Embed web part via the steps in Embed your Excel workbook on your web page or blog from SharePoint or OneDrive for Business - Microsoft Support and Add content to your page using the Embed web part - Microsoft Support, share the page with him and then deploy the Modern Script web part via the the steps in SharePoint | Online | Best Practice | install Modern Script Editor Web Part for SharePoint Online Modern Site. (microsoft.com) and finally add the JavaScript code as follows to refresh the page every 5 seconds or long time to auto-refresh the data in the embedded workbook.

setTimeout(function () { 

  location.reload(); 

}, 5000);

</script>

If it is a custom website page, you can use the Anyone link of the workbook in the embedded code and share the workbook with the users with the View permission.

You can use the HTML code to see if the embed code works and apply it to your own website.

<!DOCTYPE html>

<html>

</html>

Some iframe may not be displayed on the webpage because of the X-Frame-Options header settings. You may edit the webpage setting to work around the issue based on your environment.

Thanks for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Share via

Publish Excel spreadsheet to webpage

0 additional answers