From: Henry Oss <oss.hcs@...>
Date: 2011-01-21T07:19:50+09:00
Subject: Read spreadsheet from internet

I am probably no longer justified in claiming to a newbie, but I suspect
this is a newbie question.

I am using the spreadsheet gem and I need to open a spreadsheet for
which I have a URL.  Following
http://stackoverflow.com/questions/263536/open-an-io-stream-from-a-local-file-or-url
I have done the following:

web_contents  = open(url) {|f| f.read }
book = Spreadsheet.open web_contents

And I am getting:
/usr/local/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.1/lib/spreadsheet.rb:68:in
`initialize': string contains null byte (ArgumentError)
  from
/usr/local/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.1/lib/spreadsheet.rb:68:in
`open'
  from
/usr/local/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.5.1/lib/spreadsheet.rb:68:in
`open'

What am I doing wrong?

Henry

-- 
Posted via http://www.ruby-forum.com/.