Flowdock

WIN32OLE 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

Constants

VERSION = rb_str_new2(WIN32OLE_VERSION)

ARGV = rb_ary_new()

CP_ACP = INT2FIX(CP_ACP)

CP_OEMCP = INT2FIX(CP_OEMCP)

CP_MACCP = INT2FIX(CP_MACCP)

CP_THREAD_ACP = INT2FIX(CP_THREAD_ACP)

CP_SYMBOL = INT2FIX(CP_SYMBOL)

CP_UTF7 = INT2FIX(CP_UTF7)

CP_UTF8 = INT2FIX(CP_UTF8)

LOCALE_SYSTEM_DEFAULT = INT2FIX(LOCALE_SYSTEM_DEFAULT)

LOCALE_USER_DEFAULT = INT2FIX(LOCALE_USER_DEFAULT)

Attributes

Show files where this class is defined (1 file)
Register or log in to add new notes.