geekswithblogs.net

Lance's TextBox

For software developers using IPWorks, PowerShell, RSSBus, etc.


News

 Subscribe Add to Technorati Favorites

 

 

 

 


 

 

Search My Blog:

 

 

My Stats

  • Posts - 439
  • Comments - 188
  • Trackbacks - 265

Twitter












Tag Cloud


Recent Comments


Recent Posts


Archives


Post Categories


Blogs


Miscellanous


Noteworthy Stuff


Popular Posts


<< Google Spreadsheets API | Home | "White and Nerdy" - hilarious! >>

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 @ Thursday, June 08, 2006 2:14 PM | Filed Under [ Programming Software ]

Comments

Gravatar # re: Google Spreadsheets API: Library and Demo
Posted by Patrick on 6/28/2006 12:29 AM
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!
Gravatar # re: Google Spreadsheets API: Library and Demo
Posted by Lance on 6/28/2006 6:32 AM
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.
Gravatar # re: Google Spreadsheets API: Library and Demo
Posted by Frank on 6/28/2006 11:30 AM
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).
Gravatar # re: Google Spreadsheets API: Library and Demo
Posted by Lance on 6/28/2006 11:43 AM
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.
Gravatar # re: Google Spreadsheets API: Library and Demo
Posted by phil s on 7/25/2006 11:48 AM
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.
Gravatar # re: Google Spreadsheets API: Library and Demo
Posted by Lance on 7/25/2006 11:51 AM
Thanks Phil!
Gravatar # re: Google Spreadsheets API: Library and Demo
Posted by RNA on 8/29/2006 11:22 PM
Are you sharing the code for GSheet? I'm getting exceptions with dowloaded tool during loggin.
Gravatar # re: Google Spreadsheets API: Library and Demo
Posted by Lance Robinson on 9/5/2006 11:14 AM
Yes, sorry about that - the link changed, but I fixed it.
Gravatar # re: Google Spreadsheets API: Library and Demo
Posted by Thomy Kay on 12/21/2006 2:25 AM
Get an IPWorksSSL.IPWorksSSLHttpsException exception on Auth(). In the browser I can login,.
Gravatar # re: Google Spreadsheets API: Library and Demo
Posted by Stock photos on 7/12/2007 6:11 PM
Can i translate this and insert on my site in Poland? Thanks
Gravatar # re: Google Spreadsheets API: Library and Demo
Posted by Nicole on 1/14/2008 6:21 PM
What language are you using to do this? I need a way to modify particular rows/cells using JavaScript. Any suggestions?
Post a comment





 

Please add 4 and 3 and type the answer here: