Skip to content

Instantly share code, notes, and snippets.

@stevendaniels
Forked from reshleman/irb
Last active December 11, 2017 19:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save stevendaniels/98a05849036e99bb8b3c to your computer and use it in GitHub Desktop.
Save stevendaniels/98a05849036e99bb8b3c to your computer and use it in GitHub Desktop.
Roo Bug Report
irb(main):001:0> require "roo"
=> true
irb(main):002:0> require "roo/version"
=> true
irb(main):003:0> Roo::VERSION
=> "2.0.0"
irb(main):004:0> sheet = Roo::Spreadsheet.open("/Users/reshleman/Desktop/roo_error.xlsx", extension: "xlsx")
=> {[1, 1]=>#<Roo::Excelx::Cell:0x007fe6b297fef0 @type=:string, @formula=nil, @excelx_type=:string, @excelx_value="0", @style=0, @value="name", @coordinate=#<Roo::Excelx::Cell::Coordinate:0x007fe6b297ff40 @row=1, @column=1>>, [2, 1]=>#<Roo::Excelx::Cell:0x007fe6b297f798 @type=:string, @formula=nil, @excelx_type=:string, @excelx_value="1", @style=0, @value="Robert Eshleman", @coordinate=#<Roo::Excelx::Cell::Coordinate:0x007fe6b297f7e8 @row=2, @column=1>>}
irb(main):005:0> sheet.parse(name: "name")
=> [{:name=>"name"}, {:name=>"Robert Eshleman"}]
irb(main):006:0> sheet.parse(name: "name", clean: true)
NoMethodError: undefined method `read_cells' for #<Roo::Excelx:0x007fe6b2a1e320>
from /Users/reshleman/.rbenv/versions/2.2.0/lib/ruby/gems/2.2.0/gems/roo-2.0.0/lib/roo/base.rb:306:in `method_missing'
from /Users/reshleman/.rbenv/versions/2.2.0/lib/ruby/gems/2.2.0/gems/roo-2.0.0/lib/roo/excelx.rb:284:in `method_missing'
from /Users/reshleman/.rbenv/versions/2.2.0/lib/ruby/gems/2.2.0/gems/roo-2.0.0/lib/roo/base.rb:525:in `clean_sheet'
from /Users/reshleman/.rbenv/versions/2.2.0/lib/ruby/gems/2.2.0/gems/roo-2.0.0/lib/roo/base.rb:329:in `clean_sheet_if_need'
from /Users/reshleman/.rbenv/versions/2.2.0/lib/ruby/gems/2.2.0/gems/roo-2.0.0/lib/roo/base.rb:372:in `each'
from /Users/reshleman/.rbenv/versions/2.2.0/lib/ruby/gems/2.2.0/gems/roo-2.0.0/lib/roo/base.rb:387:in `parse'
from (irb):6
from /Users/reshleman/.rbenv/versions/2.2.0/bin/irb:11:in `<main>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment