Hey,
Thanks for the reply. I guess I figured it out that we can call them
using the gid. As I was trying to publish different sheets in a
spreadhseet, the only difference I am able to see is this "gid" and it
works that way.
thanks
Pragan.
On Nov 20, 4:36 pm, VizGuy <[EMAIL PROTECTED]> wrote:
> 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=paMte...>
> > );
> > (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
-~----------~----~----~----~------~----~------~--~---
