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)