Re: Can't sort array

Ruby
1

Hi all,

I want to print all the methods in excel OLE object
in alphabetic order but the sort method is
unavailable. Can anyone explain it and help me fix it?

Thank you,

Li

require ‘win32ole’
excel = WIN32OLE.new(‘Excel.Application’)
m = excel.ole_methods
p m.class
p m.sort

##screen output

ruby sort1.rb

Array
sort1.rb:6:in sort': undefined method<=>’ for
Rows:WIN32OLE_METHOD (NoMethodError)
from sort1.rb:6

Exit code: 1

Try the following code to accomplish what you seem to want … this
solution appeared in a previous thread

require ‘win32ole’

class WIN32OLE
def list_ole_methods
method_names = ole_methods.collect { |m| m.name }
puts method_names.sort.uniq
end
end

excel = WIN32OLE.new(‘Excel.Application’)
excel.list_ole_methods
excel.quit

2

Bernard K. wrote:

require ‘win32ole’
excel = WIN32OLE.new(‘Excel.Application’)
m = excel.ole_methods
p m.class
p m.sort
…

Since you want to sort by method name, give a block to sort, i.e.:

p m.sort{|a| a.name <=> b.name}

Cheers
Chris

3

Since you want to sort by method name, give a block to sort, i.e.:

p m.sort{|a| a.name <=> b.name}

The line above doesn’t work but it will work if change to the follows

p m.sort{|a,b| a.name <=> b.name}

Li

4

On Wed, Dec 06, 2006 at 09:17:45AM +0900, Li Chen wrote:

The line above doesn’t work but it will work if change to the follows

p m.sort{|a,b| a.name <=> b.name}

p m.sort_by {|a| a.name}