EditGrid Spreadsheets

By michal frackowiak

Description

EditGrid is a nice application that allows the creation of quite sophisticated spreadsheets. And, more importantly, can be embedded in other web pages.

Simply create a spreadsheet, set share to "Public" (you can choose between Read Only or other nice options), go to "Publish" or "Post to blog" under "Settings", set the options you like and copy&paste the code

Example spreadsheet follows:

Code

[[embed]]
<div style="margin-bottom:2px;font-size:10px;background-color:white"> <a style="font-weight:bold;text-decoration: none;color:#4D5782" href="http://www.editgrid.com/user/redbeard/Wikidot_test" target="_blank">EditGrid Spreadsheet</a> by <a style="text-decoration: none;color:#4D5782" href="http://www.editgrid.com/user/redbeard" target="_blank">user/redbeard</a>.</div> <iframe frameborder="0" src="http://www.editgrid.com/publish/html/user/redbeard/502723/A1:J10?" style="border:0;height:320px;width:100%">&nbsp;</iframe>
[[/embed]]

In action

EditGrid Spreadsheet by user/redbeard.

Or you can even use a mini-editor:

EditGrid Spreadsheet by user/redbeard.

Rate this solution

If you think this solution is useful — rate it up! Or dump it otherwise.

boettcht 1212505329|%e %b %Y, %H:%M %Z|agohover

I really like this solution but when I try it out I'm getting an error of "Sorry, no match for the embedded content." Any thoughts?

Re:

tarkowski 1213017753|%e %b %Y, %H:%M %Z|agohover

The information above is not correct:

Wikidot seems to require the <div> header that goes before the iframe code provided by EditGrid. There seems to be some javascript in it that matters, I couldn't even change the name of the spreadsheet that's in one of the <a> enclosures. One also needs to add the [[embed]] tag for this to work.

I am not certain enough of what's going on with this piece of code to fix this instruction - but someone should.

hide the div

najas 1214358164|%e %b %Y, %H:%M %Z|agohover

hi,

it is a bit disturbing that you are bound to that div. However just add display:none; to the style attribute to get rid of it. You can then put whatever you want above it.

chichirinoda 1223576194|%e %b %Y, %H:%M %Z|agohover

I have the same issue as boettcht up there, and I apologize but I'm a newbie and don't really understand the solution given in response. I've tried placing the iframe script alone, within an embed tag, within a div tag, and within both an embed and div tag, and none of these solutions works. Would someone be willing to take me step by step through the process?