Re: [Simile-Widgets] Using Multiple Tabs of Google Spreadsheet?

[George Adams]

Fred,

I did this quite a while ago and it took some searching to figure out how to do it. It doesn't seem to be the same now. These things seem to be changing constantly in Google Docs

I went to the spreadsheet and then to the File>>Publish to the web menu item. In the lower half of the dialog box you can get a link to the "all sheets" or pick a sheet. The part that changes is in bold below. "&single=true&gid=1" It looks like single=true limits the feed to one sheet and gid=1 identifies the sheet. gid=0 is the first sheet, gid=1 the second.

https://docs.google.com/spreadsheet/pub?key=0AkgOV8gxmgPadFpENkNmZ2xIaklxS05fQUwxMDZ5a1E&single=true&gid=1&output=html

Hope this helps

On Wed, Jan 30, 2013 at 8:04 PM, Fred Hagemeister <fre...@gmail.com> wrote:

I have an Exhibit 2 site that I need to add another page with associated data that is in another tab of the same Google spreadsheet.  I can't figure out how to reference this second spreadsheet tab for the exhibit.  I would appreciate any help available.  Here is what I have:

(1) All tabs of my spreadsheet are published.  If I go to get the URL for all sheets with RSS output, I get:

https://spreadsheets.google.com/feeds/list/0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc/od6/public/basic?alt=rss

     Normally, I take that URL for the RSS output and convert it to the following for the Exhibit html:

          https://spreadsheets.google.com/feeds/list/0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc/od6/public/basic?&alt=json-in-script

(2) I can't ask for RSS output for a single tab, but if I ask for something like PDF, I get the following for the page I want:

https://docs.google.com/spreadsheet/pub?key=0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc&single=true&gid=3&output=pdf

(3) I've tried various combinations of the above, e.g., using docs.google.com rather than spreadsheets.google.com; using the gid=3 with the first URL, etc.\

What am I doing wrong, please?

Thanks,

Fred Hagemeister     

--
You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group.
To unsubscribe from this group and stop receiving emails from it, send an email to simile-widget...@googlegroups.com.
To post to this group, send email to simile-...@googlegroups.com.
Visit this group at http://groups.google.com/group/simile-widgets?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Fred Hagemeister]

Thanks, George.  Yes, I found that as well.  GID gives the tab order, but I couldn't get my exhibit to work with using any of the combinations I tried.  I tried various combinations of the two URL forms (docs.google and spreadsheets.google) and with and without the various passed values:

https://spreadsheets.google.com/feeds/list/0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc/od6/public/basic?&single=true&gid=3&output=html

https://spreadsheets.google.com/feeds/list/0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc/od6/public/basic?&single=true&gid=3&alt=json-in-script

https://spreadsheets.google.com/feeds/list/0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc/od6/public/basic?&alt=json-in-script

https://docs.google.com/spreadsheet/pub?key=0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc&single=true&gid=3&output=html 

https://docs.google.com/spreadsheet/pub?key=0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc&single=true&gid=3&output=json-in-script

Long before I ever needed to use a multi-tabbed spreadsheet, I seem to recall seeing something someone write and it was using the od6 format with substituting somewhere.  I don't recall exactly, and my attempts have failed so far.

Ugh, I think I figured it out.  I just tried substituting the number in od6 – I tried od7 and got the 2nd tab.  Since I need the 4th tab (GID=3), I tried od10 but that didn't work. For yucks, I figured to try hex, and it worked, i.e., oda worked (6 + 4 = a(hex) ).

I'm getting the page to appear fine in a browser ( https://spreadsheets.google.com/feeds/list/0AuYt-OtX_U5edGd4TGVudW1fY2dJRU93Rlc4SjdfNWc/oda/public/basic?alt=json-in-script ), but my exhibit seems to be having troubles, and I think I tried one to many things so I need to step back through my html and JS.

Thanks!

Cheers,

Fred

--
Cheers,

Fred Hagemeister

[George Adams]

Fred,

My exhibit that uses the second sheet is https://spreadsheets.google.com/feeds/list/0AkgOV8gxmgPadFpENkNmZ2xIaklxS05fQUwxMDZ5a1E/od7/public/basic?hl=en&alt=json-in-script

It uses od7 like you said. Maybe the original way to do this was with odX but Google changed that. The old way may be depreciated and might just stop working someday.

[Fred Hagemeister]

Just when I thought I had it figured out... I had some problems trying the hexadecimal route because some of the exhibits would not use the tabs that followed the hexadecimal sequence.  So I tried a test with a brand new spreadsheet and when I went to copy the rss link to the page, I noticed it had ody and not od6.  This suggests that 3rd digit can be any alphanumerical character.  I can try all of those to find the right one, but this seems like a wild goose chase for every exhibit that uses multiple-tabbed spreadsheets and especially if it is deprecated down the road.

So, does anyone know how to use Exhibit to reference a multiple-tabbed Google spreadsheet (most probably using the &GID=x URL framework?

Thanks,

Fred

[Fred Hagemeister]

FWIW, I found the a key that decodes the tab order and "od6" variables in the reference.  It's at http://stackoverflow.com/questions/11290337/how-to-convert-google-spreadsheets-worksheet-string-id-to-integer-indexgid .  Everything is now working for my 10-tabbed exhibit.

Cheers,
Fred Hagemeister