Here's my code:


require 'C:\Ruby\lib\ruby\gems\1.9.1\gems\roo-1.9.3\lib\roo'

s = Openoffice.new("myspreadsheet.ods")      
s.default_sheet = s.sheets.first


s.cell(1,1)                                 
s.cell('A',1)                               
s.cell(1,'A')                               
s.cell(1,'A',s.sheets[0]) 

s.cell(1,1)                                 
s.cell('A',1)                               
s.cell(1,'A')                               
s.cell(1,'A',s.sheets[0]) 

and here's how it fails:

C:\Ruby>wksheet.rb
<internal:lib/rubygems/custom_require>:29:in `require': no such file to load --
google_spreadsheet (LoadError)
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from C:/Ruby/lib/ruby/gems/1.9.1/gems/roo-1.9.3/lib/roo/google.rb:2:in `
<top (required)>'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from C:/Ruby/lib/ruby/gems/1.9.1/gems/roo-1.9.3/lib/roo.rb:71:in `<top (
required)>'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from <internal:lib/rubygems/custom_require>:29:in `require'
        from C:/Ruby/wksheet.rb:2:in `<main>'

My path for the roo gem is this:
C:\Ruby\lib\ruby\gems\1.9.1\gems\roo-1.9.3\lib\roo

There is a google.rb file in this subdirectory, but no sign of a google_spreadsheet.rb file anywhere.

Date: 2011-03-24 21:52
Sender: James Brown

This appears to be fixable by installing
the "google-spreadsheet-ruby" gem

In total the following gems are required:

builder
zip
nokogiri
spreadsheet
google-spreadsheet-ruby

Date: 2011-01-18 06:42
Sender: Scott Peterson

I got my code to run by commenting out line 2 in the file
C:\Ruby\lib\ruby\gems\1.9.1\gems\roo-1.9.3\lib\roo\google.rb
which was:

require "google_spreadsheet"