Well, I think I know how to query just the cells I need. Something along these lines.
var query = new google.visualization.Query( 'https://spreadsheets.google.com/spreadsheet/tq?range=A19:E35&key=0AhCv9Xu_eRnSdHBELWZoZHRaQTl5VXdRa3JLTzByUlE&gid=2' ); But I don't know where to go from there frankly. Do I loop though each column in the range individually to build the array? Is there something I can do in a one pass that neatly build a table in memory of the queried range? When I queried the entire column I used this. query.setQuery('SELECT A, B, C, D, E'); query.send(function (response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } But when I query a specific set of cells in the URL I don't know the proper way to setup the array to draw below? On Tuesday, March 25, 2014 8:37:47 AM UTC-5, Jeremy Faller wrote: > > I'm having trouble parsing your question, frankly because there isn't a > question mark in your post. :) > > In any case, are the query formats enough for you: > > > https://developers.google.com/chart/interactive/docs/spreadsheets#queryurlformat > > > > On Monday, March 24, 2014 3:59:19 PM UTC-4, Dave Lalande wrote: >> >> Last week +asgallant was gracious enough to help me work through a line >> chart using a Google Sheet. You'll find the source >> here.<https://github.com/davelalande/linechart_using_googlesheet/blob/master/chart> >> >> I was looking to change the code to use only certain cells from the >> Sample Google >> Sheet<https://docs.google.com/spreadsheet/ccc?key=0AhCv9Xu_eRnSdHBELWZoZHRaQTl5VXdRa3JLTzByUlE&usp=sharing> >> so >> if I were using a sheet like tab "specific cells" in the sample sheet I >> could use A19:E35. >> >> Further, if I had some data coming in at different times and some columns >> in the range were blank, it would only use the columns in the range that >> data existed. >> >> Thanks for your thoughts. >> >> Dave >> > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
