Skip to main content

Google SpreadSheet Library for Android

You might have already tried using Google's GData Lib to access SpreadSheet from Android, and after few hours of try, you start Google for any alternate solution. I have also spent number of hours without any solution.

So, I have developed SpreadSheet client Lib [ works on Android :-) ] and ideally work on any Java platform-

Latest version: 2.1 (Added support for List Feed. Please visit above link to get more info.)

Supported Features:

1. Create/Delete Spreadsheet

2. List all stored Spreadsheets

3. Add/Delete WorkSheet into/from a given SpreadSheet

4. List all Worksheets of a given Spreadsheet

5. Add Records into WorkSheet/SpreadSheet (It supports Table based record handling)

6. Retrieve Record from WorkSheet/SpreadSheet (Structured Query support)

7. Retrieve Record as List Feed from Worksheet

8. Update/Delete Records

9. Share ShreadSheet with user/group/domain.

10. Conditional data retrieval- Structured Query support

11. Conditional/Structured query support for List based data retrieval

12. Better Log handling. By default logging will be enabled. To turn off logging Log.disableLog()  

Would appreciate your feedback and love to hear any specific feature requirement.... happy to help :-)


  1. I think I am the first to download and use your Android Spreadsheet API. It does work for me and I congratulate you on the code you produced. I couldn't find any other code that worked on the Android.

    Are you going to finish it with methods for conditional queries and updates?

    1. hello i am anil carie

      can you mail me a source code updating, deleting , inserting data into google docs

      it would be great help for me is my mail id

  2. Hi,

    thanks for your comment and trying this Lib.
    Yes, I am working on SpreadSheet "Share" and also on "Conditional Query". Probably I will publish the "Share" feature and then "Conditional Query".

    Hope it helps!


  3. Hi,

    I am using your library and its great. Thanks for the effort.

    However I am facing one issue. When I query the spreadsheet, I am getting the right number of records back but the records are empty. It does not have any data.

    FYI, I am working on Android.


  4. Hi,

    thanks for your comment. If you face any issue, pls raise them with details (log) on-

    I'll try to follow up.


  5. Hi. Do you have a working sample for Android, just so I can see how the callbacks etc should be set up? Thanks

  6. Hi, I am working on an Android App which is using this Lib. But it is still in the mid of development. So, I'll try to post few Android sample codes.
    It was on my TODO, but somehow unable to find out time to put them together :-)
    thanks for reminding...

  7. I am trying to write a simple android app that will allow me to read and write to the cells googlespreadsheet. However I am amazed at how there are no good examples of how to do this. Basic authentication, and read/write cell data are non existent. If you could post some simple example that would be great. Thanks.

  8. Hi Glen,

    thanks for your comments. Uploaded new release 2.0.u1 which includes "Android Sample" program.

    Hope it helps!

  9. First thanks for your effort on this library.
    After read the sample code and java docs in the zip file, I still have some questions when I try to use this library on my project.

    First, I need to retrieve the only 3 records at the final part of a spreadsheet. How could I do this with this library?

    And another one problem is , how to read a published spreadsheet? (This spreadsheet is published through Google Docs web interface, and can be viewed by anyone who has the link without login required.)


  10. Hi,

    here is my answer-
    Q1. I need to retrieve the only 3 records at the final part of a spreadsheet. How could I do this with this library?

    this library supports conditional query for both "table" and "list" based feed. So you can retrieve only selected rows with matching consitions- it supports- Structured Query

    Please my sample code

    Q2. how to read a published spreadsheet?

    this library will list all Spreadsheets whether created by Google interface or this library itself. For spreadsheets created through Google Web interface, you need to use "List based" feed, which is also supported by this library.

    Pls check sample codes carefully to understand the capabilities of this library and drop me mail if you still have any doubt!

  11. Thanks for your reply, Paul.

    Abuout the Q1:
    Yes, I've read the But I just don't know how to set the max-results constraints in the library.

    I can do this with the following code when I use Google official GData API jav client library:
    // with GData API Java Client Library
    URL listFeedUrl = wsEntry.getListFeedUrl();
    ListQuery maxRowQuery = new ListQuery(listFeedUrl);

    In the gss_lib I use the following code , but don't know how to set the max-results :
    // with gss_lib
    ArrayList records = wk.getRecords(s.getKey(), true, "" , "column:serialCol");
    // How to set max-results parameter ?

    About the Q2:
    I just know the published link of the spreadsheet (something like , and then my program need to fetch data in the spreadsheet. So I don't have any google account name and password to do the SpreadSheetFactory.getInstance(accountName,pwd). Then , in this situation how could I get the SpreadSheet object which form the published spreadsheet with the gss_lib?

    It's all my confusion.
    Thanks in advance.

  12. Hi,
    Thanks for your detail analysis.

    Q1. I agree, at present there is no way you can do "setMaxResult". I'll add this in my TODO :-)

    Q2: Well, without authorization, you can't access Google SpreadSheet API. You, need to pass auth_token with every request. So, this is not possible.


  13. continuing my comment on Q2, SpreadSheetFactory.getAllSpreadSheets() will list all SpreadSheets which are either shared by other user or created by you.

  14. Excuse me, about the Q2 , the google official Spreadsheet API developer's Guide said "Note: You don't need to authenticate to request data from a published spreadsheet. (A published spreadsheet is one that the user has marked as published using the Spreadsheets GUI.)" , the link is here : .

    Do I make any misunderstanding?

  15. About the published soreadsheet , I've use HttpClient to access the data of a published spreadsheet on android smoothly instead of finding any available spreadsheet API.
    It now works fine, thank you.

    1. Hello Dolph,

      I am also having same kind of requirement as you already done. Can you please kindly guide me on this? How can i get published spreadsheet in my android app? And from that I want to fetch some data, so what steps i have to follow? Please kindly help me because I don't know where and how to start with.

      Thank you

  16. Hi Dolph,
    thanks for sharing your exp...

  17. Hi!

    I'm using your library and it's great!!

    It's working really well for me... but I need to modify records of a worksheet which was created using web UI. According to your library doc:

    It also supports List based Feed, but only to retrieve data. At present it doesn't provide any method to Add/Edit/Delete data in List based Feed.

    Are you planning to add these methods? And if not... could you give me some advice about where can I find info about it?

    I have been searching and I haven't found anything better than your library!

    Thanks in advance and thank you very much for sharing your knowledge and your work!

  18. Hi Javi,

    thanks for your comments. At present I'm working on some other project, so Add/Edit/Delete for List feed will take sometime.
    To add this feature, just like Table feed, the code cache column names and then you need to send POST request to Add row- Add Row

    PUT for update and DELETE to delete a row. You can check my implementation of Add/Edit/Delete of Table feed.
    You need to add this feature in

    Please let me know if you need any additional help.

  19. Hello from Japan.
    your lib worked like a magic in 3min.
    i will try to build a great app over it and donate you a big money then!

    1. hello can tell me how to use this lib

      i have imported this file on to my eclipse

      when i run the emulator i am getting message gss_client is getting closed

    2. Update properties -> Add lib in Order and Export!

  20. Hi

    Your library was great, thanks.

    But, i want to know how to send/add an image to spreadsheet google using this library?

  21. Prasanta,

    I'm so glad I found your library after banging my head against the wall with both the gdata-java-client library and the new gdata-api-java-client library (supposedly for Android but not working for spreadsheets).

    Browsing the code, I believe you are doing everything securely through SSL (https where needed)? I just wanted to confirm that that is the case since I don't want to go broadcasting passwords or the cell data in the clear.

    Thanks for writing and posting this library.

  22. Hi,

    you guessed it right. To get access, the Lib need to get Auth Token after doing Authenticatiion with Google Server. So, that is safe.

    Thanks for your comment BTW.

  23. Hi Paul,

    I would like to thank you for the wonderful library you've just created. Please enlighten me on this-- I tried executing the GSS_Lib_Android_Sample in eclipse following the recommended 2.1 and API 7, but I got an error of "The application GSS_Lib_Android_Sample has stopped unexpectedly, please try again", I dont really know what cause this error. Help me please, I am new to Android.

  24. Hi,
    this is interesting :-)
    Can you pls mail me the exact exception you see on DDMS? Are you trying on Emulator or on Device ?


  25. Hi Paul,

    Thanks for the quick response. Yes I am using an Emulator for test. And for DDMS logs i will email the snapshots. Hope this helps.
    Again thank you and more power!

  26. Hi Prasanta,

    with Table and Record feeds getting deprecated, are you planning to migrate the library to List/Cell?

    Many thanks,


  27. Hi Fredo,

    thanks for the info. Right now I am into some other project, so don't think I'll get time to do this immediately.
    But the present API allows retrieval List Feed data with all query feature. So reading is available.


  28. Dear All,

    today I uploaded a new binary and source (Rel 2.1) which supports List based feed. Please check the sample code to understand how to use it.
    You can Add/Edit/Delete List based WorkSheet data Feed.
    Would appreciate your feedback.

  29. Very interested in your lib. However there is nothing posted on googlecode as of now. Where is your lib available?

  30. Pls find the latest rel- 2.1

  31. I'm trying your lib but it doesn't work for me...
    Maybe I done something wrong...
    My code...

    SpreadSheetFactory s=SpreadSheetFactory.getInstance(new AndroidAuthenticator(Main.this));
    List l=s.getAllSpreadSheets();
    Log.d("[Jin]", "No spreadsheet");
    Log.d("[Jin]", l.size()+" ");

    Authentication it's ok but it stop at s.getAllSpreadSheets()
    I'm tryin on android and i added these permissions


    Pls Help me...

  32. I'm having the somewhat same problem as described above. It does execute the s.getAllSpreadSheets() method but it takes a very long time on the http.doConnect (almost 3 minutes).

  33. Hello Prasanta,

    Thanks for your code in GSS_Lib it works great!

    but i don't find a method for deleting rows in a worksheet. is there anyway to do that?



  34. Hi Dragon,

    You can delete a Row using following call (ver 2.2 of the Lib)-
    workSheet.deleteListRow([SpreadSheet_Key], [List_Row_Instance]);

    Please check the sample code- You should start using 2.2 Version of the API and List Feed based approach.


  35. Hi Prasanta, thanks for creating this amazing API for us to use. However I tried to refer to the and try to used the code in android, it doesn't work. Can you help me on this? really appreciate it because I need to use this for my project which is due soon. Thanks in advanced.

    public class ReadGoogleSpreadSheet extends Activity {

    public void onCreate(Bundle savedInstanceState) {
    TextView read = (TextView) findViewById(;

    SpreadSheetFactory spf = SpreadSheetFactory.getInstance ("", "pass");

    ArrayList spreadSheets = spf.getSpreadSheet("hello", true);
    if(spreadSheets != null)
    readxml.setText("Number of SpreadSheets:" + spreadSheets.size() );

    }catch (Exception e){

  36. Hi,
    drop me an email with details error message.

    I'll look into that.

  37. Hi !
    Thanks for your great work !
    I try to use the last version (2.2) of the library on android. But after solve a crash due to missing permission (INTERNET, GET_ACCOUNTS and USE_CREDENTIALS) It's seems that the request to google spreadsheet service, takes a lot of time. As result, i get a socketException "request time fail: adress family not supported by protocol". I got my response after more than 3 minutes ... Can you help me to fix it please ? Could you profide us an "Hello Android gss-lib project" ?

  38. hello, i want to demo code for retrieve some fields from the google spreadsheet to android ? plz help me. how to do it? as well as how to add GSS lib in eclipse? plz reply me as soon as possible.

    and mail me on

  39. Hi,

    I have already added sample folder in the 2.2 release. Those are Core Java application and you can easily use them in Android.

    I would appreciate any volunteer who can work on the Android sample. I can share whatever I have.


  40. Dear All,

    Uploaded a sample Android client-


  41. Hi prasanta.

    Have u been workin on something new on ur library?what are the next changes u are thinkin implimenting?

  42. Hi prasanta
    I am trying to use your api to retrieve data from spreadsheet in my android app.
    I retrieved the name of the spreadsheet and then of the worksheet also.
    I also retrieved the number of columns and rows in the worksheet correctly.
    but when I try to retrieve the records it always return null. Please tell me what I am doing wrong.

  43. hi Prasanta
    I figured out what i was doing wrong.
    congratulation on creating such great library.

  44. Dear All,

    please help me in promoting MateOnGo.
    This is a location based recommendation engine on which I'm working right now.

    If you like the product, please share your feedback on our facebook page-


  45. Hi Prasanta

    Your library solve my nightmare! do you plan to upgrade it to Spreadsheet API 3.0?

    With Regards
    Yong Lin

  46. Hello Prasnata,

    You library is great... I was able to write a nice wine cellar application for the android that uses spreadsheets for the inventory control and can be viewed by all the members of the family... but as of two days ago it just stopped working, the Google spreadsheet feed says that it can not find the file... even though there have been no changes to the code not the sheet name... are you aware of any changes to the Google doc spreadsheet feed protocol that may have changed? Just a shot in the dark. Thanks Larry

  47. Hi, this is Larry again... I don't know this just must be a timing issue, the same app still works on my Samsung Galaxy using a wifi connection, but getting a response from the Google docs site on a Droid phone just takes way to long... I mean well over minute maybe two, and the sheet only has some twenty rows and eight columns. It is too bad that the Google app api's are so slow, but it is not viable for an application. I have no idea what makes it take so long, because it is fairly snappy when using the Google docs app etc, but getting a feed is intolerable. I'll have to figure out some other persistence strategy, but it is too bad because the collaboration aspect is cool.

  48. First off, I really like the project. I have not been able to find another way to connect to a google doc spreadsheet. I do find that it is extremely slow though. I wrote a basic app that just creates a SpreadSheetFactory and then performs the getSpreadSheet routine looking for a specific spreadsheet with the isTitleExact set to true. Then I display the title of the Spreadsheet in a textView along with the time the Activity started and when it ended. It took over 6 minutes just to get the Spreadsheet title. The spreadsheet only has a few rows so it is not very big. Before I go ahead and start using this library to update the spreadsheet in my app I want to know if these types of response times are typical and if there are any settings to speed this up? I am running this on my Emulator on a PC that has over 20 MB speeds When I try it on my 3G phone I waited for over 30 minutes. When I try the Google Docs app in comes up with the document data in 5 seconds so I don't think it is a slow connection issue. Any help on making this faster or another way to access Google Docs from Android? I have a idea for a new app but it is dependent on being able to update a simple Google Docs spreadsheet.

  49. Dear All,
    there was one Proxy reference in my code and it was causing connection delay.
    Please start using the latest Lib-


  50. Hi Prasanta,
    Thank you for the awesome GSS library !!
    I would like to let you know that I have used your library for the DroidconIndia 2011 android app
    (open-source). I have mentioned your name and library link.

  51. @Jerin: glad to know that. Is there anyway I can test the App ? would love to check it!

  52. I have mailed you at your gmail address

  53. Prasanta,

    Thanks for the quick fix for the Proxy error! Seems to be working now and I am going to modify my app to use your library. Is there a way using your library to tell the last time the SpreadSheet or WorkSheet has been modified? I keep the contents of the Spreadsheet locally on my app to improve performance time and reduce data usage and only want to read the entire contents of the SpreadSheet when it has been modified to update the app data.

  54. it doesn't support any auto caching or update detection functionality. You can add some solumn like date/time and track your data changes.
    Keeping a local cache is good approach. But u also need to take care of periodic background synch.

  55. hi Prasanta this library helped me a lot but i am getting one problem i am retrieving data using conditional query for that i am using ContentHandler but i dont know how to write the query for the following requirement

    i want to retrieve values based on two columns year==XXXX and country=XXX
    how to write the query here year and country are the column name of spreadsheet

  56. i did the same as above but i am getting the error
    bad request 400

  57. hi prasanta this is laxminarayana i am using using your library working great but i am facing one issue i,e i am having columns like category year ..etc i want to retrieve the records i,e category column only it contains duplicate data
    so in sql i can write it as select distinct category from table where year=2006
    , but how to query this by using your library?
    i dont need entire row only category column only
    waiting for your reply

  58. Thank you soooo much.. your library is fantastic.. it helped me a lot

  59. Hi, Prasanta
    Thanks for brilliant tiny library! )

    Don't you try using for that?

    Seems it has full support out of the box but a lot of overhead (

  60. Hi, Prasantha.

    Keep it up the great work......


  61. Hi Prasantha.

    I am getting a error when trying to insert a record into a spreadsheet on android.
    this is the error in Logcat.

    01-03 12:06:49.868: I/System.out(1059): [HttpConHandler] URL=
    01-03 12:06:51.757: I/System.out(1059): [HttpConHandler] Error in connection:
    01-03 12:06:51.779: I/System.out(1059): [HTTP_Response] HTTP Response Code: 400
    01-03 12:06:51.779: I/System.out(1059): [HTTP_Response] HTTP Response: Bad Request
    01-03 12:06:51.798: I/System.out(1059): [HTTP_Response] Error Msg from Server: We're sorry, a server error occurred. Please wait a bit and try reloading your spreadsheet.
    01-03 12:06:51.798: I/System.out(1059): [HTTP_Response] Error in Connection:
    01-03 12:06:51.798: W/System.err(1059):
    01-03 12:06:51.808: W/System.err(1059): at
    01-03 12:06:51.808: W/System.err(1059): at
    01-03 12:06:51.818: W/System.err(1059): at com.pras.conn.HttpConHandler.doConnect(
    01-03 12:06:51.818: W/System.err(1059): at com.pras.WorkSheet.addListRow(
    01-03 12:06:51.818: W/System.err(1059): at com.oknet.test.SpredSheetSampleActivity$MyTask.doInBackground(
    01-03 12:06:51.828: W/System.err(1059): at android.os.AsyncTask$
    01-03 12:06:51.828: W/System.err(1059): at java.util.concurrent.FutureTask$Sync.innerRun(
    01-03 12:06:51.838: W/System.err(1059): at
    01-03 12:06:51.838: W/System.err(1059): at java.util.concurrent.ThreadPoolExecutor.runWorker(
    01-03 12:06:51.867: W/System.err(1059): at java.util.concurrent.ThreadPoolExecutor$
    01-03 12:06:51.867: W/System.err(1059): at

  62. Replies
    1. how would you solve that problem can please explain me.

  63. Hello! Thanks a lot for the great library! It has been working just find for my Android application. However, after the Dec 31 of the last year, I've started to get error messages, when I try to authenticate with the provided AndroidAuthenticator. Here is the logcat:

    01-11 16:35:06.613: I/System.out(14454): [HttpConHandler] Error in connection:
    01-11 16:35:06.623: I/System.out(14454): [HTTP_Response] HTTP Response Code: 401
    01-11 16:35:06.623: I/System.out(14454): [HTTP_Response] HTTP Response: Token expired

    Why could it be that the token that I get from the Android accounts has expired? Can you, please, assist - is it possible to fix the issue and still be able to login using build-in Android account? Thanks!

    1. @Yuriy: I just tested the latest sample client- (gss-lib-2.2b1), it is able to get Autho Token and fetch spreadsheet list from my account. Can u pls try with the latest lib and some other Gmail account ?

    2. Yes, I am using the latest lib. I've tried on another phone with different account - and it worked. So, seems like there is some problem with my phone and account. I wonder, if the Google gave me the token and now it has expired. I will need to dig deeper into the authenticating code to overcome this problem. If you have any suggestions or guidelines I would greatly appreciate this!

    3. @Yutiy, what did you find out? It seems like I am having a similar issue. Thanks

    4. I've found the root of the problem and also found a solution. The problem was with my auth token. It was expired and thus the connection to the spreadsheet service failed. I found in the documentation to the AccountManager ( that if request fails then token should be invalidated and request tried again. So, basically what I do now: I get the auth token as usual, then I submit request to Google Spreadsheets (I just get all sheets). If request fails, then I invalidate the token and get it again from account manager. I've modified the AndroidAuthenticator class by adding this new logic. You can get the java file here:
      @Prasanta, I did a quick fix for the problem to make it work. Maybe you can make more elegant solution and add it to the next release? In a nutshell, there should be a check for the reason of request failure. And if the reason is token expiration, then the token should be invalidated. Otherwise, throw an error. Something like this...

    5. Thanks Yuriy. I will take a look.

  64. Hello,

    This library is excellent , i would like to use this in my example. How can i change the default login methods , so that the user can enter their gmail id and password.

    thank you

    1. @Kumar: You can use com.pras.auth.BasicAuthenticatorImpl to prompt user for Gmail ID and Password.
      It supports 2 ways of authentication- Android's Authenticator and User input based authentication.

    2. @Prasanta : Thank you for quick response. I will use BasicAuthenticatorimpl class and get back if i have any issues.

      I have two google accounts setup on the phone
      I loaded your spreadsheet app yday , i am trying to switch to a different account on the app's main screen, i dont find way to change the account, by default i see only first account.

      is there any way to switch accounts on your app.

      Thank you , kumar

  65. Hi Prasanta!

    Thank you so much for providing such an awesome library!!!

    Few queries:
    1) I am able to create the google spreadsheet with the help of the API, but am unable to create the same manually (google docs, through gmail). Can you help me in this regard?

    2) Also, when I create the table with the help of your API and manually add records, the added records are not being retrieved by the the API. Can you tell me how this can be resolved as well?

    Thanks in advance! :)


  66. Prasanta,
    I see your lib only allows editing of spreadsheets created with your lib. Is there a modification that would make editing of existing spreadsheets possible?

  67. Pls use List Feed instead of Table feed. (

  68. Hi Prasanta,

    Thanks for a great library to access Google Spreadsheet. Definitely helpful.

    Have a question though. Does editing of data allowed for List Feed, or is it just for Table Feed? I have read the comments on WorkSheet.class which states that Add/Edit/Delete of data is not yet allowed for List based feed. Is this still correct?

    Thanks in advance

    1. Comments might be misleading. But you can Add/Edit/Delete records for both Table (which is deprecated) and List feed. Please try with the latest Lib (2.2b1)

    2. Thanks for the quick reply.

  69. Hi Prasanta,

    I still don't understand how it is done.
    My query again:
    1) I am able to create the google spreadsheet with the help of the API, but am unable to create the same manually (google docs, through gmail). Can you help me in this regard?

    2) Also, when I create the table with the help of your API and manually add records, the added records are not being retrieved by the the API. Can you tell me how this can be resolved as well?

    1. 1. I have no idea on this.
      2. Table feed doesn't support manually entered records. For this you need to use List feed. Pls use Lib 2.2b1 and List feed methods.

  70. Hi Paul,

    I am testing sample app GSS_Client_Android on 2.3 and 2.2 emulators and on 2.3.5 Galaxy S. Even thought I set the google account and the synch on, I get "no spreadsheet exists in your account" (and I have a few spreadsheets).

    I added the code snippet to the onCreate of the as follows (without the comments)


    Log.v(TAG, Build.PRODUCT);
    // if("sdk".equals(Build.PRODUCT) || "google_sdk".equals(Build.PRODUCT))
    // {
    // Log.v(TAG, Build.PRODUCT + ": doCustomizationForSDK method " );
    // ParseFeed.doCustomizationForSDK();
    // }

    Any ideas?

    1. Sorry Paul nevermind, I should have suspected the line :

      spreadSheets = factory.getAllSpreadSheets(true, "World", false);

      "World".. Thank you for the lib btw, it seems like a super time saver.

  71. hi,I find that when we want to addListRow(HashMap records)
    in the methode, i find that workSheetURL has not been defined before ! it lacks the URL to the workSheetURL !

  72. Hello!
    I am using your project for a small project but I ran into some strange limitation (or maybe I'm doing something wrong?)
    Do i have to put the rownames in lower case? When reading the worksheet the columns array is correct and gives mit the correct cases, but when I read the data with getData(false) the cells return the column name (.getName()) all in lower case. Any idea why this happens? Actually I have to put the names in lower case also to write with updateListRow in the Hashmap. Why is there this strange limitation? I looked into the code a little bit and it seems like google is returning it already in lower case?

    1. Its the limitation of Google Server API. You shouldn't use any "space" in column name and if possible don't use case, lower case is suggested to avoid any conflict.

  73. Hello Prasnata,
    Your library is great.It makes me easy to acess the spreadsheet. Thx for your library.
    I have a problem and I have tried to solve it two days. Can you give me some suggestions?Thanks you.

    I want to create a table that type of cells is "String".Because I have some cells values start with "0" add record to table and Google Spreadsheet always ignore "0". ex. 0912->912.
    I use library setType() function but nothing happened. Maybe I did something wrong.

  74. Can anyone explain the steps on how to use the library. . i am new to android. . ?

  75. hi i hv downloaded ur gss+client sample code..but whn i run it in android emulator it says "FORCE CLOSE"..plz help


  76. hey dude...can u give me ur contact no..i need u to help me on dis..its urgent..any help will b appreciable

  77. Hi Prasanta,

    I am using ur lib. I'm unable to run ur sample code. The sample code always crashes while running in simulator. I'm new in android. Classes in ur lib like Spreadsheet , SpreadsheetFactory etc could not found in this project. I dnt have any errors. Lib using is latest gss_lib_2.2.b1.jar. Please help as early as you can....

    Error log is

    04-17 22:07:11.335: I/dalvikvm(504): Failed resolving Lcom/prasanta/auth/AndroidAuthenticator; interface 28 'Lcom/pras/auth/Authenticator;'
    04-17 22:07:11.335: W/dalvikvm(504): Link of class 'Lcom/prasanta/auth/AndroidAuthenticator;' failed
    04-17 22:07:11.346: E/dalvikvm(504): Could not find class 'com.prasanta.auth.AndroidAuthenticator', referenced from method com.prasanta.GSSAct$MyTask.doInBackground
    04-17 22:07:11.346: W/dalvikvm(504): VFY: unable to resolve new-instance 45 (Lcom/prasanta/auth/AndroidAuthenticator;) in Lcom/prasanta/GSSAct$MyTask;
    04-17 22:07:11.355: D/dalvikvm(504): VFY: replacing opcode 0x22 at 0x0000
    04-17 22:07:11.355: D/dalvikvm(504): VFY: dead code 0x0002-001e in Lcom/prasanta/GSSAct$MyTask;.doInBackground ([Ljava/lang/Object;)Ljava/lang/Object;
    04-17 22:07:11.395: E/dalvikvm(504): Could not find class 'com.pras.SpreadSheet', referenced from method com.prasanta.GSSAct$MyTask.onPostExecute
    04-17 22:07:11.395: W/dalvikvm(504): VFY: unable to resolve check-cast 23 (Lcom/pras/SpreadSheet;) in Lcom/prasanta/GSSAct$MyTask;
    04-17 22:07:11.405: D/dalvikvm(504): VFY: replacing opcode 0x1f at 0x00a0
    04-17 22:07:11.405: D/dalvikvm(504): VFY: dead code 0x00a2-00ab in Lcom/prasanta/GSSAct$MyTask;.onPostExecute (Ljava/lang/Object;)V
    04-17 22:07:13.715: W/dalvikvm(504): threadid=9: thread exiting with uncaught exception (group=0x40015560)
    04-17 22:07:13.886: E/AndroidRuntime(504): FATAL EXCEPTION: AsyncTask #1
    04-17 22:07:13.886: E/AndroidRuntime(504): java.lang.RuntimeException: An error occured while executing doInBackground()
    04-17 22:07:13.886: E/AndroidRuntime(504): at android.os.AsyncTask$3.done(
    04-17 22:07:13.886: E/AndroidRuntime(504): at java.util.concurrent.FutureTask$Sync.innerSetException(
    04-17 22:07:13.886: E/AndroidRuntime(504): at java.util.concurrent.FutureTask.setException(
    04-17 22:07:13.886: E/AndroidRuntime(504): at java.util.concurrent.FutureTask$Sync.innerRun(
    04-17 22:07:13.886: E/AndroidRuntime(504): at
    04-17 22:07:13.886: E/AndroidRuntime(504): at java.util.concurrent.ThreadPoolExecutor.runWorker(
    04-17 22:07:13.886: E/AndroidRuntime(504): at java.util.concurrent.ThreadPoolExecutor$
    04-17 22:07:13.886: E/AndroidRuntime(504): at
    04-17 22:07:13.886: E/AndroidRuntime(504): Caused by: java.lang.NoClassDefFoundError: com.prasanta.auth.AndroidAuthenticator
    04-17 22:07:13.886: E/AndroidRuntime(504): at com.prasanta.GSSAct$MyTask.doInBackground(
    04-17 22:07:13.886: E/AndroidRuntime(504): at android.os.AsyncTask$

  78. Hey,

    Library is working great but i got little problem today. I tried to add new feature to display list of collaborators but getCollaborators method returns empty list. Any idea why?

  79. Hi Prasanta,

    Thanks for this awesome library! I am having some issues, though.

    When I try to get all worksheets from a specified spreadsheet, I receive the following error:

    05-17 14:03:23.049: E/AndroidRuntime(7189): FATAL EXCEPTION: main
    05-17 14:03:23.049: E/AndroidRuntime(7189): java.lang.NullPointerException
    05-17 14:03:23.049: E/AndroidRuntime(7189): at
    05-17 14:03:23.049: E/AndroidRuntime(7189): at
    05-17 14:03:23.049: E/AndroidRuntime(7189): at
    05-17 14:03:23.049: E/AndroidRuntime(7189): at
    05-17 14:03:23.049: E/AndroidRuntime(7189): at
    05-17 14:03:23.049: E/AndroidRuntime(7189): at com.pras.conn.HttpConHandler.doConnect(
    05-17 14:03:23.049: E/AndroidRuntime(7189): at com.pras.SpreadSheet.getAllWorkSheets(
    05-17 14:03:23.049: E/AndroidRuntime(7189): at com.pras.SpreadSheet.getAllWorkSheets(
    05-17 14:03:23.049: E/AndroidRuntime(7189): at com.pras.SpreadSheet.getAllWorkSheets(
    05-17 14:03:23.049: E/AndroidRuntime(7189): at test.gss.TestGssAndroidActivity$MyTask.onPostExecute(

    This is running the sample android app. It is connecting to the spreadsheets site ok, since I can get the title of the spreadsheet as well as the resourceID, but trying to access a worksheet throws the exception.

  80. Hi Prasanta,
    I am new in android development. i want to build android application that display data in specific spreadsheet that had already created. I read your library in that code where we have to mention our google account information.
    Please help me


  81. Mrunal,
    Please check the sample code included in the Lib-
    // Create SpreadSheet Factory
    SpreadSheetFactory spf = SpreadSheetFactory.getInstance("[email]", "[password]");

    You can also use AndroidAuthenticator-


  82. Hi,

    I did a very simple application with this library which read a QR code and put the code in a spreedsheet of Google Docs. The application was working ok for Android 2.1 and Google Docs.
    After some weeks without using, and after to update to Android 2.3.4, the application don't work, and I dont known if the problem is Android 2.3.4, the change from Google Docs to Google Drive or anoher problem.

    I started from the beginning, downloading the sample GSS_Client_Android and compiling for differents Android versions, but I'm not to able to work this sample.

    Do you know if there is some problem with Google Drive?

    Thanks and regards,

  83. Hello Prasanta,

    thx for sharing your great library with us.
    I am trying to upload some records to Google-Spreadsheet, but I am facing an issue here; maybe you can help.
    First of all, the spreadsheet was not created using your library, it was created by importing an xls-file. So this is, I suppose, the reason why it is not possible to add records to existing worksheets. For that reason I tried to create a new worksheet (within the same spreadsheet) using your library (method addWorkSheet). But adding records to this newly created worksheet using "addRecord" fails due to "HTTP Response Code 400". I suppose the reason is that addRecord is based an table-feed, but the spreadsheet itself was created through the Web-API (although the worksheet has been created using your library).
    Next try was using the method addListWorkSheet in conjunction with addListRow. This basically works as long as the column headers are all lower-case; if there is one letter uppercase in the column header, addListRow won't add the cell's content.
    I know that uppercase letters are possible using the table-feed based methods.
    Is there anything I can do to have uppercase letters in the column headers?

    Best Regards,

  84. Hi,
    When i try i get an error saying that appliation stopped unexpectedly.Pls help

  85. Hi Prasanta,

    I've tried your lib, but I have a problem about how to implement the lib for unpublished spreadsheet. How can I access my spreadsheet on my google account through its key? How to modify the spreadsheet cell and get the value of a cell?

    Thank you

  86. Hi Prasanta,

    Your library works well but I have a problem. Can I retrieve a cell contains multibyte characters like Chinese or Korean ?
    Cell A1 in my spreadsheet contains words in English while cell B2 contains =GoogleTranslate(A1,"en","kr"), how to modify the value of cell A1 and retrieve the value of B2, with your library I can retrieve the value of A1 but it doesn't go for B2,your lib doesn't display the Korean characters produced from the function on Android screen. What the problem might be? any idea?


  87. Hi Mr.Prasanta,
    i have tried your lib,its nice, but i have only see the spreadsheet filename and inner worksheet name but i cant see any data and how could i insert data into it...please reply soon...i stuck in it dude...

    1. sorry i can see the data,but i don't know how to insert or update into the spreadsheet...Thanks in advance dude...

  88. I have just found out your library 30 mins ago, just want to say thank you.
    You did a great job.

  89. Hi,

    Is this post still relevant.
    sample dint worked for me. Can I get some help on it?

    1. It works for me but i need help on how to write data to spreadsheets

  90. Hello Hi Prasanta,

    What do i need to do so that I can have the sample insert data to spreadsheet
    like step 1 2 3......or in the manifest

  91. Hi Prasanta, thanks for sharing your library, its a great job. I have some problems with "Share" feature. The Collaborators list return empty, and I tried add a Collaborator in this way:

    Collaborator col = new Collaborator();
    col.setScopeValue("email user");

    I'm doing it correctly? thanks again!

  92. Hi Paul, All,

    I've found the API quite interesting and I was even able to realize the lightweight database back-end for android via google spreadsheets like it was proposed here!topic/google-api-java-client/O1CGZzEWRts

    Also, I've noticed that a few features in the api would be highly useful, I mean anonymous access.

    1) So, I'd include the anonymous token support introducing a new public class similar to "public class BasicAuthenticatorImpl". But instead of "http.doConnect(GOOGLE_CLIENT_LOGIN_URL,....",
    GoogleOAuthGetTemporaryToken() should be used,
    more details here

    Now the api is limited to google users only.

    2) I didn't find the way how someone can use "Collaborator.geteditLink()" with SpreadSheetFactory class. I mean that
    SpreadSheetFactory doesn't have an interface to find "anyone" shared spreads.

    3) I'm not sure if google spreadsheets api supports "anonymous" sharing, but it's easy to insert support for "published to web" spreadsheets via
    "," where key is some public id.

    Here is an example,

    That's all from side. I've developed a simple android application (spending three days for introduction of myself to android programing and google api) just for fun (to help a friend of mine with his student project). If my time allows, I'll add 1) and 3) into
    the current snip of "google-spreadsheet-lib-android", but it would be great if you, Paul, could do it yourself.


  93. I Got Exception java.lang.NoClassDefFoundError: com.example.spreadsheetauth.AndroidAuthenticator and application Stop working.
    You created .apk which work fine but when i compile your sample code its gave me exception. also in my application i have a authtoken string then how can getIstance of spreadsheetFactory using Authtoken string?please help

  94. I would recommend you to try Aspose.Cells for Android, this library offers many features which developers can use in developing their android application.

  95. Your libray is not working now please update to new version.

  96. "I did a very simple application with this library which read a QR code and put the code in a spreedsheet of Google Docs. The application was working ok for Android 2.1 and Google Docs." Yes, we can use a web java qr code reading tool to scan and decode the barcodes on documents.

  97. Hi Mr. Prasanta,

    I am haivng an issue with your lib. Im using Spreadsheet.getInstance("email","password") auth solution and I get the following error:
    [HttpConHandler] Error in connection:
    08-04 16:16:48.999 29026-29049/? I/System.out﹕ [HTTP_Response] HTTP Response Code: 404
    08-04 16:16:48.999 29026-29049/? I/System.out﹕ [HTTP_Response] HTTP Response: Not Found

    08-04 16:16:49.004 29026-29049/? W/System.err﹕
    08-04 16:16:49.005 29026-29049/? W/System.err﹕ at
    08-04 16:16:49.005 29026-29049/? W/System.err﹕ at

    it seems that ClientLogin wont work. Any fixes for that?


Post a Comment

Popular posts from this blog

Android Parcelable Example

Few days back I had a requirement to send a ArrayList of my Custom Class Objects through Android Intent , I guess most of you also find this requirement now and then. I never thought it can be that tricky. There are built in functions in Intent to send ArrayList of primitive objects e.g. String, Integer, but when it comes to Custom Data Handling Objects, BOOM … you need to take that extra pain! Android has defined a new light weight IPC ( Inter Process Communication ) data structure called Parcel , where you can flatten your objects in byte stream, same as J2SDK’s Serialization concept. So let’s come back to my original requirement, I had a Data Handling class, which groups together a set of information- public class ParcelData {       int id;       String name;       String desc;       String[] cities = {"suwon", "delhi"}; } I want an ArrayList<ParcelData> of Data Handling objects to be able to pass through Intent . To do that, I can’t use the ParcelData a

Call Control in Android

This tutorial is for those who want to control Phone Call in Android OS. Programmatic approach to Accept or Reject call without user intervention. Kindly note, this approach uses Java Reflection to call methods of an internal class of Android Telephony Framework and might not work with all versions of Android OS. The core concept has been explained in this Android open code . 1st thing 1st, Give the permission . You need to define 3 User Permissions to handle call related functionality- android.permission.READ_PHONE_STATE android.permission.MODIFY_PHONE_STATE (For answerRingingCall() method) android.permission.CALL_PHONE (For endCall() method) Define a Receiver... Create a Receiver which accepts broadcasts with intent action android.intent.action.PHONE_STATE, define following in the Manifest- [receiver android:name=".PhoneCall"]         [intent-filter]             [action android:name="android.intent.action.PHONE_STATE"/]            [/intent-filter] [/receiver] Ha

Android Looper and Toast from WorkerThread

Have you ever tried to launch Android Toast message from worker thread? Probably you are wondering why the heck it is giving this error- java.lang.RuntimeException: Can't create handler inside thread that has not called Looper.prepare() In this article we are going to explore reason behind the above exception and try to understand how Looper works in Android. At the end, I am going to explain one approach to run Toast from a worker thread, but before that we need to understand how Looper works. If you already know in/out of Looper, you can skip below section and directly move to the solution part. Looper is a very basic wrapper class which attach a MessageQueue to a Thread and manage this queue. MessageQueue is a structure to sequentialize simultaneous processing requests of a Thread.  In Android, message/request processing classes like Handler uses Looper to manage their respective MessageQueue. Looper = Thread + MessageQueue Android Looper Life Cycle: As you can see in the abo

Overlay on Android Layout

This will help you to create custom Layout and add Overlay on a LinearLayout. The concept can be reused on other Layout classes i.e. RelativeLayout, FrameLayout etc. I have added a popup Selection Palette, containing "Map Pin" and "List" icons. You can minimize the popup by clicking on the section in Green on the left side bottom corner of the screen.   How can I do that- You need to follow 4 steps- 1. Override LinearLayout Create a Class which should overwrite LinearLayout 2. Drawing You need to overwrite dispatchDraw (Canvas canvas) method. It gives control to the whole screen. Make sure you set android:layout_height="fill_parent" for the associated layout definition in XML. You can draw anything and anywhere on the canvas. dispatchDraw (Canvas canvas) gets called only after underlying views are drawn, so whatever you draw comes in the foreground.   3. Event Handling You need to overwrite dispatchTouchEvent (MotionEvent e

Android Custom TextView

Have you ever tried to add custom behavior to in-build Android Text View or create custom attributes? If yes, this article is going to help you. Here we'll create Single Custom TextView with support for custom attributes to display First and Last Name in different font and colors. During this process we'll learn following topics- 1. How to override default Views in Android 2. How to define custom Layout Attributes in Android So, Let's get started... Following sections explains necessary changes required in Java code and XML layout files. Create Custom Text View ( 1. Override Android's default TextView   2. Implement Constructors. If you want custom attributes, override Constructor having Attributes in argument. 3. Override onMeasure(): Calculate required width and height, based on Text Size and selected Font. Once calculation is complete, set updated measure using setMeasuredDimension (reqWidth, reqHeight) Note: It’s really important to define the corr

Android Fragment

Fragment is being hanging out since Andriod 3.0, but with the release of 4.0, it has become an obvious choice for Android Application development for both Tabs and Smart phones. Few people think, fragment is a " Superman " which can add any kind of UI layout/style/decoration. But that is not true, rather than being an UI layout or decoration enhancer, Fragment is a very important concept to manage segments of your UI component code base . Prior to Fragment, developers were able manage UI flow only at the Activity level. All UI components were Views (mentioned in XML layout and part of Activity) and there was no way to manage these components separately. As a result all view management code were in a single file i.e. Activity class. With fragment approach, we can now remove View management code from Activity and place them in their respective Java classes. So, a pretty neat approach for code management. Here I'll explain various concepts of Fragment with an example appli

HashMap Internal

I always wanted to implement the logic behind the famous data structure of Java , HashMap and here it comes. Though it’s not the complete implementation considering all optimization scenarios, but it will highlight the basic algorithm behind the HashMap . So let’s start, this implementation will use my LinkedList implementation (Reason: for this implementation I thought to write everything from the scratch apart from primitive data types. Sounds weird? May be ;-) ). You may refer my earlier post on LinkedList , as I’m going to use it. HashMap is a key-value pair data structure, where you retrieve value by passing key. To optimize the search of key, a concept of Bucket (an Array of Java Objects) has been introduced. This is used, so that if search hits this Bucket , corresponding value element is instantly retrieved, otherwise it iterates sequentially through the Linked List associated with each Bucket element. So you can say if all HashMap elements get fit into the Bucket, retrieving

Accessing Yahoo Finance API

Since last few days I was wondering the right set of Web Service to read Country wise Stock Exchange index information . I found a bunch of scattered information, but no straight forward answer. It seems there are not many "reliable" and "flexible" options and Yahoo Finance is one of the top of this class. Though Yahoo Finance is very powerful, some how its very less documented and it seems Yahoo doesn't care much about this wonderful web service and expect Developers to do some kind of "hacking". The only online resource that I (and most of you as well ) found is one 3rd party web site- and it seems they know much more than what Yahoo dose..;-) Anyway let me continue and share my experience and information to help budding developer who wants to use Yahoo Finance Web Service in their Mobile, Web o r Desktop s olution. There are 2 set of APIs to access Yahoo Finance details- YQL based Web Service : Th

Eclipse EGIT, Download Code, Attach Framework code & Debug

This article explains procedure to download Android source (few important Apps and Framework base code) using Eclipse EGit plugin and then attach framework code to debug important framework classes (e.g. Activity etc.). Install EGit Download Source from GIT Repository Attach Framework code Debug Download EGit Plug-in EGit is a GIT plugin for Eclipse which helps to mange GIT clone, Check-ins, Sync etc. from your Eclipse workspace. Eclipse (Version: 3.7.x) -> Help -> Install New Software -> "Add" - " ". Once the plug-in installation is successful, you'll find a new Eclipse View perspective- "Git Repository Exploring"    Download Android source To download code from Android GIT repository, we need to create "local Git clone". Each local clone is associated with Remote Clone URL. lists Git Repository URLs for different sections of An