# Question about "spreadsheet" **URL:** \ **Category:** Ruby\ **Created:** [October 10, 2009, 9:23pm UTC](https://www.ruby-forum.com/t/question-about-spreadsheet/177066 "2009-10-10T21:23:18Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![rubina](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e47c2d/32.png) [@rubina](https://www.ruby-forum.com/u/rubina)\ **Post date:** [October 10, 2009, 9:23pm UTC](https://www.ruby-forum.com/t/question-about-spreadsheet/177066/1 "2009-10-10T21:23:18Z")
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 M.’ sheet1.row(2).replace [ ‘Daniel J. Berger’, ‘U.S.A.’, ‘Author of original code for Spreadsheet::Excel’ ] sheet1.row(3).push ‘Charles L.’, ‘Author of the ruby-ole Library’ sheet1.row(3).insert 1, ‘Unknown’ sheet1.update\_row 4, ‘Hannes W.’, ‘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`\’ 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`\’ 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`\’ 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`\’ 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`\’ 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`\’ 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`\’ 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`\’ 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`\’ 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`\’ from ss.rb:3:in `require' from ss.rb:3:in`’ 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. ---
**Author:** ![rubina](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e47c2d/32.png) [@rubina](https://www.ruby-forum.com/u/rubina)\ **Post date:** [December 19, 2009, 6:01pm UTC](https://www.ruby-forum.com/t/question-about-spreadsheet/177066/2 "2009-12-19T18:01:58Z")
Since no one has posted a reply, and you haven’t posted back that you fixed this, I’ll chime in regardless of the passage of time. The error message was saying you didn’t install the iconv gem. `require’: no such file to load – iconv ---
**Author:** ![rubina](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e47c2d/32.png) [@rubina](https://www.ruby-forum.com/u/rubina)\ **Post date:** [December 25, 2009, 3:15pm UTC](https://www.ruby-forum.com/t/question-about-spreadsheet/177066/3 "2009-12-25T15:15:37Z")
Wow! I have given up on this. I had not fix it yet. Thank you for your reply.