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:    

  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

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

Feedback

# re: Google Spreadsheets API: Library and Demo

Left by Patrick at 6/28/2006 12:29 AM
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!

# re: Google Spreadsheets API: Library and Demo

Left by Lance at 6/28/2006 6:32 AM
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.

# re: Google Spreadsheets API: Library and Demo

Left by Frank at 6/28/2006 11:30 AM
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).

# re: Google Spreadsheets API: Library and Demo

Left by Lance at 6/28/2006 11:43 AM
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.

# re: Google Spreadsheets API: Library and Demo

Left by phil s at 7/25/2006 11:48 AM
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.

# re: Google Spreadsheets API: Library and Demo

Left by Lance at 7/25/2006 11:51 AM
Gravatar Thanks Phil!

# re: Google Spreadsheets API: Library and Demo

Left by RNA at 8/29/2006 11:22 PM
Gravatar Are you sharing the code for GSheet? I'm getting exceptions with dowloaded tool during loggin.

# re: Google Spreadsheets API: Library and Demo

Left by Lance Robinson at 9/5/2006 11:14 AM
Gravatar Yes, sorry about that - the link changed, but I fixed it.

# re: Google Spreadsheets API: Library and Demo

Left by Thomy Kay at 12/21/2006 2:25 AM
Gravatar Get an IPWorksSSL.IPWorksSSLHttpsException exception on Auth(). In the browser I can login,.

# re: Google Spreadsheets API: Library and Demo

Left by Stock photos at 7/12/2007 6:11 PM
Gravatar Can i translate this and insert on my site in Poland? Thanks

# re: Google Spreadsheets API: Library and Demo

Left by Nicole at 1/14/2008 6:21 PM
Gravatar 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

Left by tolga at 7/2/2009 3:28 AM
Gravatar Thank you İnformation

# re: Google Spreadsheets API: Library and Demo

Left by sxe at 7/2/2009 3:30 AM
Gravatar Thank You İnformation

# re: Google Spreadsheets API: Library and Demo

Left by en güzel oyunlar at 7/10/2009 12:32 PM
Gravatar Thank youu.

# re: Google Spreadsheets API: Library and Demo

Left by bosch servisi at 7/10/2009 12:33 PM
Gravatar Thank you

# re: Google Spreadsheets API: Library and Demo

Left by mp3 dinle at 7/10/2009 12:34 PM
Gravatar Thank. Very nice

# re: Google Spreadsheets API: Library and Demo

Left by koxp at 7/10/2009 12:37 PM
Gravatar Thank you .

# re: Google Spreadsheets API: Library and Demo

Left by klima at 8/26/2009 11:44 PM
Gravatar thanx google

# re: Google Spreadsheets API: Library and Demo

Left by bosch servisi at 7/24/2010 8:15 AM
Gravatar thanks for information

# re: Google Spreadsheets API: Library and Demo

Left by kaarthick at 9/9/2011 3:07 PM
Gravatar Please give the source code to export a grid to google spreadsheet

# re: Google Spreadsheets API: Library and Demo

Left by ahmet at 11/22/2011 10:21 AM
Gravatar What language are you using to do this? I need a way to modify particular rows/cells using JavaScript. Any suggestions?

Your comment:





 
 

Copyright © Lance Robinson

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski