How to get List of spreadsheet from google drive?

Question

Hello Friends I need to get the list of spreadsheet with data available in Google drive by using c# language. I was using the following code SpreadsheetsService service = new SpreadsheetsService ( GDriveSpreadSheet ); ; service.setUserCredentials( UserName  password ); SpreadsheetQuery Q = new SpreadsheetQuery (); SpreadsheetFeed F = service.Query(Q); SpreadsheetEntry spreadsheet = ( SpreadsheetEntry )F.Entries[0]; WorksheetFeed wsFeed = spreadsheet.Worksheets; But I'm getting invalid Credential exception in the above marked line... Can any one help me!!! Thanks

Ramesh Maruthi · Answer

Hi Marutharasu You code looks perfect it should work can you double check whether your giving the right Credentials or not ?

Marutharasu P · Answer

Hi Ramesh GDriveSpreadSheet - This is Project Name and also I am having Full control access in this project. I don't know why I am getting error? Can We have any network domain level configuration settings?

Ramesh Maruthi · Answer

Hey Marutharasu Thanks for accepting the answer please look at the below link. I compared your code it was pretty good. The only thing. I can suggest you is does GDriveSpreadSheet has the permissions to open it like read/write permissions ?

Marutharasu P · Answer

Ramesh I have checked lot of times... But still I m getting invalid credential exception only... Is there any other way to get the list of spread sheet from Google drive?