Hi, This is not documented from some reason, so we will add it very soon. 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 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. 3) See the docs about the grid parameter that lets you specify a range of cells (A1:C5). Regards, VizGuy 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) > > .. [1] Target URL > (http://spreadsheets.google.com/tq?key=r_Fp1ZkDtzsDzRJ23jmnc9w) > > Thnx in advance ! > > -- > Regards, > > Olemis. > > Blog ES: http://simelo-es.blogspot.com/ > Blog EN: http://simelo-en.blogspot.com/ > > Featured article: > ยก Bienvenido OpenSolaris 2009.06 ! - > > http://feedproxy.google.com/~r/simelo-es/~3/UY8IF3M3Alw/bienvenido-opensolaris-200906.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 -~----------~----~----~----~------~----~------~--~---
