Announcement

Collapse
No announcement yet.

BBcode to display excel spreadsheet with google docs

Collapse
X
Collapse
First Prev Next Last
  • Filter
  • Time
  • Show
Clear All
new posts

    BBcode to display excel spreadsheet with google docs

    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.
    Code:
    <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
    Code:
    [gs]0AmOHO6Cm8vvAdFR2b0dMMnVwMUE0MlpXYnowWnowWWc[/gs]
    Regards Willie
    Wise men say nothing Fools never listen

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

    Comment


      #3
      Solved this problem the amended code is
      Code:
      <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}"
      Wise men say nothing Fools never listen

      Comment


        #4
        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.

        Comment


          #5
          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.
          Last edited by glennrocksvb; 04-28-2017, 06:52 PM.

          Comment


            #6
            Originally posted by Mellow View Post
            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

            Wise men say nothing Fools never listen

            Comment


              #7
              Found a way around this at last solution posted @ vborg
              Code:
              <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>
              Wise men say nothing Fools never listen

              Comment

              Working...
              X