bradgessler-google-spreadsheet-ruby

This is a library to read/write Google Spreadsheet.

= How to install

$ gem sources -a http://gems.github.com $ sudo gem install gimite-google-spreadsheet-ruby

= How to use

Example:

require "rubygems" require "google_spreadsheet"

Logs in.

session = GoogleSpreadsheet.login("[e-mail]", "mypassword")

First worksheet of http://spreadsheets.google.com/ccc?key=pz7XtlQC-PYx-jrVMJErTcg&hl=en

ws = session.spreadsheet_by_key("pz7XtlQC-PYx-jrVMJErTcg").worksheets[0]

Gets content of A2 cell.

p ws[2, 1] #==> "hoge"

Changes content of cells. Changes are not sent to the server until you call ws.save().

ws[2, 1] = "foo" ws[2, 2] = "bar" ws.save()

You can also loop through rows

ws.rows.each do |row| row[2] = "bar" end

Reloads the worksheet to get changes by other clients.

ws.reload()

API document: http://gimite.net/gimite/rubymess/google-spreadsheet-ruby/

= Source code

http://github.com/gimite/google-spreadsheet-ruby/tree/master

The license of this source is "New BSD Licence"

= Author

Hiroshi Ichikawa - http://gimite.net/en/index.php?Contact Brad Gessler - http://bradgessler.com/