From: Bernard Kenik <renard@...>
Date: 2006-12-06T04:48:37+09:00
Subject: Re: Can't sort array

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