`require': cannot load such file -- nokogiri (LoadError) in rubyXL

Rails
1

Hi All

Getting the below error when running the source code

My requirement is : I want read / write the excel sheet ( both xls /
xlsx )
from Ruby , if you have any other solution also share with me …

Source Code :
*
*
*
bash-3.2$ cat rubyXL.rb
require ‘rubyXL’
workbook = RubyXL::Parser.parse(“test.xlsx”)
workbook = RubyXL::Workbook.new
sheet_Name = workbook.worksheets[0]
puts sheet_Name

ERROR
rubyXL.rb
/usr/local/Cellar/ruby/2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:45:in
*require': cannot load such file -- nokogiri (LoadError)* from /usr/local/Cellar/ruby/2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:45:inrequire’
from
/Users/mselv2/.rvm/gems/ruby-1.8.7-p371/gems/rubyXL-1.2.10/lib/rubyXL/writer/content_types_writer.rb:6:in
<top (required)>' from /usr/local/Cellar/ruby/2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:45:inrequire’
from
/usr/local/Cellar/ruby/2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:45:in
require' from /Users/mselv2/.rvm/gems/ruby-1.8.7-p371/gems/rubyXL-1.2.10/lib/rubyXL/workbook.rb:1:in<top (required)>’
from
/usr/local/Cellar/ruby/2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:45:in
require' from /usr/local/Cellar/ruby/2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:45:inrequire’
from
/Users/mselv2/.rvm/gems/ruby-1.8.7-p371/gems/rubyXL-1.2.10/lib/rubyXL.rb:2:in
<top (required)>' from /usr/local/Cellar/ruby/2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:110:inrequire’
from
/usr/local/Cellar/ruby/2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:110:in
rescue in require' from /usr/local/Cellar/ruby/2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:35:inrequire’
from rubyXL.rb:1:in `’

Installed rubyXL also :
*
*
bash-3.2$ gem list | grep “XL”
rubyXL (1.2.10)

Thanks ,
Muthu S. SR

2

On Jun 18, 2013, at 7:17 PM, Muthu S. wrote:

require ‘rubyXL’
workbook = RubyXL::Parser.parse(“test.xlsx”)
workbook = RubyXL::Workbook.new
sheet_Name = workbook.worksheets[0]
puts sheet_Name

Try adding require statements for rubygems and nokogiri. It seems like
something in there is depending on Noko, which isn’t surprising, since
it’s the Swiss army bulldozer of XML.

Walter

3

Muthu S. [email protected] wrote:

My requirement is : I want read / write the excel sheet ( both xls / xlsx ) from
Ruby , if you have any other solution also share with me …

You may want to ask on the ruby list instead of the rubyonrails list…

rubyXL.rb

/usr/local/Cellar/ruby/2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:45:in
`require’: cannot load such file – nokogiri (LoadError)

Silly question: did you install nokogiri? That message above tells you
just what it cannot find.

Installed rubyXL also :

bash-3.2$ gem list | grep “XL”
rubyXL (1.2.10)

Now try:

gem list | grep nokogiri

In looking at the rubyXL gem, the gemspec file does list nokogiri and a
few other things as run-time dependencies, but I don’t quite understand
the syntax used in the .gemspec – it looks like it should pull them
in, but neither gem install nor bundle install (if rubyXL is placed in a
Gemfile) are getting included.

If you look inside the rubyXL.gemspec file where rubyXL was installed,
you can find the other things it depends on and install those as well.