From: Ruby Student <ruby.student@...>
Date: 2009-10-11T04:20:42+09:00
Subject: Question about "spreadsheet"

I am trying to learn how to use "spreadsheet" so I can create an Excel file.
To that effect, I installed:

1 - spreadsheet
2 - ruby-ole

I noticed that the Rdoc for "spreadsheet" contains an example which
looks simple enough to learn, and so I cut/pasted it into a file.
I tried running the file and got the errors listed below.
Any help will be appreciated!

Thank you



# First, make sure all that code is loaded:


               require 'spreadsheet'

# Worksheets come in various Encodings.


                     # You need to tell Spreadsheet which Encoding you
want to deal with.

                              # The Default is UTF-8


                                 Spreadsheet.client_encoding = 'UTF-8'

book = Spreadsheet::Workbook.new
sheet1 = book.create_worksheet
sheet1.row(0).concat %w{Name Country Acknowlegement}
sheet1[1,0] = 'Japan'
row = sheet1.row(1)
row.push 'Creator of Ruby'
row.unshift 'Yukihiro Matsumoto'

sheet1.row(2).replace [ 'Daniel J. Berger', 'U.S.A.',
'Author of original code for Spreadsheet::Excel' ]
sheet1.row(3).push 'Charles Lowe', 'Author of the ruby-ole Library'
sheet1.row(3).insert 1, 'Unknown'
sheet1.update_row 4, 'Hannes Wyss', 'Switzerland', 'Author'

# Add some Formatting for flavour:
sheet1.row(0).height = 18
format = Spreadsheet::Format.new :color => :blue,
                                                   :weight => :bold,
                                                   :size => 18

sheet1.row(0).default_format = format
bold = Spreadsheet::Format.new :weight => :bold
4.times do |x| sheet1.row(x + 1).set_format(0, bold) end

# And finally, write the Excel File:
book.write '/F:/MyFiles/excel-file.xls'

F:\>ruby ss.rb
C:/ruby/lib/ruby/gems/1.9.1/gems/ruby-ole-1.2.10/lib/ole/types/base.rb:1:in
`require': no such file to load -- iconv (LoadError)
        from C:/ruby/lib/ruby/gems/1.9.1/gems/ruby-ole-1.2.10/lib/ole/types/base.rb:1:in
`<top (required)>'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/ruby-ole-1.2.10/lib/ole/types.rb:1:in
`require'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/ruby-ole-1.2.10/lib/ole/types.rb:1:in
`<top (required)>'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/ruby-ole-1.2.10/lib/ole/storage/base.rb:4:in
`require'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/ruby-ole-1.2.10/lib/ole/storage/base.rb:4:in
`<top (required)>'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/ruby-ole-1.2.10/lib/ole/storage.rb:1:in
`require'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/ruby-ole-1.2.10/lib/ole/storage.rb:1:in
`<top (required)>'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/ruby-ole-1.2.10/lib/ole/storage/file_system.rb:32:in
`require'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/ruby-ole-1.2.10/lib/ole/storage/file_system.rb:32:in
`<top (required)>'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/ruby-ole-1.2.10/lib/ole/file_system.rb:2:in
`require'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/ruby-ole-1.2.10/lib/ole/file_system.rb:2:in
`<top (required)>'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:6:in
`require'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer/workbook.rb:6:in
`<top (required)>'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer.rb:1:in
`require'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/writer.rb:1:in
`<top (required)>'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/workbook.rb:3:in
`require'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.4.1/lib/spreadsheet/excel/workbook.rb:3:in
`<top (required)>'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.4.1/lib/spreadsheet.rb:27:in
`require'
        from C:/ruby/lib/ruby/gems/1.9.1/gems/spreadsheet-0.6.4.1/lib/spreadsheet.rb:27:in
`<top (required)>'
        from ss.rb:3:in `require'
        from ss.rb:3:in `<main>'

F:\>gem list
*** LOCAL GEMS ***
ezcrypto (0.7.2)
innate (2009.06.12)
rack (1.0.0)
ramaze (2009.06.12)
ruby-ole (1.2.10)
rubygems-update (1.3.4)
spreadsheet (0.6.4.1)
wxruby-ruby19 (2.0.0)

F:\>ruby -v
ruby 1.9.1p0 (2009-01-30 revision 21907) [i386-mingw32]
Running under Windows/XP for now.

--
Ruby Student