Embed Spreadsheets

  • 1
  • Question
  • Updated 5 years ago
  • Answered
Hello,

I would like to embed a spreadsheet so my table data is displayed within the web page, is this possible?

Thanks,

Chris
Photo of Chris

Chris

  • 33 Posts
  • 0 Reply Likes

Posted 7 years ago

  • 1
Photo of jeremy

jeremy, Employee

  • 1349 Posts
  • 90 Reply Likes
Hello Chris,

You can do this with Yola using a tool such as Google Docs.

It is a bit of a process (I am including steps) so please bear with me.

Step 1 - Adding the spreadsheet to your site

1. Log into your Google Docs account. If you do not yet have a Google account, you will first need to create one following the steps on the Google Docs website.
2. Create your spreadsheet in Google Docs.
3. Click on the drop-down arrow new to “Share”, and select “Share” from the list.
4. Under “Permissions”, click “Change” (it’s next to “Private - only the people below can access”).
5. A page will open up on your screen. Select “Public on the web”.
6. Once you have made your selection, you can then choose whether you want to have the spreadsheet open for anyone to edit.
7. Click “Save” and then “Close”.

Step 2 - Publishing the spreadsheet

1. Click the drop-down arrow next to “Share” and select “Publish as a webpage”.
2. Select the sheets you’d like to publish and click “Start publishing”.
3. You will see “Get a link to the published data” and a drop-down menu with various options.
4. If you would like to embed the spreadsheet on your page, select “HTML to embed in a page”.
5. Copy the HTML code that is generated. You can add to your webpage using the HTML Widget.
6. Back on your Yola site, drag and drop a HTML Widget onto your page. It is under “Basics” in the Sidebar.
7. Paste the HTML code into the HTML Editor that opens up on your screen.
8. Click “Save” and your spreadsheet will display on your webpage.

Note: This spreadsheet is not editable.

I hope this helps. If you need any further assistance, please let us know.
Photo of Shawn Donohue

Shawn Donohue

  • 1 Post
  • 0 Reply Likes
I found another way that you do not need Google docs that I think works OK. I saved my OpenOffice spreadsheet as a web document. I then went to the folder where it was saved, used right click to "Open with" and selected Notepad. I then right clicked and "Select all" and then right click and "Copy". I then went to my page in the Yola sight, placed an HTML widget where I wanted the document to be and Pasted the HTML into the page. Did exactly what I wanted.

This might help for those that do not want to start a gmail account for Google Docs.

If there is a reason to not do this, then someone can comment on it.
Photo of Gop

Gop

  • 7473 Posts
  • 2115 Reply Likes
Hi Shawn,

Good work on investigating and improvising this fix.

I haven't tried with OpenOfiice but have with Excel. The problems I hit with Excel were the setting up of borders, margins, colours and cell outlines. Quite a detailed task.

Does OO allow all these to be configured on the OO side of the process or do you still need to edit the placement after dumping the code into the HTML widget?
Photo of ShawnD

ShawnD

  • 1 Post
  • 0 Reply Likes
Now that you mention it, I did have trouble resizing a column. On my spreadsheet, it is narrow but despite what I do, the embedded code always shows the original wider column. I am not too worried about the formatting but I am sure that someone on here or with Yola can provide a fix....? I have been experimenting with pasting the code of an html page into a web page ie even a wordpress site and have had hit and misses with it. I mostly blame myself as I stumble around with this stuff but for the most part, end up with a usable product, just not as fancy as some....;-)

I just went to get the link and noted the right justification of a couple of columns. I may work on this as I do not like it but otherwise, here is the link, the result of my previous post.

http://www.courttimesquashleague.com/...

Cheers,