Why this script doesn't work?

< :the previous in number ^ :the list in numerical order > :the next in number P :the previous aricle (the previous thread) N :the next (in thread) |<:the previous thread >|:the next thread ^ :the parent (reply-to) _:the child (an article replying to this) >:the elder article having the same parent <:the youger article having the same parent ---:split window and show thread lists | :split window (vertically) and show thread lists ~ :close the thread frame .:the index ..:the index of indices

Hi all,

I copy a script from WIN32OLE documentation and run it. I find that Ruby
complains it at line    cells = sheets.cells("A1:A5").

Do I miss something?

Thanks,

Li

##
require 'win32ole'

  excel = WIN32OLE.new('Excel.Application')
  excel.Visible="True"

   book = excel.workbooks.add
   sheets = book.worksheets(1)

   cells = sheets.cells("A1:A5")

   cells.each do |row|
     row.value = 10
   end

##output
>ruby test3.rb
test3.rb:13:in `method_missing': cells (WIN32OLERuntimeError)
    OLE error code:80020005 in <Unknown>
      <No Description>
    HRESULT error code:0x80020009
      Exception occurred.  from test3.rb:13
>Exit code: 1

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