HaAnh_DC
(HaAnh DC)
August 24, 2021, 6:52am
#1
I have 2 questions to ask everyone:
If I want to call the data in googlesheet starting from the nth row onwards, how should I use the URL? (https://docs.google.com/spreadsheets/d/IDDD/gviz/tq?tqx=out:csv&&tq= )???
I want to call data from sheet2 of googlsheet, what is the URL like? (https://docs.google.com/spreadsheets/d/IDDD/gviz/tq?tqx=out:csv&sheet=Sheet2 )???
Please help me about the URL!
Thank you!
to do this, you should use this script code
you will get succeed
I feel without script code it is not possible… I feel good to call all the data at a time with web url into a variable… and from the variable you can take the data from nth row or colum will be better option for you
1 Like
dora_paz
(Dora)
August 24, 2021, 7:36am
#3
See
As for
HaAnh_DC:
from the nth row onwards
You could call all and make a procedure to only show items from nth row to …
TimAi2
(metricrat)
August 24, 2021, 11:29am
#4
See here:
INTRO
gviz is an abbreviation for Google Visualization API which is used to access google sheets and google charts, among other things. In this tutorial we will focus on getting and querying data on google sheets, to work with or display this data in...
You can use the sheet name or the gid to return data from a specific sheet.
To SELECT from your nth row, your data will need to be indexed (a column with numbers) so for example, you can SELECT * WHERE A > n
Here is an arrayformula you can use to automatically index your data
1 Like
HaAnh_DC
(HaAnh DC)
August 24, 2021, 12:23pm
#5
I used: /gviz/tq?tqx=out:csv&&tq=SELECT where A>2, but it didn’t work.
I used: gviz/tq?tqx=out:csv&&tq=, the default is to get from row 1, I want it to get from row 3, or any other row of my choice.
HaAnh_DC:
but it didn’t work.
Use this if it can help you.
This is the best Google Spreadsheet Till Now.
Created By - @Raja_HarshVardhanSolanki (Done some edits in script by @ikshefi )
Today, I wanted to give you a Script without any guide of it.
There are only one easy method to get your destination.
apiCommand that indicates which function you are use.
And it is easy to get sheet by name.
if(apiCommand == any of 18 function below)
{
then do function as wise apiCommand.
}
This new script have 18 functions.
Function added by @Raja_HarshVardhan…
TimAi2
(metricrat)
August 24, 2021, 12:42pm
#9
On this example data:
…gviz/tq?tqx=out:csv&sheet=Sheet2&tq=SELECT *
returns
"Index","A","B","C"
"1","123","456","789"
"2","abc","def","ghi"
"3","234","345","567"
"4","bcd","cde","def"
…gviz/tq?tqx=out:csv&sheet=Sheet2&tq=SELECT * WHERE A > 2
returns
"Index","A","B","C"
"3","234","345","567"
"4","bcd","cde","def"
this actually returns the data AFTER the n
, subtract 1 if you need the nth row as well
2 Likes
system
(system)
Closed
August 1, 2022, 8:34pm
#11
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.