Win32OLE Extension Library for Ruby

[Top page] [Japanese][English]

What is Win32OLE ?

The Win32OLE extension library comes with Ruby 1.8.0 (or later). You can get Win32OLE extension library source if you download Ruby 1.8.0 source.

Win32OLE extension library provides an interface to OLE Automation from Ruby. Here is a sample script:

require 'win32ole'

application = WIN32OLE.new('Excel.Application')

application.visible = TRUE
workbook = application.Workbooks.Add();
worksheet = workbook.Worksheets(1);
worksheet.Range('A1:D1').value = ['North','South','East','West'];

As this sample, You can convert your VBA macro to Ruby script easily.


Download (for Ruby 1.6.8!!!)


Simple OLE Browser

Simple OLE Browser is like as OLE Viewer or Object Browser.

You need swin and vruby.

snapshot of Simple OLE Browser


[Top page] [Japanese][English]