Hi, thanks again. I guess you got me right. I will post an example in sometime and then ask my question with better explanation.
thanks pragan. On Dec 2, 4:38 pm, VizGuy <[EMAIL PROTECTED]> wrote: > So if I get you right, you will send a query to a range.Then you KNOW that > your data table has 2 columns, and x rows. > It should be quite simple to map a cell in the spreadsheet to a cell in the > data table. > > Am I missing anything? > > VizGuy > > On Tue, Dec 2, 2008 at 9:47 PM, Pragan <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > 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. > > > Thanks for the clarification. I can go with the second approach, but > > how we can just show the required cell after getting the data? For > > example, if my query for a range(c2:Q2) is giving the whole row with > > data then how can I just display D2 in one place and R2 in other > > place? > > > Thanks again. > > Pragan. > > > On Dec 2, 12:56 pm, VizGuy <[EMAIL PROTECTED]> wrote: > > > 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 -~----------~----~----~----~------~----~------~--~---
