top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to get google spreadsheet through google script?

0 votes
211 views

Hi,
I want to access spreadsheet data through google script.Below is the code but somehow I am not getting it.Please help me as I am stuck in my project.

function getMyData() {
var sheet = SpreadsheetApp.openById(SPID).getSheetByName("COMMAND");
return sheet.getRange("A2:G2").getValues();
}

posted Apr 2, 2017 by anonymous

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button
Assuming SPID as a string variable as its not under quotes, rest looks fine to me. Else provide more information so that we can analyse.
commented Apr 3, 2017 by Salil Agrawal

Similar Questions
0 votes
How to get user's location using PHP Google APIs Client

I want to retrieve the user's location after user signs in my website. How can I do that?

At this moment here is the scope that i have: $client->setScopes('email');
I guess I have to change that.

And to retrieve data I have the following:
$client->verifyIdToken()->getAttributes();

Do I need another method than this?

+3 votes
how to get google indexed page using api in C#

I want get Number of indexed pages of any website so, it will give me exact number of pages in google.
What I have tried:

Uri queryUri = new Uri(string.Format("http://ajax.googleapis.com/ajax/services/search/web?v=1.0&q=site:{0}", url));
using (WebClient client = new WebClient())
{
    string getString = client.DownloadString(queryUri);
    dynamic s = JsonConvert.DeserializeObject(getString);
    var IndexedPage = s["responseData"]["cursor"]["estimatedResultCount"].Value;
    lblIndexedPageRecv.Text = IndexedPage;
}

its working but not giving me right answer

my code is giving different values then other online webCheckers like one of this: http://www.pingler.com/seo-tools/tools/google-indexed-pages-checker

+3 votes
Is there anyway I can take a capture of Diameter message from Google Chrome through my PC if I browse any pages.

Just for curiosity, I want to see a real network traffic from Chrome Browser when I browse for any pages. I want to see Diameter Messages if I want to take a capture on Wireless Network Connection from Wireshark. If it possible kindly suggest the conditions on which it can be captured?

+3 votes
How to get the EARFCN value of Neighbor Cells through MeasurementReport in Release 10?

Need to organize Neighbor List by using EARFCN. Any help will be appreciate.

...