Hi,
Please see my reply to a similar question earlier today.
There are parameters you can specify in the url called sheet=<sheet name>,
and range=<A1:B5>
Apparently this is not documented well enough, so we will improve it soon in
our documentation.
VizGuy
On Thu, Nov 20, 2008 at 6:51 PM, Pragan <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> If we use the query function to connect to a spreadsheet and draw a
> chart, how does it know which sheet it has to connect to?
> for example: My spreadhseet has four sheets and each has data from a4-
> f222 and if I write this in the api
> var query = new google.visualization.Query('http://
> spreadsheets.google.com/pub?
> range=A3:F222&headers=-1&key=paMtebgrLy64_fkHVnLkCgg&gid=1'<http://spreadsheets.google.com/pub?range=A3:F222&headers=-1&key=paMtebgrLy64_fkHVnLkCgg&gid=1%27>
> );
> (I have changed the key)
>
> how it knows which sheet it has to connect to? The above query works
> fine by drawing the chart for the values in sheet 1 . How we have to
> define, if I want the above query to connect to sheet 2.?
>
> Assuming both the sheets in the spreadsheet are published.
>
> thanks
> pragan.
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
