cheat sheets.

roo gem - http://roo.rubyforge.org/

roo is a Ruby gem to read the following Excel and OpenOffice formats: 
  * Open-office spreadsheets (.ods)
  * Excel spreadsheets (.xls)
  * Google (online) spreadsheets
  * Excel’s new file format .xlsx


INSTALLATION
===================
gem install roo


USAGE
==================
 require 'rubygems'
 require 'roo'
 
 oo = Openoffice.new("simple_spreadsheet.ods")
 oo.default_sheet = oo.sheets.first

 # iterate all rows 
 # cells are named 1,A, 1,B, 2,A, 2,B etc.. 
 0.upto(oo.last_row) do |line|
   name = oo.cell(line,'A')
   age = oo.cell(line,'B')

   puts "Name: #{name}"
   puts "Age: #{age}\n"
 end

 DOCUMENTATION
 ================
 http://roo.rubyforge.org/rdoc/index.html