# google-spreadsheet-ruby

**Repository Path**: mirrors_sirupsen/google-spreadsheet-ruby

## Basic Information

- **Project Name**: google-spreadsheet-ruby
- **Description**: Ruby library to read/write Google Spreadsheet
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-09-25
- **Last Updated**: 2026-03-08

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

This is a Ruby 1.8/1.9 library to read/write Google Spreadsheet.


= How to install

  $ sudo gem install google-spreadsheet-ruby

Note that gimite-google-spreadsheet-ruby at gems.github.com is no longer updated, because github stopped hosting it.


= How to use

Example:
  
  require "rubygems"
  require "google_spreadsheet"
  
  # Logs in.
  # You can also use OAuth. See document of GoogleSpreadsheet.login_with_oauth for details.
  session = GoogleSpreadsheet.login("username@gmail.com", "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()
  
  # Dumps all cells.
  for row in 1..ws.num_rows
    for col in 1..ws.num_cols
      p ws[row, col]
    end
  end
  
  # Yet another way to do so.
  p ws.rows #==> [["fuga", ""], ["foo", "bar]]
  
  # 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

The license of this source is "New BSD Licence"


= Supported environments

Ruby 1.8.x and Ruby 1.9.x. Checked with Ruby 1.8.7 and Ruby 1.9.3.


= Author

Hiroshi Ichikawa - http://gimite.net/en/index.php?Contact