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.
On Thu, Jan 31, 2013 at 1:24 PM, Fred Hagemeister <[email protected]> wrote: > 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. > > > -- 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.
