From: Li Chen <chen_li3@...>
Date: 2006-11-11T23:20:03+09:00
Subject: graph orientation in Excel

Hi guys,

I copy one script as follows to draw a graph.  The result is a 
column-based serial, which means I get two lines composed of 3-2-1 and 
10-6-3. My question is how I tell the script so that I get row-based 
serial(3 lines), which are 3-10,2-6 and 1-3. Aslo how do find these 
methods by querying Ruby. I try ri WIN32OLE but don't get much 
information.


Thanks,

Li


############excel.rb
require 'win32ole'

excel = WIN32OLE.new("excel.application")

excel['Visible'] = TRUE;
workbook = excel.Workbooks.Add();
excel.Range("a1:b1").Value= [3,10]
excel.Range("a2:b2").Value= [2,6]
excel.Range("a3:b3").Value = [1,3]

ChartTypeVal=4
excel.Range("a1:b3").Select();
excelchart = workbook.Charts.Add();
excelchart['Type'] = ChartTypeVal;

savefile='C:\Ruby\self\excel1.xls';
excelchart.Saved(savefile);

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


-- 
Posted via http://www.ruby-forum.com/.