Geeks With Blogs

News

qrcode

Lance Robinson

Create Your Badge

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

 Subscribe


Lance's TextBox » About Me » My Resume »Twitter

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 8, 2006 2:14 PM Programming , Software | Back to top


Comments on this post: Google Spreadsheets API: Library and Demo

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
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!
Left by Patrick on Jun 28, 2006 12:29 AM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
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.
Left by Lance on Jun 28, 2006 6:32 AM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
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).
Left by Frank on Jun 28, 2006 11:30 AM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
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.
Left by Lance on Jun 28, 2006 11:43 AM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
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.
Left by phil s on Jul 25, 2006 11:48 AM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
Thanks Phil!
Left by Lance on Jul 25, 2006 11:51 AM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
Are you sharing the code for GSheet? I'm getting exceptions with dowloaded tool during loggin.
Left by RNA on Aug 29, 2006 11:22 PM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
Yes, sorry about that - the link changed, but I fixed it.
Left by Lance Robinson on Sep 05, 2006 11:14 AM

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

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
Can i translate this and insert on my site in Poland? Thanks
Left by Stock photos on Jul 12, 2007 6:11 PM

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

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
Thank you İnformation
Left by tolga on Jul 02, 2009 3:28 AM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
Thank You İnformation
Left by sxe on Jul 02, 2009 3:30 AM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
Thank youu.
Left by en güzel oyunlar on Jul 10, 2009 12:32 PM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
Thank you
Left by bosch servisi on Jul 10, 2009 12:33 PM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
Thank. Very nice
Left by mp3 dinle on Jul 10, 2009 12:34 PM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
Thank you .
Left by koxp on Jul 10, 2009 12:37 PM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
thanx google
Left by klima on Aug 26, 2009 11:44 PM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
thanks for information
Left by bosch servisi on Jul 24, 2010 8:15 AM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
Please give the source code to export a grid to google spreadsheet
Left by kaarthick on Sep 09, 2011 3:07 PM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
What language are you using to do this? I need a way to modify particular rows/cells using JavaScript. Any suggestions?
Left by ahmet on Nov 22, 2011 10:21 AM

# re: Google Spreadsheets API: Library and Demo
Requesting Gravatar...
thank you..admin
Left by en güzel oyunlar on May 10, 2013 4:26 PM

Your comment:
 (will show your gravatar)


Copyright © Lance Robinson | Powered by: GeeksWithBlogs.net