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 On Thu, Jan 31, 2013 at 1:45 PM, George Adams <[email protected]> wrote: > 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 <[email protected]>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 [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/simile-widgets?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/simile-widgets?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Cheers, 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/simile-widgets?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
