From: Marcin Tyman <m.tyman@...>
Date: 2008-07-07T16:44:34+09:00
Subject: How to point to proper worksheet in excel

I have following code:

@xl = WIN32OLE.new('Excel.Application')
@xl['Visible'] = TRUE
@wb = @xl.Workbooks.Add
@ws = @xb.Worksheets("XXXXX")

The problem is that last line throws exception: moethod_missing:
Worksheets

Why? I had read examples from net and did everything according to them.


Another question is how to create a chart in excel and:
add several series to it
named it
assign names to axis
assign names to the series
set chart type.
-- 
Posted via http://www.ruby-forum.com/.