Embed excel worksheet

[brynj]

Has anyone embedded an Excel worksheet from OneDrive successfully ?

Using the code generated by OneDrive and then pasting into WYSIWYG using the HTML option.
I have tried and failed, with differing results based on my selection in OneDrive. but none work correctly.

Weirdly one lot of code just replicates anything else on the page and doesn't show the spreadsheet at all.

Is it possible WYSIWYG needs some additional entries ?

Happy to provide demo if needed.

Thanks

Samples of code provided by OneDrive: (3 versions based on different selections in OneDrive)

<iframe src="https://1drv.ms/x/c/d1b632457a88ef16/IQ ... Y0n0x6cZ7o" width="900" height="900" frameborder="0" scrolling="no"></iframe>
------------------------------------------------------
<iframe width="400" height="350" frameborder="0" scrolling="no" src="?wdAllowInteractivity=False&AllowTyping=True&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True&wdInConfigurator=True&wdInConfigurator=True"></iframe>
--------------------------------------------------------
<iframe width="700" height="775" frameborder="0" scrolling="no" src="?wdAllowInteractivity=False&AllowTyping=True&Item='Data'!B1%3AQ30&wdHideGridlines=True&wdDownloadButton=True&wdInConfigurator=True&wdInConfigurator=True"></iframe>

[AliGW]

There's a paid app that will do this (it exists because it isn't possible natively). I believe the app is called something like Spreadsheet Converter.

The best way to go would be to link to the file oniine, especially if you want it to be interactive.

[brynj]

There's a paid app that will do this (it exists because it isn't possible natively). I believe the app is called something like Spreadsheet Converter.

The best way to go would be to link to the file oniine, especially if you want it to be interactive.

Spreadsheet Converter seems to concentrate on using spreadsheet as a calculator (online sales) and also quite pricey for my needs.

Am I right that if I link to my excel spreadsheet on the server then the user would need the same version of excel locally so the formula's/VBA works as expected?

My limited understanding is that linking from OneDrive is exactly what I need but the code generated seems to have issues when used in WYSIWYG - hence I wonder if WYSIWYG needs additional settings for it to work correctly. (NOTE: I'm not blaming WYSIWYG)

The person who will be using this is even less computer literate than I am so I am trying to combine everything into one site. At the moment I can give him the spreadsheet to create a pdf and then upload it through WYSIWYG onto the website as a separate process.

[AliGW]

You don't need to show the spreadsheet on your page. You can just provide it as a downloadable document via a link.

I have been helping on ExcelForum since 2013, so you are talking to the right person!

Yes, the recipient will need to have the same or a newer version to ensure compatibility.

This is a great site for checking what's available in each version: https://bettersolutions.com/excel/funct ... ctions.htm

Clearly they'll need to be using their desktop, as VBA doesn't work in the online browser version. If you want to collaborate, then you should be doing that through OneDrive, not via a website.

If you want a tester, just shout.

[brynj]

You don't need to show the spreadsheet on your page. You can just provide it as a downloadable document via a link.

Just to clarify .....

I would need to share the entire excel file which comprise of 3 worksheets containing table, data selection and pdf tab
Basically in the 'data' tab the user selects from a drop down list populated by the table (various VBA instructions going on in this page) - this then populates the pdf tab which can be printed as a document for storage, display and download on the website.

My concern is the end users (which is probably only two people) do not have the same version of Excel and that will cause complications.

I was hoping by embedding it then it could be amended directly there.

[brynj]

Interestingly this is what I currently get using One Drive....

When just embedding the spreadsheet I get this .... but the drop downs do not work. ( I guess I can amend the sizing so more is shown but not bothered until I can get it working)
https://e.pcloud.link/publink/show?code ... xISXBg21IV

When I tell One Drive to allow editing so the drop downs work I get this from the resulting code ..... no spreadsheet but WYSIWYG duplicates the top image a couple of times!
https://e.pcloud.link/publink/show?code ... cKlXhdttO7

[Pablo]

There is no standard solution to display excel sheets, because this is a complicated format that is not natively supported by HTML.
However, there are several extensions that can display CSV files.

[brynj]

Thanks Pablo - sadly a .csv does not support the complexities of the spreadsheet

At least I know not to spend more time on this.

[BaconFries]

Maybe the following YouTube tutorial by Dapson Ishmael would be of be of interest.
https://youtu.be/N04_rR_RGUc?si=JbR3Tifv6f4L0cHc

[brynj]

Maybe the following YouTube tutorial by Dapson Ishmael would be of be of interest.
https://youtu.be/N04_rR_RGUc?si=JbR3Tifv6f4L0cHc

Thanks BaconFries but this relates to static .csv spreadsheet which will not work for me.

It appears what I need is not possible but thanks for the link though.

[brynj]

This is what I wanted to do !

https://www.youtube.com/watch?v=5ViZ7aOxF3I

[brynj]

I appreciate Pablo has said this is not really possible but I am so close ....... I have managed to import the excel spreadsheet using the html option:

The problems I now have is I am unable to get the spreadsheet full width.

Just in case anyone has any suggestions ?

https://e.pcloud.link/publink/show?code ... hEHuM5zLi7

Thanks

[AliGW]

How wide is the page? What's the maximum width of the container? We need to see a WWB file rather than a picture.

If you get this working, I do hope you will share a complete tutorial for everyone's benefit.

[brynj]

Hold the bus - its now correct width.

https://e.pcloud.link/publink/show?code ... 9nxVagCGT7

[brynj]

Ok - still work to be done .....

Only some of the calculations are being observed

The one that isn't working is:

Every Thursday the list should be populated with "Gorleston, (The Promenade) taken from the table" - this is being ignored when the month is changed

It works in desktop Excel - I am guessing its a security issue ....

[AliGW]

I have just embedded a Google Sheet (non-editable but dynamic) into a page using an inline frame. Seems to size as I want it to inside a flexbox.

[brynj]

Fair enough .... I was using the html in a layout grid - the mistake I was making was trying to size in WYSIWYG when in fact I should have been amending the html. Trial and error with sizing arrived at correct sizing.

Stumbling block now is the ignoring of VBA ...... do you think that could be a webhost issue ?


https://e.pcloud.link/publink/show?code ... EDRfaE6rvy

[AliGW]

I doubt you'll get round that. It doesn't work in the browser version of Excel, so I am not surprised it won't in an embedded snapshot online.

You have to explicitly enable VBA in a desktop file - you are expecting it to work on what is essentially a public page.

However, month changes may be doable without VBA - it depends.

[brynj]

Hmmm - you are probably right

So close and yet so far haha ............

[AliGW]

If you want help with the spreadsheet, let me know - we’d need to take that away from here, though.

[BaconFries]

Stumbling block now is the ignoring of VBA ...... do you think that could be a webhost issue ?

It is not a server issue and the answer is no, you cannot run Excel VBA directly in a web browser.due to it relies on local system libraries and the desktop application engine, which are not supported by Excel for the web.
With that said Microsoft has created Office Scripts to provide some of that VBA functionality for Excel Online.

[brynj]

Thanks Ali.

I'm not sure that it will function without VBA - on change of month it needs to pull out the dates for Tuesdays. Thursdays & Fridays to create a list with the relevant number of cells for manual entry from drop downs. Thursdays are automatically populated with "Gorleston ...... " as that is constant but it changes which cell based on how the Thursdays fall in each month. On the PDF tab the printable sheet also expands and contracts based on the number of 'walking' days each month.

If you think that's possible without VBA I could contact you elsewhere to progress.

I should add that this something I am doing for our group of (retired) walkers to just make it easier for the guy who's currently spending time on this each month.

[AliGW]

I’ve got TawkTo on my website - if you send me a message, we can take it from there.

[brynj]

Ok thanks - i’m off soon for a couple of weeks but it will keep until i get back.