Submitted by viking on 2021/09/03 22:20

Is it possible to embed an Excel sheet in the document pane? Either from a local Excel workbook or from a Google Sheet?

I tried to embed a Google sheet which uses an iframe, but all I got was the html code if I simply paste.:

<iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-xxxxxxxxx/pubhtml?gid=0&…"></iframe>\

 

If I insert it as html code, I get a blank page.

I am able to use this code to display the spreadsheet when I make a post (as Admin) in a SMF Forum:

[html]

<iframe src="https://docs.google.com/spreadsheets/d/e/2PACX-xxxxxxxxx/pubhtml?gid=0&…"></iframe>\

[/html]

Still doesn't work in the document pane though.

p.s. The  'xxxxxxxx' replaces part of original code for security reasons.

Comments

@Pierre,

1.  It is strange, it shows that the old post to 0.9.90a was updated 1h36 min ago, but when I read it, I see no recent replies? So, Excel should work after editing the registry? I am using Office 2010 on WIN7.

2. Regarding google sheets, I needed to publish the sheet first to get the code (e.g. see here https://googledrive.in30minutes.com/google-sheets-embed-live-spreadsheet/ ). This works when I post the code in a web Forum (as Admin):
See attached code (it gets messed up when posting here).

x

 

 

However, here is what I get after inserting this code as html in the document Pane (and using Internet Explorer 11):
x

 

  1. I was researching regarding your question and ended up on that page. I simply updated a broken link (which brought the page to the updated list)
  2. The Doc pane must be in Browse mode for such code to work. Even then, I don't think it will work... in part because of IE, in part because you're not logged into Google (unless the sheet is public) It works in IE11. I'll see why it doesn't work in the Doc pane

  1. In IQ Doc pane, do Menu > File > New > New HTML File
  2. Paste the embed code [edit] in Code view or use Insert > HTML Code [/edit]
  3. Switch to Browse mode

IQ then displays the sheet correctly

I'll see if I can this to work for embedded content too

 

Sorry, it doesn't work for me. Here is what I get in Browse mode:

x
I also only get the code if I remove the [html] tags. Are they supposed to be there?
 

What did you mean by "I'll see if I can this to work for embedded content too". Isn't that what I just tried to do?

Getting closer (I removed the [html] tags; I assume that they are not needed?):

x

The sheet is empty. It is supposed to have 3 rows (from my SMF post):
x
It is strange that the content is missing in IQ...?

Getting closer indeed

IQ needs to be using IE 11 for its renderer. Tools > Options > 1.4.1 (IE version)

(you must restart IQ for this setting change to be applied)

Yes! That works now :-). Thanks!
It was not very intuitive and should maybe be written up in the manual somewhere.

Next, and more important, issue is to be able to insert a local Excel file. I edited the registry. Maybe we should continue this issue at the other thread (where I posted my result):   https://infoqubeim.com/drupal5/index.php/node/3791#comment-24257

You are right. It didn't work in IQ for some reason. It works when I post it in a forum (as Admin). Here is what I get in IQ:

x

Seems to be some security issue in IQ? Maybe related to the issue that I cannot switch tabs with Excel in IQ?

Here is what i get in the Forum:
x

 

Sorry for digging into such an old thread, but I'm experiencing this embed not displaying issue. Changed to 11 per instructions above. (is that instruction still valid?) Nothing seems to work to get the sheet displayed also tried to do the iframe embed with a live editable sheet no luck there either. Appreciate any help. Thanks.

How do I ?