If you are not using a gadget, but writing your own js, you can do one of two things:1. To send two queries to the same spreadsheet, each to a single cell (or any other range). 2. You can query for the whole range, and then use only the cells you want. This might end up as a lower latency approach, as the size is still small, and you save a round trip. There is no way to specify more than one range in the request.
VizGuy On Tue, Dec 2, 2008 at 7:10 PM, Pragan <[EMAIL PROTECTED]> wrote: > > Hi, > > I am using visualization api by having spreadsheet as data source. I > am able to get the output for the range I define. For example, if I > just want to show the data from A1-Q1 or A1-Q20, then I specify the > range and it > works fine. Same way I am able to define the individual cell like A5 > or B8. > > My question is : In a page, if I want to show data from A5 in one > place and in other place if I want to show B10 then how > can I do it without repeating the query again? Is there any way to > store all the data(complete data from that sheet) in our local db like > mysql > and then show the specific value based on the query? Or Can we store > the complete data in an array format and then show the required values > by calling the element? > If the above methods are possible, how to do it?? > > Please let me know, if there is any other simple or easy solution. > > 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 -~----------~----~----~----~------~----~------~--~---
