Type:
Class
<code>WIN32OLE</code> objects represent OLE Automation object in Ruby.

By using WIN32OLE, you can access OLE server like VBScript.

Here is sample script.

  require 'win32ole'

  excel = WIN32OLE.new('Excel.Application')
  excel.visible = true
  workbook = excel.Workbooks.Add();
  worksheet = workbook.Worksheets(1);
  worksheet.Range("A1:D1").value = ["North","South","East","West"];
  worksheet.Range("A2:B2").value = [5.2, 10];
  worksheet.Range("C2").value = 8;
  worksheet.Range("D2").value = 20;

  range = worksheet.Range("A1:D2");
  range.select
  chart = workbook.Charts.Add;

  workbook.saved = true;

  excel.ActiveWorkbook.Close(0);
  excel.Quit();

Unfortunately, Win32OLE doesn't support the argument passed by reference directly. Instead, Win32OLE provides WIN32OLE::ARGV. If you want to get the result value of argument passed by reference, you can use WIN32OLE::ARGV.

oleobj.method(arg1, arg2, refargv3)
puts WIN32OLE::ARGV[2]   # the value of refargv3 after called oleobj.method
invoke

WIN32OLE#invoke(method, [arg1,...]) => return value of method. Instance Public methods

2015-06-12 20:57:57
locale

WIN32OLE.locale â locale id. Class Public methods Returns current locale id

2015-06-12 20:00:57
ole_activex_initialize

WIN32OLE#ole_activex_initialize() â Qnil Instance Public methods Initialize

2015-06-12 21:07:41
ole_put_methods

WIN32OLE#ole_put_methods Instance Public methods Returns the array of

2015-06-12 21:42:28
ole_get_methods

WIN32OLE#ole_get_methods Instance Public methods Returns the array of

2015-06-12 21:22:26
ole_func_methods

WIN32OLE#ole_func_methods Instance Public methods Returns the array of

2015-06-12 21:14:56
ole_methods

WIN32OLE#ole_methods Instance Public methods Returns the array of

2015-06-12 21:36:14
locale=

WIN32OLE.locale = lcid Class Public methods Sets current locale id (lcid).

2015-06-12 20:04:12
ole_free 2

WIN32OLE#ole_free Instance Public methods invokes Release method of Dispatch

2015-06-12 21:12:15
ole_type

WIN32OLE#ole_type Instance Public methods Returns

2015-06-12 21:53:32