query rows from google sheet

11 views

Skip to first unread message

unread,

Jan 2, 2019, 8:58:34 AM1/2/19

to Google Visualization API

Hi there!

Is it possible to query rows instead of columns? So far I have

new google.visualization.Query('*sheet*');queryoszillator.setQuery('SELECT A, AB');

This is fine and brings the data from A and AB into the chart. But it would be easier to store the data in rows instead of columns.

So my question:

Is it possible to query by rows? 5 and 8 for instance? I tried the range-parameter but it didn't work.