PeterHarding at 23:22, 11 March 2010

2010-03-11T23:22:24Z

← Older revision		Revision as of 09:22, 12 March 2010
Line 20:		Line 20:

	[[Category:Ruby]]		[[Category:Ruby]]
			[[Category:Microsoft Office Automation]]

PeterHarding: Created page with '=Example=

 require 'win32ole'  module ExcelConsts end  excel = WIN32OLE.new("Excel.Application") WIN32OLE.const_load(excel, ExcelConsts) excel.quit()  puts 'Matches for: ' ...'

2010-03-11T23:16:48Z

Created page with '=Example= <pre> require 'win32ole' module ExcelConsts end excel = WIN32OLE.new("Excel.Application") WIN32OLE.const_load(excel, ExcelConsts) excel.quit() puts 'Matches for: ' ...'

New page

=Example=

<pre>
require 'win32ole'

module ExcelConsts
end

excel = WIN32OLE.new("Excel.Application")
WIN32OLE.const_load(excel, ExcelConsts)
excel.quit()

puts 'Matches for: ' + ARGV[0]
ExcelConsts.constants.each {|const|
match = const.match(/#{ARGV[0]}/)
value = eval("ExcelConsts::#{const}")
puts ' '*4 + const + ' => ' + value.to_s unless match.nil?
}
</pre>

[[Category:Ruby]]

Ruby - Excel Constants - Revision history

PeterHarding at 23:22, 11 March 2010

PeterHarding: Created page with '=Example=
require 'win32ole' module ExcelConsts end excel = WIN32OLE.new("Excel.Application") WIN32OLE.const_load(excel, ExcelConsts) excel.quit() puts 'Matches for: ' ...'