Zoho Sheet

By michal frackowiakmichal frackowiak

Description

Zoho is an online set of applications including a spreadsheet, word processor, database, presentation application and several others. For wikidot wiki users the benefit of Zoho is that you can integrate some of these tools in your wiki and the contents will be updated immediately you update the original at Zoho. This snippet focusses on the Spreadsheet.

If you want just a simple table in your wiki, that can be done using the features within wikidot itself. But to include a proper spreadsheet with perhaps charts and pivot tables, or even just views of your data, Zohosheet is a very good free solution and is currently one of the best online spreadsheets. You will need to create an account and can then immediately start to create your spreadsheet.

For this example we will use a spreadsheet of football transfer fees in Europe and will show two ways of integrating the spreadsheet into your wiki. After you've created your spreadsheet you can publish it in two ways. The first method publishes the entire spreadsheet to your site and gives you full functionality including the same tabbed sheets, pivot tables and charts that you have in your original. The second method publishes just ranges of your data, that is parts of the spreadsheet or views of your data. You cannot publish pivot tables or charts with this method, just the data, but it has the advantage over the first method of enabling you to put different views of your data on different pages of your wiki.

Creating your Spreadsheet

For this example we created a new spreadsheet and added in the data and renamed the tab at the bottom "Master". The only reason for mentioning this is that ithelps to remind a user that data should only be changed on the Master sheet.

zohosheet01a.png

We then created a pivot table showing the total spent by club, and a chart showing the total spent by year.

zohosheet02.png

Finally we created additional sheets showing the same data as on the Master sheet but was in transfer fee order and the other was in year order. Each cell in these sheets is linked to the Master sheet using the SohoSheet =Master.A2 formula (for example). We could have put these last two "views" on the same sheet as the master, they don't have to be on separate sheets. The data on these two sheets is not updated manually but updates automatically whenever you change any of the data on the Master sheet.

zohosheet06.png

Publishing the Full Spreadsheet

The first method of publishing is to put the whole spreadsheet on your wiki page. Go to the Publish menu and select "Embed in Website/Blog":

zohosheet03.png

A window with code will then appear which will look like this:

@iframe width="500" height="400" frameborder="0" scrolling="no" src="http://sheet.zoho.com/publish/strathview/untitled"> </iframe@

Make sure you add [[embed]] before it and [[/embed]] after it on your wiki page so that the result is:

You can click on the different tabs in exactly the same way as on the original spreadsheet at Zoho. It is possible to change the data on the spreadsheet on your wiki although the original data from the spreadsheet at ZohoSheet will be re-loaded next tine you go open or refresh the wiki page. So we recommend you only change any "live" data on the original spreadsheet at Zoho.

Publishing a Range of Data

The second method of publishing your Zoho spreadsheet is to select the data you want to publish - in this case we've selected all the data on the sheet called Euro which is ordered by transfer fee - and from the Publish menu select "Publish this Range" as shown below:

zohosheet05a.png

As with the first method, this will open a window with code which you should copy. In our case the Zoho code is:

@iframe src="http://sheet.zoho.com/publishrange.do?id=4fa9d6a05fbf6a13d85b091ddee0296e" frameborder="0" style="height:245px;width:422px" marginwidth="0" marginheight="0" scrolling="auto"> </iframe@.

Add [[embed]] before the code and [[/embed]] after it to get the following:

You can't change any of the data unless you go back to your original spreadsheet at Zoho, all it is is a view of the data but it is useful for putting different views of your data on different pages of your wiki.

Updating Your Data and Your Wiki

When you want to change any of the data on your spreadsheet, whichever method you have used to publish it, you should go back to the original spreadsheet at Zoho and change the data there. The next time you open or refresh your wiki page you will see that the data has been updated to show the new values. You do not need to re-publish the data, copy new code, update wiki syntax or do anything else - the data in your wiki updates automatically.

Snippet updated 22 February 2009 by RobElliott


Thanks to tsangk for this great snippet: conditional-blocks


text above inserted with:

[[include :snippets:if START |unique=1|type=equal|var1=%%name%%|var2=conditional-blocks]]
**##red|Thanks to tsangk for this great snippet:##** [[[code:conditional-blocks]]]
[[include :snippets:if END]]



Other snippets posted by michal frackowiak

Todo List - 18 Aug 2014 15:28
Multicolumn Layout - 17 Dec 2012 19:51
Zoho Writer - 16 Feb 2012 01:57
Zoho Show - 16 Feb 2012 01:55
Zoho Polls - 16 Feb 2012 01:53
WoW Tooltips - 16 Feb 2012 01:52
Widgetbox Panel - 16 Feb 2012 01:52
Video from Revver - 16 Feb 2012 01:50
Tabs - 16 Feb 2012 01:45
Standalone Page Buttons - 16 Feb 2012 01:44
Social Bookmarking - 16 Feb 2012 01:42
Simple Gallery - 16 Feb 2012 01:41
Remember The Milk Todo - 16 Feb 2012 01:39
Recent Changes (mini) - 16 Feb 2012 01:36
Rating Summary - 16 Feb 2012 01:35
Quimble Poll - 16 Feb 2012 01:33
Quikmaps Maps - 16 Feb 2012 01:33
Photobucket Widget - 16 Feb 2012 01:29
Page Previews (Snap.com) - 16 Feb 2012 01:29
Pabpixies Gadgets - 16 Feb 2012 01:28
MyBlogLog recent visitors - 16 Feb 2012 01:25
Meebo me - 16 Feb 2012 01:20
Layout With Tables - 16 Feb 2012 01:19
Instacalc - 16 Feb 2012 01:12
Include Any Page - 16 Feb 2012 01:11
Import the Digg Feed - 16 Feb 2012 01:11
Import a News Feed - 16 Feb 2012 01:10
Google Gadgets - 16 Feb 2012 01:05
Gabbly chat - 16 Feb 2012 01:02
Forum Summary for the Front Page - 16 Feb 2012 01:02
Footnotes - 16 Feb 2012 01:01
Foldable List - 16 Feb 2012 01:01
Flickr Images By Tags - 16 Feb 2012 01:00
Feedburner - 15 Feb 2012 00:53
Extra Side Bar - 15 Feb 2012 00:51
Embed Code From Other Services - 15 Feb 2012 00:50
EditGrid Spreadsheets - 15 Feb 2012 00:49
Cornify - 15 Feb 2012 00:39
Compact Feed Display - 15 Feb 2012 00:35
Collapsible Text Block - 15 Feb 2012 00:35
Center Video - 15 Feb 2012 00:28
Bibliography/Footnotes/Comments Listed in TOC - 15 Feb 2012 00:26
Babelfish Translation - 15 Feb 2012 00:25
Automatic Sitemap - 15 Feb 2012 00:25
Alexa traffic ratings - 15 Feb 2012 00:23
3d tagcloud - 15 Feb 2012 00:22


Rate this solution

If you think this solution is useful — rate it up!

rating: +22+x
Add a New Comment
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License