Pull data from a google sheet with a for loop with javascript?

Is there a way to loop through rows of a google spreadsheet with only the link or the google sheet key? I need to do string manipulation with each of the values and save them to a database. Is there a quick way to return a string with google sheets?

Answers


No you cant access spreadsheet data without Oauth in javascript.

Better way is use Google app script (from tools -> script editor) write function to read spreadsheet data. deploy that web service publicly and do ajax call to that web service in your javascript you will be able to get all spreadsheet data. if it is returned from that app script function.


Need Your Help

Valum's Ajax JQuery File Uploader Progress Slows Down Browser

jquery ajax file-upload

I am trying to implement an Ajax JQuery File Upload Utility found here. Everything works excellent except one small problem. When I select multiple files for upload, the whole process slows down the

Display album art from MediaStore.Audio.Albums.ALBUM_ART

android android-imageview android-mediaplayer albumart android-cursorloader

I use a CursorLoader in a LoaderManager with a Custom CursorAdapter. I've already achieved to display the Album and the associated Artist, and now I'd like to display the Cover.