Lance's TextBox

About Me       - Also see my RSS simple services site.
  Home  |   Contact  |   Syndication    |   Login
  510 Posts | 7 Stories | 379 Comments | 258 Trackbacks

News

Lance Robinson is a product manager and software developer in Durham, Chapel Hill, Raleigh, and surrounding areas. More about Lance.

 Subscribe Add to Technorati Favorites

 

 

 

 


 

 

Search My Blog:

 

 

Twitter












Tag Cloud


Archives

Post Categories

Blogs

Miscellanous

Noteworthy Stuff

Popular Posts

Google Spreadsheets API: Library and Demo

Ready for some feedback.  Download the library and let me know what you think.  There is a csharp winforms demo included that shows how to use the GSheet class that is contained in the dll.  Contents of the zip:

csharpDemo - Folder containing the csharp source code of the demo
GoogleSpreadsheetsAPI.dll - Library containing the GSheet class.
nsoftware.IPWorksSSL.dll - IP*Works! SSL library for communications code

Update: Download it here, source included.

Update 2:  The library is no longer available.  Instead, I am using the RSSBus GsheetOps connector.  Example here.

Technorati tags:    

posted on Thursday, June 08, 2006 2:14 PM

Feedback

# re: Google Spreadsheets API: Library and Demo 6/28/2006 12:29 AM Patrick
The API looks good and the sample is helpful, but I am getting an exception thrown when gs.Auth() is called
"Exception GoogleSpreadsheetsAPI.GSSAPIException was thrown in debugee:
Authentication error."

I manually pieced together the URL that is used for the form post in gs.Auth() by opening up your DLL in a disassembler, and it works correctly:
"http://www.google.com/accounts/ServiceLoginAuth?service=wise&nui=1&Email=xxx@yyy.com&Passwd=zzz&PersistentCookie=yes&rmShown=1"

Since the syntax for the URL is correct, I can't figure out what's going on without the source. Any ideas? Thanks for your help!

# re: Google Spreadsheets API: Library and Demo 6/28/2006 6:32 AM Lance
Hmm....you're using the email address that you created a Google Spreadsheets account with, right? I just tried it here and can't reproduce. I am using my gmail email address (both without the @gmail.com and with it works fine for me).

Send me an email and I will send you the source for the dll itself.

# re: Google Spreadsheets API: Library and Demo 6/28/2006 11:30 AM Frank
Are you sharing the code for GSheet? What I'm looking for is the URL format to get at the rows and / or cells of a sheet (so just sharing that info would be a big help).


# re: Google Spreadsheets API: Library and Demo 6/28/2006 11:43 AM Lance
Frank, I will send the source to anyone who emails me, but I am not going to post it here for download until I get it cleaned up and get more feedback on it.

I can show you how to alter the data at a particular row/cell, but as for retrieving the data at a particular row/cell, the only way I know is to begin downloading the entire sheet until you have the row/cell you need.

# re: Google Spreadsheets API: Library and Demo 7/25/2006 11:48 AM phil s
hi, just wanted to chime in and say that you might want to avoid using the abbreviation "GSSAPI" since that is already used by the Globus toolkit.

# re: Google Spreadsheets API: Library and Demo 7/25/2006 11:51 AM Lance
Thanks Phil!

# re: Google Spreadsheets API: Library and Demo 8/29/2006 11:22 PM RNA
Are you sharing the code for GSheet? I'm getting exceptions with dowloaded tool during loggin.

# re: Google Spreadsheets API: Library and Demo 9/5/2006 11:14 AM Lance Robinson
Yes, sorry about that - the link changed, but I fixed it.

# re: Google Spreadsheets API: Library and Demo 12/21/2006 2:25 AM Thomy Kay
Get an IPWorksSSL.IPWorksSSLHttpsException exception on Auth(). In the browser I can login,.

# re: Google Spreadsheets API: Library and Demo 7/12/2007 6:11 PM Stock photos
Can i translate this and insert on my site in Poland? Thanks

# re: Google Spreadsheets API: Library and Demo 1/14/2008 6:21 PM Nicole
What language are you using to do this? I need a way to modify particular rows/cells using JavaScript. Any suggestions?

# re: Google Spreadsheets API: Library and Demo 7/2/2009 3:28 AM tolga
Thank you İnformation

# re: Google Spreadsheets API: Library and Demo 7/2/2009 3:30 AM sxe
Thank You İnformation

Post Feedback

Title:
Name:
Email: (never displayed)
Url:
Comments: