Display Spreadsheet

[brynj]

I want to display a spreadsheet (which is updated periodically and uploaded to the server) on a webpage.

I tried 'Inline Frame' but that doesn't display the spreadsheet (surprisingly it downloads the file!).

What can I use for this please ?

[AliGW]

Did you follow these steps?

Steps to Embed an Excel Spreadsheet
Upload your file: Save or upload your .xlsx workbook to OneDrive or SharePoint.
Open in the browser: Click on your workbook to open it in Excel for the Web.
Get the embed code: Navigate to File > Share > Embed.
Customize options: In the panel that opens on the right, you can choose whether to display the entire workbook or a specific table/chart. You can also toggle whether users can sort data, type in cells, or see gridlines.
Copy the code: Copy the generated HTML code (which starts with <iframe...).Paste on your website: Paste this iframe code into the HTML or custom HTML block of your website's editor.
Google AI

I managed to embed a GoogleSheet using an inline frame - it's the same procedure and should work.

[brynj]

Thanks Ali.

Sadly that's too much of a faff. If there is no easy way then I will have to think again.

In an ideal world I just want to upload the amended spreadsheet to the server and WYSIWYG displays it.

When at home it is easy for me just to copy and paste the spreadsheet into WYSIWYG but when away and only using my ipad it becomes more complex. I can open/amend the spreadsheet in 'Numbers' and use an FTP program to upload to server.

When I talk about a spreadsheet, in this instance, it is really just a way for me to display information. there are no calculations going on.

I think I will need to convert the ipad spreadsheet to a pdf as 'inline Frame' will display that.

thanks for response.

[AliGW]

Too much of a faff? It's a one-off operation - once it's set up, it's done, and changes in the Excel file reflect real-time on your web page. You don't have to keep doing it each time you make a change.

[brynj]

Too much of a faff? It's a one-off operation - once it's set up, it's done, and changes in the Excel file reflect real-time on your web page. You don't have to keep doing it each time you make a change.

Ah ok thanks

[Pablo]

Excel is not a web format, so it can only be displayed on a computer via Excel.
There are some dedicated Excel to HTML third party tools but they are usually not free.

Alternatively ,you can save the file as CSV and use one of the data list extensions to display the data on your website.

[BaconFries]

Hasn't this already been asked previously?
https://forum.wysiwygwebbuilder.com/vie ... 92#p508692

[brynj]

Hasn't this already been asked previously?
https://forum.wysiwygwebbuilder.com/vie ... 92#p508692

Not the same - on that occasion I wanted a user to be able to use the spreadsheet on the website (make selections etc.) the same as in excel, so a more complex solution was needed.

With this question I simply wanted to display a static spreadsheet, which I hoped would be simple.

[AliGW]

It is if you follow those instructions I gave just once. I don't see what the problem is.

[BaconFries]

It is still a excel file what ever way you look at it which is not a web safe format whether it is static or the end user can make selections to it...

[brynj]

It is still a excel file what ever way you look at it which is not a web safe format whether it is static or the end user can make selections to it...

Of course but the difference between questions was interaction or just viewing. As you say excel, without further intervention, is a non-starter.
As of now I plan to save as a pdf and use 'Inline Frame' to display on webpage.

[AliGW]

Excel is NOT a non-starter.

Have you even tried what I suggested? You set it up once and then changes that you make in the Excel file are automatically shown on your web page.

[brynj]

It is if you follow those instructions I gave just once. I don't see what the problem is.

It just means I need to setup another account with either OneDrive or Sharepoint, while its already on the server so would be easier to use from there.

I agree not difficult but something extra I can do without.

As I said earlier, a solution was only needed for short periods of time when away from home.

Appreciate the info though.

[AliGW]

In the time you have spent discussing it here, you could have done it! But you have decided not to - your prerogative.

[brynj]

In the time you have spent discussing it here, you could have done it! But you have decided not to - your prerogative.

OK - I have tried to do it but have complications.

When I upload the file the first time it works. If I upload an amended file it adds '1' to the file name (no option to replace) so needs new code.
If I delete the older file first so the new file can be saved under the same name it needs new code.
If I try to 'open with' - the old file (to edit) using 'Numbers' it says I don't have permission so cannot open file.

How do you edit/replace the file in OneDrive so it 'Just works' ?

[AliGW]

You don't upload again. You edit the file where it is via the browser.

If this doesn't suit you, then by all means take a different approach.

[brynj]

You don't upload again. You edit the file where it is via the browser.

If this doesn't suit you, then by all means take a different approach.

Sorry Ali - out of curiosity have you done this on an ipad?

I can just touch the file in the OnePage App and it opens as a display to view but not obviously in Safari - I cannot amend anything - if I use 'Open in Another App' then Safari browser isn't an option and 'Numbers' says no permission.

[AliGW]

No, sorry - I don't have an iPad. However, you should be able to access the file via 365 online. Years ago, the school I worked at provided us with iPads and I don't recall any issues accessing Excel workbooks via the online portal.

https://www.microsoft.com/en-gb/microso ... or-the-web

[onlye]

if your goal it to display a table of data then maybe setup a mysql database and create a table with you information. Wizzy has some great database tools that allow you to display and update the table from a web browser. Once setup you can easily edit the table from the iPad or even your phone.
I use this method for several clients to maintain and display the tabluar data on their websites.

here is an example for marriage license searches, the customer has a hidden webpage to edit the data using standard wizzy tools

https://circuitclerkmarioncountyms.gov/ ... earch3.php

[brynj]

Thanks Onley - I will have a look.