top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to get google spreadsheet through google script?

0 votes
143 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.

Similar Questions
0 votes

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

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

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

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

...