posts - 598 , comments - 849 , trackbacks - 247

My Links

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

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:    

Print | posted on Thursday, June 8, 2006 2:14 PM | Filed Under [ Programming Software ]

Feedback

Gravatar

# re: Google Spreadsheets API: Library and Demo

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

# re: Google Spreadsheets API: Library and Demo

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

# re: Google Spreadsheets API: Library and Demo

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

# re: Google Spreadsheets API: Library and Demo

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

# re: Google Spreadsheets API: Library and Demo

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

# re: Google Spreadsheets API: Library and Demo

Thanks Phil!
7/25/2006 11:51 AM | Lance
Gravatar

# re: Google Spreadsheets API: Library and Demo

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

# re: Google Spreadsheets API: Library and Demo

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

# re: Google Spreadsheets API: Library and Demo

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

# re: Google Spreadsheets API: Library and Demo

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

# re: Google Spreadsheets API: Library and Demo

What language are you using to do this? I need a way to modify particular rows/cells using JavaScript. Any suggestions?
1/14/2008 6:21 PM | Nicole
Gravatar

# re: Google Spreadsheets API: Library and Demo

Thank you İnformation
7/2/2009 3:28 AM | tolga
Gravatar

# re: Google Spreadsheets API: Library and Demo

Thank You İnformation
7/2/2009 3:30 AM | sxe
Gravatar

# re: Google Spreadsheets API: Library and Demo

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

# re: Google Spreadsheets API: Library and Demo

Thank you
7/10/2009 12:33 PM | bosch servisi
Gravatar

# re: Google Spreadsheets API: Library and Demo

Thank. Very nice
7/10/2009 12:34 PM | mp3 dinle
Gravatar

# re: Google Spreadsheets API: Library and Demo

Thank you .
7/10/2009 12:37 PM | koxp
Gravatar

# re: Google Spreadsheets API: Library and Demo

thanx google
8/26/2009 11:44 PM | klima
Gravatar

# re: Google Spreadsheets API: Library and Demo

thanks for information
7/24/2010 8:15 AM | bosch servisi
Gravatar

# re: Google Spreadsheets API: Library and Demo

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

# re: Google Spreadsheets API: Library and Demo

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

# re: Google Spreadsheets API: Library and Demo

thank you..admin
5/10/2013 4:26 PM | en güzel oyunlar
Post A Comment
Title:
Name:
Email:
Comment:
Verification:
 

Powered by: