BBcode to display excel spreadsheet with google docs

[willie53]

I have been looking for bbcode to display excel spreadsheet that works i did find a couple of bbcode that can display google docs and the ones i have got do work except the excel one the replacement code is.

<div align="center"><iframe src="https://docs.google.com/document/pub?id={param}&amp;embedded=true&single=true&gid=0&output=html&widget=true" width="95%" height="500">IFRAME Not Available. <a href="https://{option}.google.com/document/pub?id={param}">Direct Link to Google Document</a>.</iframe></div>

at the moment the only way i can display the sheet is embed it using iframe and it does work the only probem is to enable html which is dangerous a much better way is with bbcode so you could diplay it like this

[gs]0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc[/gs]

Regards Willie

[glennrocksvb]

Since this is not a mod request or suggestion, I moved it to BBCode forum.

[willie53]

Solved this problem the amended code is

<div align="center"><iframe width="95%" height="500" frameborder="0" src="https://spreadsheets.google.com/pub?key={param}"&hl=en&single=true&gid=0&output=html&widget=true'>IFRAME Not Available. <a href="https://spreadsheets.google.com/pub?key={param}"&hl=en&single=true&gid=0&output=html">Direct Link to Spreadsheet.</a></iframe></div>

The problem was there was ' instead of " between href="https and ={param}"

[Mellow]

Mine stopped working for 4.2.4 and no idea why, have tried many different adjustments but kinda lost... sorry, I know this is a vb 5 section.

[glennrocksvb]

Generally, BBCodes should work in all vB versions 3, 4 and 5 as nothing has changed in the implementation.

But a BBCode will not work in other versions if the replacement code uses Javascript and if it accesses vB version specific HTML markup on the page. This is rare but it could happen.

[willie53]

Mine stopped working for 4.2.4 and no idea why, have tried many different adjustments but kinda lost... sorry, I know this is a vb 5 section.

Mine also stopped working maybe the way google docs is now accessed has changed i will be looking for a way around this

[willie53]

Found a way around this at last solution posted @ vborg

<div align="center"><iframe width='95%' height='600' frameborder='0' src="https://docs.google.com/spreadsheets/d/{param}/pubhtml?widget=true&amp;headers=false"></iframe></div>