> On Tue, Jun 9, 2009 at 5:51 PM, Olemis Lang <[email protected]> wrote: >> >> Hello ! >> >> I have a spreadsheet containing two sheets (Sheet 1 & Sheet 2). I >> tried to get the JSON for data in Sheet 2 through a url [1]_ but it >> returns back data in Sheet1 . This shouldnt be wrong, but I'd like to >> know what's the URL used to access the data in a different sheet >> inside the same spreadsheet (same ID) >>
On Wed, Jun 10, 2009 at 6:44 AM, VizGuy<[email protected]> wrote: > Hi, Hi ! > This is not documented from some reason, :-/ > so we will add it very soon. :) ... it would be nice to include something like that in the page about GViz API integration with Google Spreadsheets > Anyway - it is possible, and the usage is as follows > For a workbook with two sheets: Sheet 1, Sheet 2. > You can access a specific sheet as follows > > Sheet1 > https://spreadsheets.google.com/tq?key=ABCD&sheet=Sheet%201 > OR > https://spreadsheets.google.com/tq?key=ABCD&gid=0 > > Sheet2 > https://spreadsheets.google.com/tq?key=ABCD&sheet=Sheet%202 > OR > https://spreadsheets.google.com/tq?key=ABCD&gid=1 > Cool ! > Notes: > 1) Spaces in sheet names should be encoded as %20 > 2) gid - grid id which zero based. Each added sheet gets the next running id > regardless if grids are deleted. Q: So this means that if I create `sheet 1`, and later `sheet 2` and e.g. I (move sheet 2 to the left | delete sheet 1) then sheet 2 still has gid = 1 . Isnt it ? > 3) See the docs about the grid parameter that lets you specify a range of > cells (A1:C5). > Oh yes ! This is well documented in the page about GViz API integration with Google Spreadsheets (AFAICR I even added support for this in TracLinks expansion [1]_ for iGoogleGadget macro [2]_ included in TracGViz plugin [3]_ since version 1.3.1 ) I plan to include this «new» feature in the next version ;) I asked because there's nothing about this in docs, I just tried for the first time to add multiple sheets inside a spreadsheet, and later I didnt know how to get the data . And I knew that there should be a way ;) Thnx for your reply ! .. [1] tracgviz.wiki.GoogleDocsConnector (https://opensvn.csie.org/traccgi/swlcu/pydoc/tracgviz.wiki.GoogleDocsConnector) .. [2] iGoogleGadget macro (https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz/Macro/iGoogleGadget) .. [3] TracGViz plugin (https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz) .. [4] TracLinks reference (I'm still editing this page ;) (https://opensvn.csie.org/traccgi/swlcu/wiki/En/Devel/TracGViz/TracLinks#Reference) -- Regards, Olemis. Blog ES: http://simelo-es.blogspot.com/ Blog EN: http://simelo-en.blogspot.com/ Featured article: PyUMLGraph : Otra manera de contemplar el código - http://feedproxy.google.com/~r/simelo-es/~3/lLsxDz4Rkgc/pyumlgraph-mirando-al-codigo-de-python.html --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
