It’s possible to embed an Excel workbook held on OneDrive into your web page. Not just a static image, but a fully interactive spreadsheet.
The example here includes some simple security that requires the user to enter a User Name and Password. The passwords are Spw for Simon, Epw for Emma and so on.
Although the passwords are hard-coded in Excel, they’re on different sheets and are hidden. There is no option to download the workbook so users can’t access other people’s data - well, not easily.
This illustrates how you might use a single workbook that can be used by multiple users, avoiding the need to create lots and lots of spreadsheets for different people or purposes.
It uses Microsoft Excel Online. The Embed code used here comes straight from the Embed option on personal OneDrive where the spreadsheet is stored.
Any changes made to the spreadsheet will automatically be replicated here.