error access google spreadsheet

28 views
Skip to first unread message

P3terPan

unread,
Aug 11, 2009, 10:53:15 AM8/11/09
to ruby-roo
Hello group

I'm trying open a google spreadsheet but I've obtained this error.

"/opt/local/lib/ruby/gems/1.8/gems/roo-1.3.9/lib/roo/
generic_spreadsheet.rb:26:in `default_sheet=': what are you trying to
set as default sheet? (TypeError)"

I attached the code:

require 'rubygems'
require 'roo'

s = Google.new('http://spreadsheets.google.com/ccc?
key=pEcLrW3b2djraE8JF_2fJWA')

s.default_sheet = s.sheets.first

puts s.cell(1,1)

Thanks for your help

Thomas Preymesser

unread,
Aug 11, 2009, 11:40:46 AM8/11/09
to ruby-roo


On Aug 11, 4:53 pm, P3terPan <victor.deand...@gmail.com> wrote:

>  s = Google.new('http://spreadsheets.google.com/ccc?
> key=pEcLrW3b2djraE8JF_2fJWA')

this is the correct call:

s = Google.new('pEcLrW3b2djraE8JF_2fJWA')

-Thomas
Reply all
Reply to author
Forward
0 new messages