That is, specifying the range is no different than using a select statement
as far as the rest of your code is concerned.
On Tuesday, March 25, 2014 11:05:10 AM UTC-4, asgallant wrote:
>
> When you query a range of cells, the Query should return an
> already-constructed DataTable.
>
> On Tuesday, March 25, 2014 11:01:18 AM UTC-4, Dave Lalande wrote:
>>
>> 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.
